Article - CS259113
Stock Level Generation failed with error "SQL Loader failed" in Servigistics Service Parts Management
Modified: 08-Dec-2023
Applies To
- Servigistics Service Parts Management 11.2.1 to 13.0.0.0
Description
- Stock Level Generation failed with error SQL Loader failed
- Autopilot.log contains a message like:
-
ERROR com.svg.core.util.EventLog - Task Stock Level Generation failed with message: SQL Loader failed. java.lang.RuntimeException: SQL Loader failed. at com.svg.core.dataprovider.bulkinsert.OracleBulkInsert.doBulkInsert(OracleBulkInsert.java:50) at com.svg.core.dataprovider.bulkinsert.AbstractBulkInsert.commitUpdates(AbstractBulkInsert.java:290) at com.svg.core.dataprovider.bulkinsert.AbstractBulkInsert.flush(AbstractBulkInsert.java:194) at com.svg.core.dataprovider.BulkOutput.flush(BulkOutput.java:158) at com.svg.core.process.Output.writeResults(Output.java:115) at com.svg.planning.process.stocklevel.SLConnector.runLevels(SLConnector.java:118) at com.svg.planning.process.stocklevel.SLConnector.doProcess(SLConnector.java:79) at com.svg.core.process.ThreadableConnector.process(ThreadableConnector.java:32) at com.svg.core.process.ThreadableConnector.process(ThreadableConnector.java:23) at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:106) at com.svg.core.process.BatchConnectorImpl.access$000(BatchConnectorImpl.java:33) at com.svg.core.process.BatchConnectorImpl$1.doInTransaction(BatchConnectorImpl.java:91) at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:51) at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:88) at com.svg.core.task.BatchTask.runConnector(BatchTask.java:84) at com.svg.core.task.AbstractTask.run(AbstractTask.java:216) at com.svg.core.task.BatchTask.run(BatchTask.java:70) at sun.reflect.GeneratedMethodAccessor277.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy663.run(Unknown Source) at com.svg.core.service.impl.TaskServiceImpl$1.run(TaskServiceImpl.java:434) at java.lang.Thread.run(Thread.java:745) at com.svg.core.util.ThreadUtil$1.run(ThreadUtil.java:43)
or -
ERROR com.svg.core.util.EventLog - Task Stock Level Generation failed with message: executeUpdate; SQL [insert into ##IPCSTMP_L48687 values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, org.springframework.dao.DataIntegrityViolationException: executeUpdate; SQL [insert into ##IPCSTMP_L48687 values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Arithmetic overflow error converting float to data type numeric.; nested exception is java.sql.BatchUpdateException: Arithmetic overflow error converting float to data type numeric. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:246) ~[spring-jdbc-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.0.19.RELEASE.jar:5.0.19.RELEASE] at com.svg.core.database.BatchUpdate.update(BatchUpdate.java:165) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.dataprovider.bulkinsert.AbstractBulkInsert.doBatchUpdate(AbstractBulkInsert.java:275) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.dataprovider.bulkinsert.AbstractBulkInsert.access$000(AbstractBulkInsert.java:32) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.dataprovider.bulkinsert.AbstractBulkInsert$1.doInTransaction(AbstractBulkInsert.java:235) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:61) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.dataprovider.bulkinsert.AbstractBulkInsert.writeBatch(AbstractBulkInsert.java:232) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.dataprovider.bulkinsert.AbstractBulkInsert.flush(AbstractBulkInsert.java:191) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.dataprovider.BulkOutput.flush(BulkOutput.java:160) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.process.Output.writeResults(Output.java:115) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.planning.process.stocklevel.SLConnector.runLevels(SLConnector.java:120) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.planning.process.stocklevel.SLConnector.doProcess(SLConnector.java:80) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.process.ThreadableConnector.doProcessSubTask(ThreadableConnector.java:84) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.process.ThreadableConnector.process(ThreadableConnector.java:26) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:122) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.process.BatchConnectorImpl.lambda$run$0(BatchConnectorImpl.java:92) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.database.TransactionUtil.lambda$withNone$1(TransactionUtil.java:106) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:56) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.database.TransactionUtil.withNone(TransactionUtil.java:105) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:92) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.task.SubTask.runConnector(SubTask.java:104) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.task.AbstractTask.run(AbstractTask.java:221) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.task.SubTask.run(SubTask.java:86) ~[AutoPilotServer.jar:12.2.1.1] at sun.reflect.GeneratedMethodAccessor133.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_371] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_371] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197) ~[spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56) ~[spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174) ~[spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295) [spring-tx-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) [spring-tx-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) [spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) [spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) [spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE] at com.sun.proxy.$Proxy1271.run(Unknown Source) [?:?] at com.svg.core.service.impl.TaskServiceImpl$1.run(TaskServiceImpl.java:586) [AutoPilotServer.jar:12.2.1.1] at java.lang.Thread.run(Thread.java:750) [?:1.8.0_371] at com.svg.core.util.ThreadUtil$1.run(ThreadUtil.java:43) [AutoPilotServer.jar:12.2.1.1] Caused by: java.sql.BatchUpdateException: Arithmetic overflow error converting float to data type numeric. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:2085) ~[mssql-jdbc-9.2.1.jre8.jar:?] at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_371] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_371] at org.springframework.util.ReflectionUtils.invokeJdbcMethod(ReflectionUtils.java:322) ~[spring-core-5.0.19.RELEASE.jar:5.0.19.RELEASE] at com.svg.core.database.support.ProxyHandler$1.invoke(ProxyHandler.java:29) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.database.support.ProxyHandler.invoke(ProxyHandler.java:53) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.database.support.StatementHandler.invoke(StatementHandler.java:90) ~[AutoPilotServer.jar:12.2.1.1] at com.svg.core.database.support.PreparedStatementHandler.invoke(PreparedStatementHandler.java:63) ~[AutoPilotServer.jar:12.2.1.1] at com.sun.proxy.$Proxy89.executeBatch(Unknown Source) ~[?:?] at com.svg.core.database.BatchUpdate.update(BatchUpdate.java:155) ~[AutoPilotServer.jar:12.2.1.1] ... 39 more
-
- If SQL Loader is not used, then AutoPilot.log contains different Error message like below:
-
ERROR com.svg.core.util.EventLog - Task Stock Level Generation failed with message: java.sql.BatchUpdateException: ORA-01438: value larger than specified precision allowed for this column java.sql.BatchUpdateException: ORA-01438: value larger than specified precision allowed for this column at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246) at sun.reflect.GeneratedMethodAccessor233.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498)
This is a printer-friendly version of Article 259113 and may be out of date. For the latest version click CS259113