Upgrading an OWB Repository From 10.2 To 11.2 Fails During MDL Import at 91% With The Error ORA-00001: Unique Constraint (OWBSYS.CO_UK_NAME) Violated (Doc ID 1266483.1)

Last updated on MAY 05, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Upgrading an OWB Repository from 10.2 to 11.2 fails during the MDL import at  91% with the error:

Caused by: java.sql.SQLException: ORA-00001: unique constraint (OWBSYS.CO_UK_NAME) violated
ORA-06512: at "OWBSYS.WB_RTI_OBJECT_CATALOG", line 576
ORA-06512: at "OWBSYS.WB_RTI_OBJECT_CATALOG", line 611
ORA-06512: at "OWBSYS.WB_RT_UPGRADE_ACTIONS", line 2165
ORA-06512: at "OWBSYS.WB_RT_UPGRADE", line 889
ORA-06512: at "OWBSYS.WB_RT_UPGRADE", line 941
ORA-06512: at "OWBSYS.WB_RT_UPGRADE", line 983
ORA-06512: at line 1

Changes

Upgrading an OWB 10.2 Repository to 11.2 in a different database using the mdl export/import method.

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