Hello All,
'I recently noticed that the data collection jobs for the work items in CCM application is alone failing.
Note : SCM , Build and Common are succeeding.
I checked the ETL logs from the location Opt/IBM/JazzTeamServer/server/logs and here is that information from ccm-etl.log
2013-11-15 11:46:51,675 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: ***Finished Build WorkItemState at 11/15/13 11:46 AM. The build was successful***
2013-11-15 11:46:51,675 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: ***Started Build WorkItemType at 11/15/13 11:46 AM***
2013-11-15 11:46:51,922 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Selected: 2076
2013-11-15 11:46:51,922 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Inserted: 35
2013-11-15 11:46:51,922 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Updated: 2041
2013-11-15 11:46:51,922 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Inserting: Less than 1ms
2013-11-15 11:46:51,923 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Updating: Less than 1ms
2013-11-15 11:46:51,923 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Looking Up: Less than 1ms
2013-11-15 11:46:51,923 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Fetching Data: 17 seconds
2013-11-15 11:46:51,923 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Running: Less than 1ms
2013-11-15 11:46:51,923 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: ***Finished Build WorkItemType at 11/15/13 11:46 AM. The build was successful***
2013-11-15 11:46:51,923 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: ***Started Build WorkItemResolution at 11/15/13 11:46 AM***
2013-11-15 11:46:52,226 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Selected: 4540
2013-11-15 11:46:52,226 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Inserted: 52
2013-11-15 11:46:52,226 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Updated: 4488
2013-11-15 11:46:52,226 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Inserting: Less than 1ms
2013-11-15 11:46:52,226 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Updating: 2 seconds
2013-11-15 11:46:52,226 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Looking Up: 3 seconds
2013-11-15 11:46:52,226 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Fetching Data: 17 seconds
2013-11-15 11:46:52,226 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Running: Less than 1ms
2013-11-15 11:46:52,226 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: ***Finished Build WorkItemResolution at 11/15/13 11:46 AM. The build was successful***
2013-11-15 11:46:52,227 [ http-bio-9443-exec-88232] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: ***Started Build WorkItemEnumeration at 11/15/13 11:46 AM***
2013-11-15 11:47:16,305 [ http-bio-9443-exec-88232] ERROR e.workitem.internal.WorkItemsRemoteSnapshotService - 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 '500' and the message is 'Internal Server Error'.
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 '500' and the message is 'Internal Server Error
Kindly let me know what needs to be done to correct this.
Thanks in advance!
Varun