Article - CS266042
SyncDB (Synchronize database) is failing with the error "java.sql.SQLSyntaxErrorException:ORA-00933:SQL command not properly ended" in Servigistics Service Parts Management
Modified: 11-Jun-2019
Applies To
- Servigistics Service Parts Management 10.7.0.10
Description
- SyncDB (Synchronize database) is failing with the error java.sql.SQLSyntaxErrorException:ORA-00933:SQL command not properly ended
- autopilot.log contains:
- at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:95)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:521)
at com.svg.core.process.syncdb.Segments$2.extractData(Segments.java:173)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:446)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
at com.svg.core.process.syncdb.Segments.process(Segments.java:144)
at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:110)
at com.svg.core.process.BatchConnectorImpl.access$000(BatchConnectorImpl.java:29)
at com.svg.core.process.BatchConnectorImpl$1.doInTransaction(BatchConnectorImpl.java:87)
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:45)
at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:84)
at com.svg.core.process.syncdb.SyncConnector.process(SyncConnector.java:207)
at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:110)
at com.svg.core.process.BatchConnectorImpl.access$000(BatchConnectorImpl.java:29)
at com.svg.core.process.BatchConnectorImpl$1.doInTransaction(BatchConnectorImpl.java:87)
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:45)
at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:84)
at com.svg.core.task.SubTask$1.doInConnection(SubTask.java:98)
at com.svg.core.task.SubTask$1.doInConnection(SubTask.java:94)
at com.svg.core.database.ConnectionTemplate$1.doInTransaction(ConnectionTemplate.java:32)
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:45)
at com.svg.core.database.ConnectionTemplate.execute(ConnectionTemplate.java:27)
at com.svg.core.database.ConnectionUtil.execute(ConnectionUtil.java:53)
at com.svg.core.database.ConnectionUtil.execute(ConnectionUtil.java:47)
at com.svg.core.task.SubTask.runConnector(SubTask.java:94)
at com.svg.core.task.AbstractTask.run(AbstractTask.java:203)
at com.svg.core.task.SubTask.run(SubTask.java:80)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
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.$Proxy523.run(Unknown Source)
at com.svg.core.service.impl.TaskServiceImpl$1.run(TaskServiceImpl.java:409)
at java.lang.Thread.run(Thread.java:724)
at com.svg.core.util.ThreadUtil$1.run(ThreadUtil.java:43)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280)
at sun.reflect.GeneratedMethodAccessor251.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.svg.core.database.support.ProxyHandler$1.invoke(ProxyHandler.java:28)
at com.svg.core.database.support.QueryMethodInvoker.invoke(QueryMethodInvoker.java:27)
at com.svg.core.database.support.ProxyHandler$2.doInDeadlockRetry(ProxyHandler.java:65)
at com.svg.core.database.support.DeadlockRetry.execute(DeadlockRetry.java:27)
at com.svg.core.database.support.ProxyHandler.invoke(ProxyHandler.java:62)
at com.svg.core.database.support.StatementHandler.invoke(StatementHandler.java:40)
at com.sun.proxy.$Proxy175.executeUpdate(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:511)
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:509)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
- at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:95)
- Or sometimes contains below message:
- DEBUG com.svg.core.database.support.QueryLogger - insert into IPCSTMP_G49285 select s.PartID, s.LocID, 26518 from IPCSTMP_G49292 s join IPCSTMP_G49294 ns on s.PartID = ns.PartID and s.LocID = ns.LocID and ns.SegmentID = 15481 where s.SVCPPL_PERIOD=N'M_18_24' or s.SVCPPL_PERIOD=N'M_18_24') and s.LocID=735 and s.PartFamilyID=7 and s.PartCustom8=N'y' and s.SKUCust2=N'SA' and (s.PartCustom6=N'44AM' or s.PartCustom6=N'44BB' or s.PartCustom6=N'HH94GJ' or s.PartCustom6=N'HH94JB') and (s.SVCPPL_PERIOD=N'M_12_18' at com.svg.core.process.syncdb.SegmentFinder.newPartLocSegmentTable(SegmentFinder.java:96)
DEBUG com.svg.core.database.exception.CustomSQLExceptionTranslator - Unable to translate SQLException with Error code '933', will now try the fallback translator
- DEBUG com.svg.core.database.support.QueryLogger - insert into IPCSTMP_G49285 select s.PartID, s.LocID, 26518 from IPCSTMP_G49292 s join IPCSTMP_G49294 ns on s.PartID = ns.PartID and s.LocID = ns.LocID and ns.SegmentID = 15481 where s.SVCPPL_PERIOD=N'M_18_24' or s.SVCPPL_PERIOD=N'M_18_24') and s.LocID=735 and s.PartFamilyID=7 and s.PartCustom8=N'y' and s.SKUCust2=N'SA' and (s.PartCustom6=N'44AM' or s.PartCustom6=N'44BB' or s.PartCustom6=N'HH94GJ' or s.PartCustom6=N'HH94JB') and (s.SVCPPL_PERIOD=N'M_12_18' at com.svg.core.process.syncdb.SegmentFinder.newPartLocSegmentTable(SegmentFinder.java:96)
This is a printer-friendly version of Article 266042 and may be out of date. For the latest version click CS266042