1. Home
  2. Support
Article - CS323298

Generate order plan failing with java.sql.SQLRecoverableException: Closed Connection error in Servigistics Service Parts Management

Modified: 07-Apr-2020   


Applies To

  • Servigistics Service Parts Management 12.0.1.1

Description

  • Generate order plan failing with  java.sql.SQLRecoverableException: Closed Connection 
  • Error in Logs:
2020-02-22 18:29:11,481[SubTask-262] ERROR servigistics.op.normal - Exception in GAP: 91,78447
2020-02-22 18:29:11,481[SubTask-262] ERROR servigistics.op.normal - PreparedStatementCallback; SQL [select SeqNum from IPCS_SEQ_NUM where TableName = ? and ColumnName = ?Closed Connection; nested exception is java.sql.SQLRecoverableException: Closed Connection
org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [select SeqNum from IPCS_SEQ_NUM 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.query(JdbcTemplate.java:657)
at com.svg.core.database.StandardJdbcTemplate.query(StandardJdbcTemplate.java:387)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:771)
at com.svg.core.database.StandardJdbcTemplate.queryForObject(StandardJdbcTemplate.java:158)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:797)
at com.svg.core.seqnum.DataSourceSeqNumGenerator.getStoredSeqNum(DataSourceSeqNumGenerator.java:166)
at com.svg.core.seqnum.DataSourceSeqNumGenerator.lambda$getNextBlock$2(DataSourceSeqNumGenerator.java:125)
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:1912)
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(TransactionUti
This is a printer-friendly version of Article 323298 and may be out of date. For the latest version click CS323298