My Oracle Support Banner

"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 later
Information 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


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