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.5k514) | 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.


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.