My Oracle Support Banner

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

Last updated on OCTOBER 04, 2022

Applies to:

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


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

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


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

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