How To Implement a Solution for ODI Work Internal Repository ID Collision
(Doc ID 424680.1)
Last updated on NOVEMBER 03, 2023
Applies to:
Oracle Data Integrator - Version 4.1.01.05 to 11.1.1.9.99 [Release 4.1.01 to 11gR1] Information in this document applies to any platform.
Symptoms
When copying developments from an Oracle Data Integrator (ODI) Work Repository into an other one which has the same ID, problems are signaled at import time:
ODI-10013: This import action has been canceled because it could damage your repository. This is due to an SNP_XXX object that has object identifier <myID> that is greater than that for the current SNP_XXX id sequence. Importing this object would lead to primary key violations in the future.
== or ==
XML IMPORT ERROR
com.sunopsis.core.q: This import action has been cancelled because it could damage your repository (problem with the identifier sequences)
== or ==
ODI-10093: You are importing an object from another repository with the same identifier. It is forbidden.
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!