Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

JTS ETL Job Requirements Fail on RTC 4.0.7

Questions
Tags
Users
Badges
Leandro Leal
(146●2●43●45) 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





0 votes

1 answer
3,185 views
0 votes

One answer

Permanent link
Donald Nong
(14.5k●6●14) 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/

1 vote

Comments
Leandro Leal
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
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 log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 2,359

Question asked: Jun 19 '15, 3:56 p.m.

Question was seen: 3,185 times

Last updated: Jun 23 '15, 1:21 a.m.

Confirmation Cancel Confirm