Data Collection Jobs are failing in RTC 5.0.2

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 :)

In your server/logs directory, check your ETL log files for errors. This will help to point you in the right direction for troubleshooting.

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

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.

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.*****