My Oracle Support Banner

'ODI-10143' and 'ORA-02292: integrity restriction violated' Error when Attempting to Modify DATASET Name of Reusable Mapping (Doc ID 3028076.1)

Last updated on JUNE 14, 2024

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Symptoms

Using Oracle Data Integrator (ODI), attempting to save a Reusable Mapping's (RUE) dataset details results in the following error message:

This issue only occurs when the reusable mapping is opened from another mapping inside a package. When the RUE is opened directly from the project tree in ODI Studio Designer, the issue does not occur.

To reproduce:

  1. Create a reusable mapping that has a dataset.
  2. Create a mapping and use the RUE in this mapping, save.
  3. Edit the mapping.
  4. From within the mapping, double-click or right-click the RUE to open it.
  5. Attempt to change the name of the dataset in the RUE.

The same error occurs when attempting to save the RUE after renaming or removing the dataset, or adding in another model.

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.