ODI-10223 and ODI-17769 Errors are Received when Importing or Executing Artifacts Exported from an ODI 12c Environment which has the 11g-Compatibility Mode Turned ON

(Doc ID 2356928.1)

Last updated on FEBRUARY 16, 2018

Applies to:

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


Oracle Data Integrator (ODI) 11g Repositories have been upgraded to ODI 12c using the following options:

Due to the settings above, the upgraded ODI 12c Repositories are 11g-compatible.

A smart export file has been extracted from the above 12c Repositories, and has -- as expected, IsLegacyIdCompatible="true" in the header records of export .xml file

The following issues arise when importing this 11g-compatible smart export file into another ODI 12c environment:

To replicate the behavior:

  1. Have one ODI 11g environment (ENV1), and upgrade to ODI 12c, using compatibility mode. (Use the settings in "odi.xml", as explained in <Document 2273310.1>)
  2. Start ODI 12c Studio, and connect to the upgraded Repositories (ENV1). Smart export some Mappings from this environment.
  3. Have another ODI 12c environment (ENV2), which also has been upgraded from ODI 11g using compatibility mode.
  4. Start ODI 12c Studio, and connect to ENV2. Smart import the export file, and observe the ODI-10223 error.
  5. Have a third ODI 12c environment (ENV3), which has been created using the 12c Repository Creation Utility (RCU). Due to its creation mode, please observe this environment has the 11g-compatibility mode turned off.
  6. Start ODI 12c Studio, and connect to ENV3. Smart import the export file, and observe this does unexpectedly succeed. Run the imported Mapping, and observe the ODI-17769 error.
The possible ways to determine the 11g-compatibility mode of an ODI 12c environment are explained in <Document 2356950.1>.




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