アーティクル - CS259113

Servigistics Service Parts Management でストック レベルの生成がエラー「SQL Loader failed」で失敗する

修正日: 08-Dec-2023   


注記:ここに記載されている情報は、お客様の利便性向上のため機械翻訳ソフトを使用しています。PTCは、ここに記載されている情報の翻訳の正確性について、一切の責任を負いませんので、ご了承ください。英語の原文を参照するには、こちら。この機械翻訳に関する詳細は、こちら。
お知らせいただき、ありがとうございます。この機械翻訳をレビューします。

適用対象

  • Servigistics Service Parts Management 11.2.1 to 13.0.0.0

説明

  • ストック レベルの生成がエラーで失敗しましたSQL ローダーが失敗しました
  • Autopilot.log には次のようなメッセージが含まれます。
    • 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)

      または
    • 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
      
  • SQL Loaderが使用されていない場合、AutoPilot.log には次のような別のエラー メッセージが含まれます。
  • 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)

最新バージョンはこちらを参照ください CS259113