My Oracle Support Banner

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 OCTOBER 12, 2018

Applies to:

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


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


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


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.