My Oracle Support Banner

Transformation Fails with 'ORA-00001: unique constraint' Error (Doc ID 2758763.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.8 to 2.4.8 [Release 2.4]
Information in this document applies to any platform.

Symptoms

On Oracle Health Sciences Data Management Workbench (DMW) 2.4.8, a Transformation failed with the error below shown in the job log file:
-----------
Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin CDR_W<SCHEMA_NAME>_11.SM_VARD1L_PKG.SM_VARD1L_LOAD ; end;"
caught:java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CDR_W<SCHEMA_NAME>.T1971976425_1__UK) violated
ORA-06512: at "CDR_W<SCHEMA_NAME>.P1971976425", line 321
ORA-06512: at "CDR_W<SCHEMA_NAME>.P1971976425", line 367
ORA-06512: at "CDR_W<SCHEMA_NAME>.DV1971976425$INS", line 50
ORA-04088: error during execution of trigger 'CDR_W<SCHEMA_NAME>.DV1971976425$INS'
ORA-06512: at "CDR_W<SCHEMA_NAME>_11.SM_VARD1L_PKG", line 4
ORA-06512: at line 1
-----------

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
Cause
Solution


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