My Oracle Support Banner

"ORA-00001: unique constraint (<ODI_REPO_DBSCHEMA>.PK_SCEN_TASK) violated" while Generating a New ODI Scenario (Doc ID 2091713.1)

Last updated on JUNE 16, 2022

Applies to:

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

Symptoms

Creating a new ODI 12.1.3.0.0. scenario for a package fails with the following error message:

Changes

The environment was migrated from Release 10. The versions of the scenario do not have the expected values of 001,002,...,00n but rather 1,2,3,4.

The same error occurs if the scenarios are changed from their defaults to letters or numbers regardless of the version the repository was created in.

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.