'Foreign key constraint violation' Message Displayed When Attempting To Import a Scenario Into An Oracle Data Integrator(ODI) Work Repository
(Doc ID 726769.1)
Last updated on JUNE 16, 2022
Applies to:
Oracle Data Integrator - Version 10.1.3.4.4 to 10.1.3.6.10Information in this document applies to any platform.
Symptoms
After having :
- Compiled an Oracle Data Integrator (ODI) component to create a Scenario
- Moved (drag and dropped) the Scenario into another folder
- Exported the Scenario to disk in its XML format
- Imported the Scenario into another Work repository in Duplication Mode
the following message is signaled at import :
Foreign key constraint violation occurred, dbname = '<work repository>', table name = 'SNP_SCEN',constraint name = 'FK_SCEN_FOLDER'
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 |