Article - CS358493

Inventory Optimization Make Production (Make Production) job fails with error "Error delegating 'getAutoCommit' call java.sql.SQLRecoverableException: Closed Connection" in Servigistics service parts management (Servigistics parts)

Modified: 10-Nov-2025   


Applies To

  • Servigistics Service Parts Management 12.1.0.0 N/A to 14.0.1.0

Description

  • Inventory Optimization Make Production job fails
  • Multi-Echelon Inventory Optimization (MEO) Calculation job fails
    • ERROR: 
    • WARN  com.atomikos.jdbc.JdbcConnectionProxyHelper - Error delegating 'getAutoCommit' call
      java.sql.SQLRecoverableException: Closed Connection
          at oracle.jdbc.driver.PhysicalConnection.getAutoCommit(PhysicalConnection.java:1828) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
          at sun.reflect.GeneratedMethodAccessor37.invoke(Unknown Source) ~[?:?]
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_261]
          at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_261]
          at com.atomikos.jdbc.nonxa.AtomikosThreadLocalConnection.invoke(AtomikosThreadLocalConnection.java:291) [transactions-jdbc-4.0.6.jar:?]
          at com.sun.proxy.$Proxy82.getAutoCommit(Unknown Source) [?:?]
          at com.svg.core.database.support.ConnectionHandler.inTransaction(ConnectionHandler.java:83) [AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.support.StatementHandler.inTransaction(StatementHandler.java:121) [AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.support.ProxyHandler.invoke(ProxyHandler.java:52) [AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.support.StatementHandler.invoke(StatementHandler.java:108) [AutoPilotServer.jar:12.1.1.2]
          at com.sun.proxy.$Proxy86.close(Unknown Source) [?:?]
          at org.springframework.jdbc.support.JdbcUtils.closeStatement(JdbcUtils.java:88) [spring-jdbc-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at com.svg.core.database.StandardJdbcTemplate.execute(StandardJdbcTemplate.java:198) [AutoPilotServer.jar:12.1.1.2]
          at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:513) [spring-jdbc-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at com.svg.planning.process.meo.tsl.CalcSummary.executeUpdateSql(CalcSummary.java:692) [AutoPilotServer.jar:12.1.1.2]
          at com.svg.planning.process.meo.tsl.CalcSummary.populateCasePartSummary(CalcSummary.java:663) [AutoPilotServer.jar:12.1.1.2]
          at com.svg.planning.process.meo.tsl.CalcSummary$PartSummaryCallable.call(CalcSummary.java:1729) [AutoPilotServer.jar:12.1.1.2]
          at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_261]
          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_261]
          at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_261]
          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_261]
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_261]
          at java.lang.Thread.run(Thread.java:748) [?:1.8.0_261]
This is a printer-friendly version of Article 358493 and may be out of date. For the latest version click CS358493