1 Reply Latest reply on Dec 8, 2018 2:05 PM by Christian Berg

    oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLRecoverableException: Closed Connection

    3841511

      I am getting oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLRecoverableException: Closed Connection when i am running mapping using ODI12c.

      Below the error message. Please let me know how to fix this issue.

      -----------------------------------------------------------------------------------------------------------------------

       

      oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLRecoverableException: Closed Connection

      at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.close(FastJDBCRecordSet.java:275)

      at oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(Executor.java:350)

      at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:51)

      at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)

      at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)

      at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)

      at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)

      at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)

      at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)

      at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)

      at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)

      at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)

      at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)

      at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)

      at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)

      at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

      at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)

      at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)

      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

      at java.lang.Thread.run(Thread.java:745)

      Caused by: java.sql.SQLRecoverableException: Closed Connection

      at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:4173)

      at oracle.jdbc.driver.OracleStatement.clearWarnings(OracleStatement.java:3204)

      at oracle.jdbc.driver.OracleStatement.prepareForNewResults(OracleStatement.java:3690)

      at oracle.jdbc.driver.OracleStatement.endOfResultSet(OracleStatement.java:3808)

      at oracle.jdbc.driver.InsensitiveScrollableResultSet.close(InsensitiveScrollableResultSet.java:202)

      at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.close(FastJDBCRecordSet.java:273)

      ... 22 more