My Oracle Support Banner

"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:

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




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

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