It's all about the answers!

Ask a question

workitems data colletion job failure Rational team Concert


marina delunas (711316) | asked Sep 01 '14, 11:26 a.m.
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



permanent link
Piotr Aniola (3.7k11738) | answered Sep 02 '14, 8:08 a.m.
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


Register or to post your answer.