workitems data colletion job failure Rational team Concert
![]()
Hi have Rational Team Concert 4.0.3. on Websphere and DB2 environment.
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.***** |
One answer
![]()
I see that the same issue was already reported before:
https://jazz.net/forum/questions/151426/exception-occurred-during-bigdecimal-conversion-running-ccm-data-collection-job I think the conclusion is correct, it's best if you raise a PMR with IBM Rational Support or create a jazz.net defect. |