UPK: Error when upgrading from UPK 3.6.1 to 12.1: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found (Doc ID 2010192.1)

Last updated on MAY 19, 2015

Applies to:

User Productivity Kit - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Error when attempting to upgrade UPK from 3.6.1 to 12.1
 
ERROR
---------------
There was an error running the SQL script
AlterSchemaObjects.sql. Setup will now terminate.
Line: 551
Error: [Oracle][Ora]ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
ORA-06512: at line 29
(1452)
 
STEPS
---------------
The issue can be reproduced with the following steps:
1: Run the UPK 12.1 installation wizard
2: When the installer asks if the scripts have been run, select No
3: Enter the existing UPK 3.6.1 database
4: Error is generated

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