In An ODI 12c Multi Work Repository Environment, Scenario Execution Triggers Steps That Do Not Belong To Current Scenario, And Eventually Fails With "ODI-1217" Error and "return code 0" (Doc ID 2228348.1)

Last updated on MAY 24, 2017

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 to 12.2.1.2.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

In an Oracle Data Integrator (ODI) 12c environment composed of one Master Repository, and two or more Work Repositories, for example:

Despite the fact that the two Scenarios S1 and S2 are totally unrelated, and their respective definition is accurate / non-conflicting...

... the execution of S2 triggers the steps of S1, and eventually fails with a return code 0:

ODI-1217: Session P_REFRESH_SCHEMAS (10787) fails with return code 0.
 at oracle.odi.runtime.agent.execution.SessionExecutor.closeSession(SessionExecutor.java:3007)
 at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.computeFirstDependentNodeInOptimizedWay(SessionExecutor.java:2490)
 at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.computeFirstDependentNodeInOptimizedWay(SessionExecutor.java:2463)
 at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2234)
 at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:607)
 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: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)

 

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