"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 JANUARY 05, 2018

Applies to:

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


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:

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 (xxx.PK_VAR_SB) violated


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 hundreds of Community platforms