ODI 12c Session Execution Fails With Return Code 0 (Doc ID 2023762.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Data Integrator (ODI) 12c  execution fails with following error message:

ODI-1217: Session XXXXXXXXXXXXXXXX (XXXX) fails with return code 0.
 at oracle.odi.runtime.agent.execution.SessionExecutor.closeSession(SessionExecutor.java:2693)
 at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.computeFirstDependentNodeInOptimizedWay(SessionExecutor.java:2176)
 at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.computeFirstDependentNodeInOptimizedWay(SessionExecutor.java:2149)
 at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2031)
 at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:562)
 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:84)
 at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:916)
 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)
...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms