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. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.