My Oracle Support Banner

Using Same Variable In Both Mapping And Reusable Mapping Causes Execution Of The ODI Main Mapping To Fail With "ODI-10143: Error while accessing the ODI repository And ORA-00001: unique constraint (<ODI_REPO_SCHEMA>.PK_VAR_SB) violated" Message (Doc ID 1620651.1)

Last updated on FEBRUARY 08, 2019

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 to 12.1.3.0.1 [Release 12c]
Information in this document applies to any platform.

Symptoms

Having a situation where the same Variable is used in both an Oracle Data Integrator (ODI) Mapping, and Reuseable Mapping.

After having added the Reusuable Mapping to the main Mapping, the execution of the main Mapping fails with:

ODI-10143: Error while accessing the ODI repository
ORA-00001: unique constraint (PK_VAR_SB) violated

 

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!


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.