It's all about the answers!

Ask a question

work item data collection job failure Exception occurred during BigDecimal conversion


marina delunas (711316) | asked Sep 10 '14, 6:35 a.m.
edited Sep 10 '14, 10:01 a.m.
CLM 4.0.3 webshere DB2 environment

Tha work items data collection job fails. I don't have Big decimal attributes but only decimal. How can find the 2555555555556  value the create the problem? on ccm etl log I have only this informations

Many thanks

2014-09-10 01:39:31,951 [ccm: AsynchronousTaskRunner-1 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: ***Started Build WorkItemHisCustomAttr at 9/10/14 1:39 AM***

2014-09-10 01:39:36,127 [ccm: AsynchronousTaskRunner-1 @@ 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)

     .............................................
...............................................................
................................................................

skRunner.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)





One answer



permanent link
Kevin Ramer (4.5k8183200) | answered Sep 10 '14, 1:25 p.m.
edited Sep 10 '14, 1:27 p.m.
Googling for the ERRORCODE=-4220 leads to this:

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014550004

See response by SUGS_Brian_Trapp and following

Your answer


Register or to post your answer.