Unable to See Some Datastores in a New ODI Mapping Dataset After Upgrade or Import (Doc ID 2738940.1)

Last updated on FEBRUARY 14, 2023

Applies to:

Symptoms

Using Oracle Data Integrator (ODI) Studio version 12.2.1.4, when adding a datastore in a mapping dataset, it is not visible unless the mapping is reopened.
The properties of the dataset show the correct number of datastores.

This issue only occurs consistently for some of the datastores.
After reverse-engineering of the same datastores, the datastores are seen in the dataset, but they appear twice and connected via  join.

The following error can be seen in the Studio log:

To reproduce:

1 - Create a new mapping with empty dataset
2 - Drag model which has no issue
     => the model is visible
3 - Drag model which has an issue
     => the model is not visible, but it is listed under "Default Properties" -> "Datastores"
4 - Save and exit the mapping
5 - Open the mapping again
=> the model is now visible
6 - Reverse-engineer the model
7 - Retest
     => The datastore shows in the mapping.
     => However, the display shows the datastore twice connected via  join for both datastores that are not showing for the imported model.

Addtional information:
--------------------------

The datastore with this issue have foreign key constraints.

Changes

ODI was upgraded recently from version 12.1.3.

Note that smart export/import also reproduces the issue.

Cause