It's all about the answers!

Ask a question

Exception occurred during BigDecimal conversion running CCM data collection job


marina delunas (711316) | asked May 14 '14, 10:51 a.m.
Hi,
someone can help me please?

I have CLM 4.0.3 (websphere and DB2 environment)

The Work items data collection job fails, the error on ccm_etl.log is;

014-05-14 11:40:17,795 [WebContainer : 35 @@ 10:46 jazzadmin /ccm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] 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.GeneratedMethodAccessor1766.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 $Proxy111.write(Unknown Source)

at com.ibm.team.datawarehouse.service.internal.RemoteDataWarehouseProvider.write(RemoteDataWarehouseProvider.java:29)

at sun.reflect.GeneratedMethodAccessor1765.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 $Proxy2209.write(Unknown Source)

at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService.updateData(AbstractRemoteSnapshotService.java:194)

at sun.reflect.GeneratedMethodAccessor2203.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 $Proxy862.updateData(Unknown Source)

at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$5.run(InternalDataWarehouseService.java:743)

at com.ibm.team.repository.service.internal.permission.ImpersonationService.runAs(ImpersonationService.java:75)

at sun.reflect.GeneratedMethodAccessor2024.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 $Proxy852.runAs(Unknown Source)

at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService.updateSnapshotData(InternalDataWarehouseService.java:733)

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 $Proxy853.updateSnapshotData(Unknown Source)

at com.ibm.team.reports.service.internal.ReportRestService.postUpdateSnapshotData(ReportRestService.java:1541)

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 $Proxy1164.postUpdateSnapshotData(Unknown Source)

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 com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledRestService(AbstractTeamServerServlet.java:555)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:2355)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:2155)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1983)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)

at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)

at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)

at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)

at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)

at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)

at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:68)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1214)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456)

at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:125)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:92)

at com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:139)

at com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:172)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:192)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:89)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:926)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1023)

at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3703)

at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)

at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:962)

at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)

at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)

at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)

at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1784)

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1659)

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)

... 120 more

2014-05-14 11:40:29,893 [WebContainer : 35 @@ 10:46 jazzadmin /ccm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: Records Selected: 1994

2014-05-14 11:40:29,893 [WebContainer : 35 @@ 10:46 jazzadmin /ccm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: Records Inserted: 0

2014-05-14 11:40:29,893 [WebContainer : 35 @@ 10:46 jazzadmin /ccm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: Records Updated: 1742

2014-05-14 11:40:29,893 [WebContainer : 35 @@ 10:46 jazzadmin /ccm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: Records Ignored: 251

2014-05-14 11:40:29,893 [WebContainer : 35 @@ 10:46 jazzadmin /ccm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: Time Inserting: 0ms

2014-05-14 11:40:29,893 [WebContainer : 35 @@ 10:46 jazzadmin /ccm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: Time Updating: Less than 1ms

2014-05-14 11:40:29,893 [WebContainer : 35 @@ 10:46 jazzadmin /ccm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: Time Looking Up: Less than 1ms

2014-05-14 11:40:29,893 [WebContainer : 35 @@ 10:46 jazzadmin /ccm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: Time Fetching Data: 1 second

2014-05-14 11:40:29,893 [WebContainer : 35 @@ 10:46 jazzadmin /ccm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: Time Running: 15 seconds

2014-05-14 11:40:29,893 [WebContainer : 35 @@ 10:46 jazzadmin /ccm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: ***Finished Build WorkItemHisCustomAttr at 5/14/14 11:40 AM. The build was unsuccessful***

2014-05-14 11:40:29,935 [WebContainer : 35 @@ 10:46 jazzadmin /ccm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: *****Finished Job Work Items at 5/14/14 11:40 AM. The job was unsuccessful.*****





Comments
Sandy Grewal commented May 15 '14, 7:48 a.m.
JAZZ DEVELOPER

Hi Marina,
This issue should be investigated. Please open a PMR with IBM Support so it can be investigated and fixed.
Thanks
Sandy

One answer



permanent link
Donald Nong (14.4k314) | answered May 16 '14, 2:11 a.m.
This looks quite similar to this:
https://www-304.ibm.com/support/docview.wss?uid=swg1IC74508
Caused by: com.ibm.db2.jcc.a.ConversionException: [jcc][converters][608][10994]Overflow occurred during numeric data type conversion of "22555555555555556".
Do you know how/where did the number "22555555555555556" come up?

Comments
marina delunas commented May 16 '14, 4:09 a.m.

Hi Donald,
unfortunately  I not know where this number come up ... do yuo have some suggestion to investigate it?

On RTC I have "decimal" custom attributes but they are very small (i. e.  5, 20, 20.5)


Donald Nong commented May 18 '14, 8:08 p.m.

Hi Marina,

If you don't know where to start, it's probably better to open a PMR with IBM Support and have it investigated further.

Your answer


Register or to post your answer.