How To Implement A Solution For ODI Work Internal Repository ID Collision

(Doc ID 424680.1)

Last updated on DECEMBER 29, 2017

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)

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