It's all about the answers!

Ask a question

JTS ETL Job Requirements Fail on RTC 4.0.7


Leandro Leal (14624245) | 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.5k614) | 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.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.