My Oracle Support Banner

"The new ID you have chosen is already in use..." Signaled When Attempting To Renumber An ODI Repository (Doc ID 1497522.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

Whilst attempting to renumber a repository in ODI Topology you are met with an error message advising the ID you have chosen is already in use as a table "SNP_XXX" primary key:

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!


In this Document
Symptoms
Changes
Cause
Solution
 Solution 1. Use ODI 12c, 11.1.1.9.0, or apply the appropriate patch
 Solution 2. Set the missing entries in the SNP_IMPORT_REP table
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.