Article - CS314320
Generate Order Plan is failing with JDBC Connection closed error in Servigistics Service Parts Management
Modified: 10-Oct-2019
Applies To
- Servigistics Service Parts Management 12.0.1.0 N/A
Description
- Generate Order Plan is failing with JDBC Connection closed error
- Running on 4 threads
- Large CPU memory usage is there with 80 percent
- Below ERROR in AutoPilot log files
- [SubTask-8] ERROR org.springframework.jdbc.support.SQLExceptionSubclassTranslator - PreparedStatementCallback; SQL [update IPCS_SEQ_NUM set SeqNum = SeqNum where TableName = ? and ColumnName = ?Closed Connection; nested exception is java.sql.SQLRecoverableException: Closed Connection
org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [update IPCS_SEQ_NUM set SeqNum = SeqNum where TableName = ? and ColumnName = ?Closed Connection; nested exception is java.sql.SQLRecoverableException: Closed Connection
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:100)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1402)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:620)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:905)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:915)
at com.svg.core.seqnum.DataSourceSeqNumGenerator.lockRow(DataSourceSeqNumGenerator.java:150)
at com.svg.core.seqnum.DataSourceSeqNumGenerator.lambda$getNextBlock$2(DataSourceSeqNumGenerator.java:123)
at com.svg.core.database.TransactionUtil.lambda$withNew$5(TransactionUtil.java:128)
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:58)
at com.svg.core.database.TransactionUtil.withNew(TransactionUtil.java:128)
at com.svg.core.seqnum.DataSourceSeqNumGenerator.getNextBlock(DataSourceSeqNumGenerator.java:122)
at com.svg.core.seqnum.BasicSeqNumGenerator$SeqNumData.getNextId(BasicSeqNumGenerator.java:219)
at com.svg.core.seqnum.BasicSeqNumGenerator$SeqNumData.getSeqBlock(BasicSeqNumGenerator.java:210)
at com.svg.core.seqnum.BasicSeqNumGenerator.nextBlock(BasicSeqNumGenerator.java:67)
at com.svg.planning.process.orderplanmp.impl.OPModifiableOrdersBatch.splitOrder(OPModifiableOrdersBatch.java:329)
at com.svg.planning.process.opcommon.bizlogic.OPModifiableOrders.breakupOrderOnEOQ(OPModifiableOrders.java:1779)
at com.svg.planning.process.orderplanmp.impl.OPModifiableOrdersBatch.writeModifiedOrders(OPModifiableOrdersBatch.java:284)
at com.svg.planning.process.orderplanmp.impl.OPModifiableOrdersBatch.writeModifiedOrders(OPModifiableOrdersBatch.java:156)
at com.svg.planning.process.opcommon.report.OPWalkReport.reportPhaseWithWrite(OPWalkReport.java:173)
at com.svg.planning.process.orderplanmp.impl.OPWalkControlBatch.runSimulation(OPWalkControlBatch.java:202)
at com.svg.planning.process.orderplanmp.impl.OPProcessBatch.doOrderPlan(OPProcessBatch.java:293)
at com.svg.planning.process.orderplanmp.OrderPlanConnectorMP.process(OrderPlanConnectorMP.java:76)
at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:103)
at com.svg.core.process.BatchConnectorImpl.lambda$run$0(BatchConnectorImpl.java:91)
at com.svg.core.database.TransactionUtil.lambda$withNone$1(TransactionUtil.java:101)
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:53)
at com.svg.core.database.TransactionUtil.withNone(TransactionUtil.java:100)
at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:91)
at com.svg.planning.process.orderplanmp.OrderPlanGenConnectorMP.runOrderPlanMP(OrderPlanGenConnectorMP.java:215)
at com.svg.planning.process.orderplanmp.OrderPlanGenConnectorMP.doProcess(OrderPlanGenConnectorMP.java:167)
at com.svg.core.process.ThreadableConnector.doProcessSubTask(ThreadableConnector.java:84)
at com.svg.core.process.ThreadableConnector.process(ThreadableConnector.java:26)
at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:103)
at com.svg.core.process.BatchConnectorImpl.lambda$run$0(BatchConnectorImpl.java:91)
at com.svg.core.database.TransactionUtil.lambda$withNone$1(TransactionUtil.java:101)
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:53)
at com.svg.core.database.TransactionUtil.withNone(TransactionUtil.java:100)
at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:91)
at com.svg.core.task.SubTask.runConnector(SubTask.java:104)
at com.svg.core.task.AbstractTask.run(AbstractTask.java:215)
at com.svg.core.task.SubTask.run(SubTask.java:86)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy1227.run(Unknown Source)
at com.svg.core.service.impl.TaskServiceImpl$1.run(TaskServiceImpl.java:459)
at java.lang.Thread.run(Thread.java:748)
at com.svg.core.util.ThreadUtil$1.run(ThreadUtil.java:43)
Caused by: java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.getAutoCommit(PhysicalConnection.java:1828)
at com.atomikos.jdbc.nonxa.AtomikosThreadLocalConnection.updateInTransaction(AtomikosThreadLocalConnection.java:197)
at com.atomikos.jdbc.nonxa.AtomikosThreadLocalConnection.invoke(AtomikosThreadLocalConnection.java:276)
at com.sun.proxy.$Proxy78.prepareStatement(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1515)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
... 58 more
This is a printer-friendly version of Article 314320 and may be out of date. For the latest version click CS314320