workitems data colletion job failure Rational team Concert
The CCM workitems data colletions job fails and in the ccm etl log file I have an error.
Someone can help me how to find what is the problem?
Many thanks
2014-09-01 01:21:35,452 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: ***Started Build WorkItemHisCustomAttr at 9/1/14 1:21 AM***
2014-09-01 01:21:42,455 [ccm: AsynchronousTaskRunner-0 @@ 00:02] ERROR e.workitem.internal.WorkItemsRemoteSnapshotService - [jcc][t4][1037][11190][4.14.121] Exception occurred during BigDecimal conversion. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
com.ibm.db2.jcc.am.SqlException: [jcc][t4][1037][11190][4.14.121] Exception occurred during BigDecimal conversion. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
at com.ibm.db2.jcc.am.ed.a(ed.java:661)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:85)
at com.ibm.db2.jcc.t4.db.a(db.java:1827)
at com.ibm.db2.jcc.t4.gb.a(gb.java:1483)
at com.ibm.db2.jcc.t4.gb.a(gb.java:1286)
at com.ibm.db2.jcc.t4.gb.a(gb.java:1274)
at com.ibm.db2.jcc.t4.gb.a(gb.java:1197)
at com.ibm.db2.jcc.t4.gb.a(gb.java:814)
at com.ibm.db2.jcc.t4.gb.a(gb.java:217)
at com.ibm.db2.jcc.t4.rb.a(rb.java:177)
at com.ibm.db2.jcc.am.po.a(po.java:3462)
at com.ibm.db2.jcc.am.po.b(po.java:4253)
at com.ibm.db2.jcc.am.po.kc(po.java:2821)
at com.ibm.db2.jcc.am.po.execute(po.java:2800)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:56)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:70)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:55)
at com.ibm.team.datawarehouse.service.workitem.internal.etlbuild.WorkItemHisCustomAttr.insertRecord(WorkItemHisCustomAttr.java:266)
at com.ibm.team.datawarehouse.service.workitem.internal.etlbuild.WorkItemHisCustomAttr.processRecord(WorkItemHisCustomAttr.java:245)
at com.ibm.team.datawarehouse.service.workitem.internal.etlbuild.WorkItemHisCustomAttr.execute(WorkItemHisCustomAttr.java:180)
at com.ibm.team.datawarehouse.service.workitem.internal.WorkItemsRemoteSnapshotService.updateSnapshotWithCheckpoint(WorkItemsRemoteSnapshotService.java:476)
at com.ibm.team.datawarehouse.service.workitem.internal.WorkItemsRemoteSnapshotService.updateSnapshot(WorkItemsRemoteSnapshotService.java:203)
at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService$1.run(AbstractRemoteSnapshotService.java:199)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$6.run(RemoteDatabaseService.java:523)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:434)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:485)
at sun.reflect.GeneratedMethodAccessor1771.invoke(Unknown Source)
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 $Proxy112.write(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.RemoteDataWarehouseProvider.write(RemoteDataWarehouseProvider.java:29)
at sun.reflect.GeneratedMethodAccessor1770.invoke(Unknown Source)
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 $Proxy2035.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 $Proxy982.updateData(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$7.run(InternalDataWarehouseService.java:822)
at com.ibm.team.repository.service.internal.permission.ImpersonationService.runAs(ImpersonationService.java:75)
at sun.reflect.GeneratedMethodAccessor1883.invoke(Unknown Source)
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 $Proxy802.runAs(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService.updateRemoteSnapshotDataFromTask(InternalDataWarehouseService.java:802)
at sun.reflect.GeneratedMethodAccessor1882.invoke(Unknown Source)
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 $Proxy860.updateRemoteSnapshotDataFromTask(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.SnapshotRunnerTask.transactionSucceeded(SnapshotRunnerTask.java:58)
at sun.reflect.GeneratedMethodAccessor909.invoke(Unknown Source)
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 $Proxy877.transactionSucceeded(Unknown Source)
at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.transactionSucceeded(AsynchronousTaskSchedulerService.java:972)
at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.executeTask(AsynchronousTaskSchedulerService.java:981)
at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask(AsynchronousTaskRunner.java:158)
at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:119)
at java.lang.Thread.run(Thread.java:769)
Caused by: com.ibm.db2.jcc.a.ConversionException: [jcc][converters][608][10994]Overflow occurred during numeric data type conversion of "22555555555555556".
at com.ibm.db2.jcc.a.d.a(d.java:61)
at com.ibm.db2.jcc.t4.db.a(db.java:1822)
... 77 more
2014-09-01 01:21:51,833 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Selected: 4111
2014-09-01 01:21:51,833 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Inserted: 0
2014-09-01 01:21:51,833 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Updated: 3720
2014-09-01 01:21:51,833 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Ignored: 390
2014-09-01 01:21:51,833 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Inserting: 0ms
2014-09-01 01:21:51,833 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Updating: Less than 1ms
2014-09-01 01:21:51,833 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Looking Up: Less than 1ms
2014-09-01 01:21:51,833 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Fetching Data: 2 seconds
2014-09-01 01:21:51,833 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Running: 16 seconds
2014-09-01 01:21:51,833 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: ***Finished Build WorkItemHisCustomAttr at 9/1/14 1:21 AM. The build was unsuccessful***
2014-09-01 01:21:51,856 [ccm: AsynchronousTaskRunner-0 @@ 00:02] INFO e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: *****Finished Job Work Items at 9/1/14 1:21 AM. The job was unsuccessful.*****