My Oracle Support Banner

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

Last updated on DECEMBER 21, 2020

Applies to:

Oracle Data Integrator - Version 12.2.1.4.200413 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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