"ODI-26184" and "ORA-00001: unique constraint" Of PK_VAR_SB When Executing A Package Step In ODI 12c (Doc ID 2278317.1)

Last updated on OCTOBER 04, 2022

Applies to:

Symptoms

A Mapping in Oracle Data Integrator (ODI) 12c uses a Knowledge Module which sets one of its option values to an ODI Variable.

A package has two steps, as follows:

• Step 1 -- Declare of Variable above
• Step 2 -- The Mapping above

A BluePrint is defined on the Variable from the Package "Declare Variable" step.

The execution of the whole Package successfully starts. Same for the manual execution of the Mapping, outside the Package.

However, when executing the Mapping from the Package step, using the "Execute Step" feature, no Session is started, and a violation of PK_VAR_SB is received:

ODI-26184: SQL error occurred. See error details for more information.
com.sunopsis.dwg.SQLWorkReposException: ORA-00001: unique constraint (<NAME>.PK_VAR_SB) violated

Changes

Cause

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