'ODI-1213: Session preparation failure: scenario ... version ... does not exist in work repository..' Signalled In ODI 11g Console When Executing a Scenario (Doc ID 1996199.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Data Integrator - Version 11.1.1.5.0 to 11.1.1.6.5 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

Having a non-supervisor user that is granted the appropriate privileges to:

  1. View a Scenario Folder
    and
  2. Execute any Scenarios in that Scenario Folder

The following message is received when such a Scenario is executed from Oracle Data Integrator (ODI) 11g Console, while the same Scenario is successfully executed from ODI Studio:

oracle.odi.runtime.agent.invocation.InvocationException: ODI-1213: Session preparation failure: scenario MYSCEN version 001 does not exist in work repository WORKREP1.
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$1.doAction(StartScenRequestProcessor.java:440)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.goPrepareOrDelegatePrepare(StartScenRequestProcessor.java:288)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doPrepareAgentTask(StartScenRequestProcessor.java:217)
  at ...

Expected is ODI Console to behave the same as ODI Studio does, and successfully execute that Scenario even if "View" privilege has not been specifically granted onto the Scenario.

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