'ODI-1213: Session preparation failure: scenario XXXyyy version Xx does not exist in work repository ODI_WORK' Error is Generated When Running an ODI Scenario After Moving to a New Environment

(Doc ID 2062173.1)

Last updated on MARCH 10, 2017

Applies to:

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

Symptoms

An ODI environment was migrated to new servers. 

When running any scenario in the new environment, the error below occurs:

 

Changes

The following process was used to move the ODI environment from the source servers to the new target servers:

  1. Exported master repository database schema from SOURCE environment and imported that into TARGET environment database schema.
  2. Exported all the scenarios and load plans as 'xml' files from SOURCE via ODI studio.
  3. Imported all the scenarios and load plans as 'xml' files into TARGET environment.
  4. Execute the scenario and get the error "ODI-1213: Session preparation failure: scenario XXxxxx version Xx does not exist in work repository ODI_WORK".

 

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