My Oracle Support Banner

References to Replaced Datastores Are Retained in Mappings when Using Smart Export (Doc ID 3018359.1)

Last updated on APRIL 24, 2024

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 to 12.2.1.4.231215 [Release 12c]
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 to 12.2.1.4.221215
Information in this document applies to any platform.

Symptoms

Using Oracle Data Integrator (ODI) Studio 12.2.1.4, when replacing a model datastore with another model in a mapping, the smart export still has references to the original model, and exporting three models instead of two.


The issue can be reproduced at will with the following steps:

  1. Create a simple mapping with a source and target, save the mapping SOURCE -> TODELETE
  2. Edit the mapping, select the target datastore "TODELETE"
  3. In "Properties", click "Datastore".
  4. Select the "Datastore Advanced Editor" icon => this opens a window that allows to "Find the Datastore you want to select"
  5. Select the Datastore to use as replacement "TOREPLACE"
  6. Save
  7. Smart export, notice that the smart export has the three models SOURCE, TODELETE, TOREPLACE

The issue does not occur if the Datastore is deleted from the mapping, and the Datastore to replace is inserted instead of using the above method to replace.

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.