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 to [Release 12c]
Information in this document applies to any platform.


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(
 at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.computeFirstDependentNodeInOptimizedWay(
 at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.computeFirstDependentNodeInOptimizedWay(
 at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(
 at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(
 at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(
 at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(
 at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(
 at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(
 at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(
 at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(
 at oracle.odi.runtime.agent.processor.task.AgentTask.execute(
 at java.util.concurrent.Executors$
 at java.util.concurrent.ThreadPoolExecutor.runWorker(
 at java.util.concurrent.ThreadPoolExecutor$



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