My Oracle Support Banner

"Ignore" Context During Smart Import Only Works if All ODI Topology Objects Are Set to be Ignored (Doc ID 2647722.1)

Last updated on MAY 01, 2023

Applies to:

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

Symptoms

During the Smart Import in Oracle Data Integrator (ODI) 11g and 12c, even though the Context was set to be **ignored**, the Context is not ignored, and in some cases the Schema previously set to be mapped in the Contexts are lost, even if "Ignore" action at Context level has been chosen in the smart import.

Expected result:

**Ignoring** a Context during the smart import operation should ignore any changes to the Context, and leave the Agents, Logical Schema, etc associated to this Context unchanged.

To reproduce:

  1. Create an 11g Integration Interface (or 12c Mapping), using a specific Datastore form a Model that uses Physical Schema <PSCHEMA_NAME1>.
  2. Set the Optimization Context to "Global", and make sure that the Logical Schema is mapped in Context "Global".
  3. Smart export.
  4. Create a new Physical Schema <PSCHEMA_NAME2>.
  5. Edit the "Global" Context, and map to a Logical Schema that uses <PSCHEMA_NAME2>.
  6. Smart import the file exported in step #3.
  7. In Topology, select "Ignore" for all the Contexts
  8. Proceed with the import.
  9. Notice that after the import, the Context "Global" is neither mapped to <PSCHEMA_NAME1>, nor <PSCHEMA_NAME2>.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.