ODI 12c Jobs Failing with Intermittent Error: "java.lang.IllegalArgumentException: Active Connection is required"
(Doc ID 2364426.1)
Last updated on SEPTEMBER 04, 2020
Applies to:
Oracle Data Integrator - Version 12.1.3.0.1 and laterInformation in this document applies to any platform.
Symptoms
In Oracle Data Integrator (ODI) 12.1.3.0.1 with a Standalone Agent configuration, ODI jobs are failing intermittently in a refresh variable step that uses a Hive connection. The error stack received is as follows:
ODI-1217: Session <SESSION NAME> (2143177) fails with return code 7000.
ODI-1226: Step <STEP NAME> fails after 1 attempt(s).
ODI-1236: Error while refreshing variable <PROJECT>.<VARIABLE_NAME>.
Caused By: java.lang.RuntimeException: java.lang.IllegalArgumentException: Active Connection is required
at com.sunopsis.sql.SnpsConnection.isTransactionManagedConnection(SnpsConnection.java:552)
at com.sunopsis.sql.SnpsConnection.createConnection(SnpsConnection.java:519)
at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java:476)
at oracle.odi.runtime.agent.execution.VariableSessionTask.getExecutor(VariableSessionTask.java:232)
at oracle.odi.runtime.agent.execution.VariableSessionTask.processTask(VariableSessionTask.java:177)
at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:114)
at oracle.odi.runtime.agent.execution.VariableSessionTask.doExecuteTask(VariableSessionTask.java:164)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2198)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:591)
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.StartScenRequestProcessor.access$2700(StartScenRequestProcessor.java:85)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:917)
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:471)
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:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalArgumentException: Active Connection is required
at org.springframework.util.Assert.notNull(Assert.java:113)
at org.springframework.jdbc.datasource.ConnectionHolder.getConnection(ConnectionHolder.java:149)
at com.sunopsis.sql.SnpsConnection.isTransactionManagedConnection(SnpsConnection.java:546)
... 24 more
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |