Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLRecoverableException: Close

Received Response
122
Views
1
Comments
User_A1PSU
User_A1PSU Rank 1 - Community Starter
edited August 2024 in Oracle Analytics Cloud and Server

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

Answers