Article - CS388781
Copy Demand process is failing with error message "unable to translate sqlexception with error code '1652', will now try the fallback translator" in Servigistics Service Parts Management (SPM)
Modified: 20-Mar-2023
Applies To
- Servigistics Service Parts Management 12.2.1.3 to 13.0.0.0
Description
- Copy Demand Process fails with error:
- Unable to translate SQLException with Error code '1652', will now try the fallback translator
- Autopilot log contains:
- DEBUG com.svg.core.database.exception.CustomSQLExceptionTranslator - Unable to translate SQLException with Error code '1652', will now try the fallback translator
ERROR com.svg.core.util.EventLog - Task Copy Demand failed with message: java.lang.NullPointerException
java.lang.NullPointerException: null
at com.svg.core.database.StandardJdbcTemplate.execute(StandardJdbcTemplate.java:278) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.StandardJdbcTemplate.update(StandardJdbcTemplate.java:238) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.metadata.AbstractTableCreator.createOrReplaceTable(AbstractTableCreator.java:51) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.metadata.AbstractTableCreator.createOrReplaceTable(AbstractTableCreator.java:46) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.metadata.OracleTableCreator.createTable(OracleTableCreator.java:47) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.metadata.AbstractTableCreator.createTable(AbstractTableCreator.java:40) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.temptable.TempTableImpl.initTable(TempTableImpl.java:85) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.temptable.LocalTempTable.initTable(LocalTempTable.java:52) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.temptable.TempTableImpl.build(TempTableImpl.java:51) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.temptable.LocalTempTable.build(LocalTempTable.java:7) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.temptable.TempTableFactoryImpl.newTempTable(TempTableFactoryImpl.java:86) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.planning.process.copydemand.CopyDemandConnector.newDemandHistoryTable(CopyDemandConnector.java:505) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.planning.process.copydemand.CopyDemandConnector.insertCopyDemand(CopyDemandConnector.java:449) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.planning.process.copydemand.CopyDemandConnector.newCopyDemandTable(CopyDemandConnector.java:417) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.planning.process.copydemand.CopyDemandConnector.updateCopyDemand(CopyDemandConnector.java:378) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.planning.process.copydemand.CopyDemandConnector.process(CopyDemandConnector.java:62) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:122) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.process.BatchConnectorImpl.lambda$run$0(BatchConnectorImpl.java:92) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.TransactionUtil.lambda$withNone$1(TransactionUtil.java:106) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:56) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.database.TransactionUtil.withNone(TransactionUtil.java:105) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:92) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.task.BatchTask.runConnector(BatchTask.java:84) ~[AutoPilotServer.jar:12.2.1.3]
at com.svg.core.task.AbstractTask.run(AbstractTask.java:221) [AutoPilotServer.jar:12.2.1.3]
at com.svg.core.task.BatchTask.run(BatchTask.java:70) [AutoPilotServer.jar:12.2.1.3]
at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_322]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_322]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) [spring-aop-5.3.20.jar:5.3.20]
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) [spring-aop-5.3.20.jar:5.3.20]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) [spring-aop-5.3.20.jar:5.3.20]
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:58) [spring-aop-5.3.20.jar:5.3.20]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) [spring-aop-5.3.20.jar:5.3.20]
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) [spring-tx-5.3.20.jar:5.3.20]
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) [spring-tx-5.3.20.jar:5.3.20]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) [spring-tx-5.3.20.jar:5.3.20]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [spring-aop-5.3.20.jar:5.3.20]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) [spring-aop-5.3.20.jar:5.3.20]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [spring-aop-5.3.20.jar:5.3.20]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) [spring-aop-5.3.20.jar:5.3.20]
at com.sun.proxy.$Proxy1280.run(Unknown Source) [?:?]
at com.svg.core.service.impl.TaskServiceImpl$1.run(TaskServiceImpl.java:586) [AutoPilotServer.jar:12.2.1.3]
at java.lang.Thread.run(Thread.java:750) [?:1.8.0_322]
at com.svg.core.util.ThreadUtil$1.run(ThreadUtil.java:43) [AutoPilotServer.jar:12.2.1.3]
- DEBUG com.svg.core.database.exception.CustomSQLExceptionTranslator - Unable to translate SQLException with Error code '1652', will now try the fallback translator
This is a printer-friendly version of Article 388781 and may be out of date. For the latest version click CS388781