"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:
Oracle Data Integrator - Version 12.1.3.0.0 to 12.1.3.0.1 [Release 12c]Information in this document applies to any platform.
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
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 |
References |