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 and later
Information in this document applies to any platform.


Error when attempting to upgrade UPK from 3.6.1 to 12.1
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
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


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