How To Implement A Solution For ODI Work Internal Repository ID Collision
(Doc ID 424680.1)
Last updated on MAY 10, 2018
Oracle Data Integrator - Version 4.1.01.05 to 18.104.22.168.99 [Release 4.1.01 to 11gR1] Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a Million Knowledge Articles and hundreds of Community platforms