It's all about the answers!

Ask a question

Data Collection Jobs are failing in RTC 5.0.2


Javaria Hameed (402146) | 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


permanent link
Javaria Hameed (402146) | 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

4 other answers



permanent link
Stephanie Bagot (2.1k512) | 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.

permanent link
Francesco Chiossi (5.7k1719) | 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

permanent link
Javaria Hameed (402146) | 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?


permanent link
Javaria Hameed (402146) | 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?

Your answer


Register or to post your answer.