ODI 12c Upgrade Assistant Fails with Error: "ODI-10212: Parent object SNP_TECHNO: 'Oracle BI' already has child SNP_DT: 'DOUBLE PRECISION'."

(Doc ID 2310421.1)

Last updated on OCTOBER 25, 2017

Applies to:

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

Symptoms

When running the Upgrade Assistant (UA) from Oracle Data Integrator (ODI) 11.1.1.7.0 to 12.2.1.2.6, the repository upgrade fails with the following error:

ODIUPG-00018: Topology and Security Metadata upgrade failed.
oracle.odi.impexp.OdiImportGenericException: com.sunopsis.core.SnpsDuplicateAKException: ODI-10212: Parent object SNP_TECHNO: 'Oracle BI' already has child SNP_DT: 'DOUBLE PRECISION'.
Technical details: SNP_DT : 'DOUBLE PRECISION' (with global id: b38491f3-0cbe-3833-9e84-27c56c5c9664 and internal id: 843999) violates alternate key constraint AK_SNP_DT2 (I_TECHNO,DT_DRIVER) for values (59999,DOUBLE PRECISION)
java.lang.RuntimeException: oracle.odi.impexp.OdiImportGenericException: com.sunopsis.core.SnpsDuplicateAKException: ODI-10212: Parent object SNP_TECHNO: 'Oracle BI' already has child SNP_DT: 'DOUBLE PRECISION'.
Technical details: SNP_DT : 'DOUBLE PRECISION' (with global id: b38491f3-0cbe-3833-9e84-27c56c5c9664 and internal id: 843999) violates alternate key constraint AK_SNP_DT2 (I_TECHNO,DT_DRIVER) for values (59999,DOUBLE PRECISION)
java.lang.RuntimeException: oracle.odi.impexp.OdiImportGenericException: com.sunopsis.core.SnpsDuplicateAKException: ODI-10212: Parent object SNP_TECHNO: 'Oracle BI' already has child SNP_DT: 'DOUBLE PRECISION'.
Technical details: SNP_DT : 'DOUBLE PRECISION' (with global id: b38491f3-0cbe-3833-9e84-27c56c5c9664 and internal id: 843999) violates alternate key constraint AK_SNP_DT2 (I_TECHNO,DT_DRIVER) for values (59999,DOUBLE PRECISION)

Changes

 For the Oracle Business Intelligence (BI) technology in the ODI 11.1.1.7.0 repository, the "DOUBLE" datatype was removed and the "DOUBLE PRECISION" internal ID was incorrectly modified to 730999.

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