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 NOVEMBER 03, 2020

Applies to:

Symptoms

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

• Upgrade repository to use GUIDs: NO
• Upgrade interfaces to use 12c mappings: YES

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:

• An inappropriate ODI-10223 is received when importing into an 11g-compatible ODI 12c environment:
  

  ODI-10223: A non-legacy compatible import source cannot be imported into a legacy compatible repository

• The import into a regular, non 11g-compatible ODI 12c environment does inappropriately succeed...
  
  ... and following ODI-17769 error is received when trying to execute the imported artifacts:
  

  ### KEY com.sunopsis.res.gen / ODI-17769: OdiRef: Internal ID <ID> of IObjects <ID> should not be used when the repository is 12c mode.###

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 2544427.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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.