"ORA-02291: integrity constraint <WORK REPO SCHEMA>.FK_PAR_SCEN_TASK violated - parent key not found" is Received while Importing an ODI 12c Scenario in DUPLICATION Mode
(Doc ID 2340328.1)
Last updated on FEBRUARY 11, 2019
Applies to:
Oracle Data Integrator - Version 12.2.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
The following error message is received in Oracle Data Integrator (ODI) 12c when importing a Scenario in duplication mode:
com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10036: Importing object SNP_SCENTASK : null (with global id: <GUID> and internal id: <ID1> | <ID2> | <TASK>) failed.
at com.sunopsis.dwg.DwgDuplicationTools.duplicationInsertObject(DwgDuplicationTools.java:1764)
at com.sunopsis.dwg.DwgDuplicationTools.duplicationInsertListWithProgressiveDuplicationLevel(DwgDuplicationTools.java:2022)
at com.sunopsis.dwg.DwgDuplicationTools.duplicationInsertPhase(DwgDuplicationTools.java:2267)
Caused by: com.sunopsis.dwg.SQLWorkReposException: ORA-02291: integrity constraint (<WORK REPO SCHEMA>.FK_PAR_SCEN_TASK) violated - parent key not found
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at ...
Changes
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 |