Article - CS363477

"Error delegating 'getAutoCommit' call java.sql.SQLRecoverableException: Closed Connection" in Servigistics

Modified: 23-Sep-2024   


Applies To

  • Servigistics Service Parts Management 12.0.1.1 to 13.1.0.2
  • Oracle database

Description

  • How to enable Dead Connection Detection (DCD) for AutoPilot jobs
  • AutoPilot jobs intermittently failing with Closed Connection errors
  • Intermittent Closed Connection errors during AutoPilot jobs like SyncDB, Generate Order Plan
  • AutoPilot jobs fail with errors like:
    • 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.core.database.metadata.AbstractTableCreator.createOrReplaceTable(AbstractTableCreator.java:51) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.metadata.AbstractTableCreator.createOrReplaceTable(AbstractTableCreator.java:46) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.metadata.OracleTableCreator.createTable(OracleTableCreator.java:47) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.metadata.AbstractTableCreator.createTable(AbstractTableCreator.java:40) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.temptable.TempTableImpl.initTable(TempTableImpl.java:85) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.temptable.LocalTempTable.initTable(LocalTempTable.java:52) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.temptable.TempTableImpl.build(TempTableImpl.java:51) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.temptable.LocalTempTable.build(LocalTempTable.java:7) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.temptable.TempTableFactoryImpl.newTempTable(TempTableFactoryImpl.java:81) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.planning.process.orderplanmp.impl.OPStkLvlPeriodsImpl.setupStkLvlPeriodsRs(OPStkLvlPeriodsImpl.java:113) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.planning.process.orderplanmp.impl.OPStkLvlPeriodsImpl.setup(OPStkLvlPeriodsImpl.java:37) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.planning.process.orderplanmp.impl.OPProcessBatch.setup(OPProcessBatch.java:557) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.planning.process.orderplanmp.impl.OPProcessBatch.doOrderPlan(OPProcessBatch.java:264) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.planning.process.orderplanmp.OrderPlanConnectorMP.process(OrderPlanConnectorMP.java:77) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:103) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.process.BatchConnectorImpl.lambda$run$0(BatchConnectorImpl.java:91) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.TransactionUtil.lambda$withNone$1(TransactionUtil.java:106) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:56) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.TransactionUtil.withNone(TransactionUtil.java:105) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:91) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.planning.process.orderplanmp.OrderPlanGenConnectorMP.runOrderPlanMP(OrderPlanGenConnectorMP.java:228) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.planning.process.orderplanmp.OrderPlanGenConnectorMP.doProcess(OrderPlanGenConnectorMP.java:168) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.process.ThreadableConnector.doProcessSubTask(ThreadableConnector.java:84) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.process.ThreadableConnector.process(ThreadableConnector.java:26) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:103) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.process.BatchConnectorImpl.lambda$run$0(BatchConnectorImpl.java:91) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.TransactionUtil.lambda$withNone$1(TransactionUtil.java:106) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:56) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.database.TransactionUtil.withNone(TransactionUtil.java:105) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:91) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.task.SubTask.runConnector(SubTask.java:104) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.task.AbstractTask.run(AbstractTask.java:215) ~[AutoPilotServer.jar:12.1.1.2]
          at com.svg.core.task.SubTask.run(SubTask.java:86) ~[AutoPilotServer.jar:12.1.1.2]
          at sun.reflect.GeneratedMethodAccessor145.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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197) ~[spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56) ~[spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174) ~[spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295) [spring-tx-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) [spring-tx-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) [spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) [spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) [spring-aop-5.0.19.RELEASE.jar:5.0.19.RELEASE]
          at com.sun.proxy.$Proxy1250.run(Unknown Source) [?:?]
          at com.svg.core.service.impl.TaskServiceImpl$1.run(TaskServiceImpl.java:468) [AutoPilotServer.jar:12.1.1.2]
          at java.lang.Thread.run(Thread.java:748) [?:1.8.0_261]
          at com.svg.core.util.ThreadUtil$1.run(ThreadUtil.java:43) [AutoPilotServer.jar:12.1.1.2]
This is a printer-friendly version of Article 363477 and may be out of date. For the latest version click CS363477