It's all about the answers!

Ask a question

JTS ETL Job Requirements Fail on RTC 4.0.7


Leandro Leal (14613745) | asked Jun 19 '15, 3:56 p.m.
edited Jun 19 '15, 4:13 p.m.
Hi,

When execute the data collection job JTS all finishing successfully except the job "Requirements". We migrated from RTC 4.0.6 to RTC 4.0.7 iFix005. The etl_user have all data collector licence. I follow the link http://www-01.ibm.com/support/docview.wss?uid=swg21591743:



This is the jts-etl-driver.log:

2015-06-19 14:36:29,531 [                     Thread-91] ERROR tional.drivers.jdbc.xml.internal.PageFetcherThread  - com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1417E: The HTTP status '503' and the message is 'Service Unavailable'.
2015-06-19 14:36:29,531 [                     Thread-91] ERROR tional.drivers.jdbc.xml.internal.PageFetcherThread  - com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1417E: The HTTP status '503' and the message is 'Service Unavailable'.
com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1417E: The HTTP status '503' and the message is 'Service Unavailable'.
    at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:565)
    at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.run(PageFetcherThread.java:136)
Caused by: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1417E: The HTTP status '503' and the message is 'Service Unavailable'.
    at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:516)
    ... 1 more
Caused by: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1417E: The HTTP status '503' and the message is 'Service Unavailable'.
    at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:430)
    ... 1 more
Caused by: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1417E: The HTTP status '503' and the message is 'Service Unavailable'.
    at com.ibm.rational.dataservices.client.auth.JTSAuthentication.getResponseInputStream(JTSAuthentication.java:94)
    at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:408)
    ... 1 more





One answer



permanent link
Donald Nong (14.4k314) | answered Jun 21 '15, 9:42 p.m.
What are the errors reported in jts-etl.log? This file should contain more information than the jts-etl-driver.log does.

The technote that you mentioned may not apply to your scenario, and your best option may be contacting Support.
https://jazz.net/help/support/

Comments
Leandro Leal commented Jun 22 '15, 9:14 a.m. | edited Jun 23 '15, 1:20 a.m.

Hi,
This is the jts-etl.log after executing the job.................

2015-06-22 08:38:11,576 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Requirements Composer ETL jobs
2015-06-22 08:38:11,576 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - -=START=-
2015-06-22 08:38:11,576 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Will collect metrics: true
2015-06-22 08:38:11,576 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Using threshold value 0
2015-06-22 08:38:11,576 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Will filter incomplete rows: true
2015-06-22 08:38:11,576 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Will load requirement primary text: false
2015-06-22 08:38:11,576 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Will generate names if empty: false
2015-06-22 08:38:11,576 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Will cleanup if a full load is detected: true
2015-06-22 08:38:11,576 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Module views type will be set to:
2015-06-22 08:38:11,576 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Processing resource group _1HZME_MHEeObFolU6sZEvARRC
2015-06-22 08:38:11,596 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG ouse.service.rrc.internal.RemoteRRCSnapshotService  - Checking the reporting server version...
2015-06-22 08:38:11,716 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG ouse.service.rrc.internal.RemoteRRCSnapshotService  - Executing the query against the REST table...
2015-06-22 08:38:30,662 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] ERROR ouse.service.rrc.internal.RemoteRRCSnapshotService  - com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1417E: The HTTP status '503' and the message is 'Service Unavailable'.
2015-06-22 08:38:30,682 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN ouse.service.rrc.internal.RemoteRRCSnapshotService  -
2015-06-22 08:38:30,682 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN ouse.service.rrc.internal.RemoteRRCSnapshotService  - The RM server version is too low and does not allow links migration!
2015-06-22 08:38:30,682 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN ouse.service.rrc.internal.RemoteRRCSnapshotService  -
2015-06-22 08:38:30,693 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - -=LINKS=-
2015-06-22 08:38:30,693 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Load all RRC link types
2015-06-22 08:38:30,693 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG ouse.service.rrc.internal.RemoteRRCSnapshotService  - Getting next page for links...
2015-06-22 08:38:30,712 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG ouse.service.rrc.internal.RemoteRRCSnapshotService  - Executing the query against the REST table...
2015-06-22 08:38:48,774 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] ERROR ouse.service.rrc.internal.RemoteRRCSnapshotService  - java.sql.SQLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1417E: The HTTP status '503' and the message is 'Service Unavailable'.
2015-06-22 08:38:48,774 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'Getting the migration version' from 'RemoteRRCSnapshotService::updateSnapshot(?)'
2015-06-22 08:38:48,774 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -     Event subject: _1HZME_MHEeObFolU6sZEvARRC
2015-06-22 08:38:48,794 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'Check if migration is required for 4' from 'RemoteRRCSnapshotService::updateSnapshot(?)'
2015-06-22 08:38:48,804 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -     Event subject: _1HZME_MHEeObFolU6sZEvARRC
2015-06-22 08:38:48,804 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'CALL' from 'RemoteRRCSnapshotService::resetPages()'
2015-06-22 08:38:48,824 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'First pass' from 'RemoteRRCSnapshotService::updateSnapshot(?)'
2015-06-22 08:38:48,824 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -     Event subject: RRC
2015-06-22 08:38:48,836 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'CALL' from 'RRCLinkTypeETL::initPrepareStatements(?)'
2015-06-22 08:38:48,836 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'CALL' from 'RRCLinkTypeETL::resetInitialCounts()'
2015-06-22 08:38:48,853 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'Load all RRC link types' from 'RemoteRRCSnapshotService::updateSnapshot(?)'
2015-06-22 08:38:48,853 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'CALL' from 'RemoteRRCSnapshotService::getNextLinkTypesPage(Connection con, String resourceGroupName)'
2015-06-22 08:38:48,867 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -     Event subjects:
2015-06-22 08:38:48,867 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -     com.ibm.rational.drivers.jdbc.xml.RDSConnection@5b5b5b5b
2015-06-22 08:38:48,883 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -     RRC
2015-06-22 08:38:48,883 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'Querying the XDC table' from 'RemoteRRCSnapshotService::getNextLinkTypesPage(?,?)'
2015-06-22 08:38:48,902 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Suspect event: 'Getting the XDC rows' from 'RemoteRRCSnapshotService::getNextLinkTypesPage(?,?)'
2015-06-22 08:38:48,914 [http-bio-9443-exec-10 @@ 08:38 intrtcjazz /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Closing SQL statements...




Donald Nong commented Jun 23 '15, 1:21 a.m.

Since more log files, such as the jts.log file, have to be looked into, I still recommend you to get in touch with Support so that the issue can be investigated more efficiently.

Your answer


Register or to post your answer.