work item data collection job failure Exception occurred during BigDecimal conversion
![]()
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
![]()
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 |