My Oracle Support Banner

ODI-10212 Microsoft SQL Server Already has Child SNP_DT: datetime2 when Upgrading ODI 12.2.1.0 to 12.2.1.4.0 (Doc ID 2614864.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

The following error is encountered when upgrading from Oracle Data Integrator (ODI) 12.2.1.0 to 12.2.1.4.0:

ODIUPG-00018: Topology and Security Metadata upgrade failed oracle.odi.impexp.OdiImportGenericException: com.sunopsis.core.SnpsDuplicateAKException:
ODI-10212 Parent object SNP_TECHNO: "Microsoft SQL Server' already has a child SNP_DT: 'datetime2' Technical Details: SNP_DT: 'datetime2' (with global id: <GUID>  and internal id <ID>)
violates alertnate key constraint AK_SNP_DT2 (I_TECHNO, DT_DRIVER) for values (68,DATETIME2)
java.lang.RuntimeException: oracle.odi.impexp.OdiImportGenericException
...

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
Cause
Solution
References


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