"ORA-02292 (Integrity Constraint FK_PHY_EXPR_3 or FK_EXEC_UNIT_REF Violated)" Signalled when Renaming, Duplicating or Deleting an ODI 12c Mapping (Doc ID 2175447.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

After smart importing a project into an empty Oracle Data Integrator (ODI) 12c repository, the following errors are thrown when trying to rename, duplicate or delete some mappings:

com.sunopsis.dwg.SQLWorkReposException: ORA-02292: integrity constraint (XX.FK_PHY_EXPR_3) violated - child record found
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546) .....

or

com.sunopsis.dwg.SQLWorkReposException: ORA-02292: integrity constraint (XX.FK_EXEC_UNIT_REF) violated - child record found
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546) .....

or

com.sunopsis.core.SnpsDuplicateAKException: ODI-10212: Parent object SNP_PROJECT: 'XX' already has child SNP_MAPPING: 'XX'.
Technical details: SNP_MAPPING : 'XX' (with global id: <GUID> and internal id: <InternalID>) violates alternate key constraint AK_SNP_MAPPING (NAME,I_FOLDER,IS_REUSABLE) for values (XX,12,N)
at com.sunopsis.dwg.DwgObject.processAkViolation(DwgObject.java:3661)
at com.sunopsis.dwg.DwgObject.insertActionForDuplication(DwgObject.java:3599)
at com.sunopsis.dwg.DwgObject.insertForDuplication(DwgObject.java:3918)
at com.sunopsis.dwg.DwgObject.insertForDuplication(DwgObject.java:3885)
at com.sunopsis.dwg.DwgObject.insertForDuplication(DwgObject.java:3881)...

Cause

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