How To Implement A Solution For ODI Work Internal Repository ID Collision (Doc ID 424680.1)

Last updated on SEPTEMBER 12, 2016

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.
*** Not Relevant for ODI 12c confirmed on 18-May-2014 ***

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)

Cause

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