It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,862
×10,953
×7,451
×6,031
×3,954

question asked: Mar 10 '15, 9:45 a.m.
question was seen: 6,172 times
last updated: Apr 16 '15, 3:04 p.m.

Related questions

Data Collection Jobs are failing in RTC 5.0.2

0
Javaria Hameed (40●38●47) | asked Mar 10 '15, 9:45 a.m.
My Data collection jobs are failing in RTC 5.0.2...only Star job succeeds.
What might be the cause? I have enabled data warehouse for all applications.
Also I dont have Requirements job listed

Accepted answer

1
permanent link
Javaria Hameed (40●38●47) | answered Mar 11 '15, 6:42 a.m.
Hi Stephanie. Now I am able to run my jobs successfully...

All I did was providing correct Consumer Name and Key on Data Collection Jobs page for all jobs.

thanks everyone for your assistance :)
Rosa Naranjo selected this answer as the correct answer
Comments
Rosa Naranjo commented Apr 16 '15, 3:04 p.m.
FORUM MODERATOR / JAZZ DEVELOPER

The fix for this is documented in this technote  www-01.ibm.com/support/docview.wss?uid=swg21591743
found by this other forum post https://jazz.net/forum/questions/86317/data-collection-etl-jobs-failing-in-rtc-40

4 other answers

Most liked answers ↓|Newest answers|Oldest answers

0
permanent link
Javaria Hameed (40●38●47) | answered Mar 10 '15, 12:11 p.m.
Stephanie, this is what I have in jts-etl log:

2015-03-10 22:06:44,963 [jts: AsynchronousTaskRunner-2 @@ 22:04] ERROR e.repository.internal.LicenseRemoteSnapshotService  - 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 '401' and the message is 'Unauthorized'.
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 '401' and the message is 'Unauthorized'.
    at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.fetchMoreData(BaseRDSResultSet.java:2091)
    at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.next(BaseRDSResultSet.java:1462)
    at com.ibm.team.datawarehouse.service.XdcResultSet.next(XdcResultSet.java:179)
    at com.ibm.team.datawarehouse.service.repository.internal.etlbuild.IntegralRangeCounter.execute(IntegralRangeCounter.java:75)
    at com.ibm.team.datawarehouse.service.repository.internal.LicenseRemoteSnapshotService.updateSnapshot(LicenseRemoteSnapshotService.java:68)
    at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService$1.run(AbstractRemoteSnapshotService.java:203)
    at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$6.run(RemoteDatabaseService.java:548)
    at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:470)
    at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:510)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:611)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy153.write(Unknown Source)
    at com.ibm.team.datawarehouse.service.internal.RemoteDataWarehouseProvider.write(RemoteDataWarehouseProvider.java:29)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:611)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy4086.write(Unknown Source)
    at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService.updateData(AbstractRemoteSnapshotService.java:194)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:611)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy450.updateData(Unknown Source)
    at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService.updateAllRemoteSnapshotDataFromTask(InternalDataWarehouseService.java:932)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:611)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy439.updateAllRemoteSnapshotDataFromTask(Unknown Source)
    at com.ibm.team.datawarehouse.service.internal.SnapshotRunnerTask.transactionSucceeded(SnapshotRunnerTask.java:53)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:611)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy449.transactionSucceeded(Unknown Source)
    at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.transactionSucceeded(AsynchronousTaskSchedulerService.java:997)
    at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.executeTask(AsynchronousTaskSchedulerService.java:1006)
    at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask(AsynchronousTaskRunner.java:185)
    at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:138)
    at java.lang.Thread.run(Thread.java:770)
2015-03-10 22:06:44,979 [jts: AsynchronousTaskRunner-2 @@ 22:04] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Records Selected: 0
2015-03-10 22:06:44,979 [jts: AsynchronousTaskRunner-2 @@ 22:04] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Records Inserted: 0
2015-03-10 22:06:44,979 [jts: AsynchronousTaskRunner-2 @@ 22:04] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Records Updated: 0
2015-03-10 22:06:44,979 [jts: AsynchronousTaskRunner-2 @@ 22:04] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Inserting: 0ms
2015-03-10 22:06:44,979 [jts: AsynchronousTaskRunner-2 @@ 22:04] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Updating: 0ms
2015-03-10 22:06:44,979 [jts: AsynchronousTaskRunner-2 @@ 22:04] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Looking Up: 0ms
2015-03-10 22:06:44,979 [jts: AsynchronousTaskRunner-2 @@ 22:04] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Fetching Data: 0ms
2015-03-10 22:06:44,979 [jts: AsynchronousTaskRunner-2 @@ 22:04] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Running: 14 seconds
2015-03-10 22:06:44,979 [jts: AsynchronousTaskRunner-2 @@ 22:04] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: ***Finished Build IntegralRangeCounter at 3/10/15 10:06 PM. The build was unsuccessful***
2015-03-10 22:06:44,979 [jts: AsynchronousTaskRunner-2 @@ 22:04]  INFO e.repository.internal.LicenseRemoteSnapshotService  - ETL: *****Finished Job License at 3/10/15 10:06 PM. The job was unsuccessful.*****
Comments
Stephanie Bagot commented Mar 10 '15, 1:37 p.m.
FORUM MODERATOR / JAZZ DEVELOPER

First, make sure etl_user has JazzAdmin repository permissions.
Next I would say double check that it has the right license for reporting, but you mentioned it already did.

Next, check your reports management page:
https://server:9443/ccm/admin#action=jazz.viewPage&id=com.ibm.team.reports.reportsManagementPage
Under the Jobs, do you have consumer key listed? or username?
-> If you have username, re-enter the passwords for each job, save, and re-run the job. Any change to the error in the log file?

0
permanent link
Javaria Hameed (40●38●47) | answered Mar 10 '15, 11:48 a.m.
Thanks Stephanie and Francesco.

I have checked the consumer key, its trusted.

I tried by creating a user named etl_user and assigned all data collector rights but still all jobs are failing.
Comments
Stephanie Bagot commented Mar 10 '15, 12:02 p.m.
FORUM MODERATOR / JAZZ DEVELOPER

Did you check the log files to see what the error was?

0
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Mar 10 '15, 9:57 a.m.
Hello Javaria,

In addition to checking the logs, as Stephanie correctly suggested, you might want to verify that the user that is configured to run the data collection jobs has JazzAdmin repository permissions, the data collector licenses assigned and a valid username and password configured in the Data Collection Jobs pages.
If you use a Oauth key/Secret in place of the user, you can check that the key is trusted.

In CLM 5.X the Requirement job has been moved from jts to rm/admin.

Best Regards,

Francesco Chiossi
0
permanent link
Stephanie Bagot (2.1k●1●5●13) | answered Mar 10 '15, 9:47 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
In your server/logs directory, check your ETL log files for errors. This will help to point you in the right direction for troubleshooting.

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.