Violations of AK_SNP_DT1 Unique Constraint Are Signaled During ODI Upgrade Or Import Operations (Doc ID 1911663.1)

Last updated on DECEMBER 13, 2016

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

Violations of AK_SNP_DT1 unique constraints are signaled during either upgrade from Oracle Data Integrator (ODI) 10g to 11g, or import operations.

For example, the below message is signaled for the Oracle technology (internal ID 1999) with reference to the NCHAR datatype, but similar messages for other technologies and/or datatypes can be observed as well:

ODI-10212: The parent object SNP_TECHNO: 'Oracle' already has a child SNP_DT 'NCHAR.
Technical details: SNP_DT 'NCHAR' violates the constraint of replacement key AK_SNP_DT1 (I_TECHNO, DT_SOURCE) for the values (1999, NCHAR)

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