1. Home
  2. Support
Article - CS255823

Upgarde manager fails at task Update Database Schema with error ORA-01452: cannot CREATE UNIQUE INDEX

Modified: 03-Feb-2017   


Applies To

  • Windchill PDMLink 11.0

Description

Upgrade manager fails at task "Update Database Schema" with error "ORA-01452: cannot CREATE UNIQUE INDEX;duplicate keys found".

Error in Upgrade manager log:
 
2017-01-27 15:02:21,170 ERROR [pool-4-thread-1] com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper - Not retrying original command: CREATE UNIQUE INDEX EPMParameterValue$UNIQUE50 ON EPMParameterValue(idA3A4,name)
 TABLESPACE INDX
 STORAGE ( INITIAL 20k NEXT 20k PCTINCREASE 0 )
2017-01-27 15:02:21,170 ERROR [pool-4-thread-1] com.ptc.windchill.upgrade.phases.upgradeschema.ExecuteBatch - (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[CREATE UNIQUE INDEX EPMParameterValue$UNIQUE50 ON EPMParameterValue(idA3A4,name)
 TABLESPACE INDX
 STORAGE ( INITIAL 20k NEXT 20k PCTINCREASE 0 )].
Nested exception is: java.sql.SQLException: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

2017-01-27 15:02:21,186 INFO  [main] com.ptc.windchill.upgrade.phases.upgradeschema.UpgradeSchemaHelper - EPMPARAMETERVALUE failed
2017-01-27 15:02:46,498 INFO  [main] com.ptc.windchill.upgrade.phases.AddConstraints - Add Constraints Failed? true
2017-01-27 15:02:46,498 ERROR [main] com.ptc.windchill.upgrade.statemachine.state.PhaseEventUpgradeState - Upgrade execution failed with the exception:

wt.util.WTException: Alter Constraints failed. See UpgradeManager log for details
    at com.ptc.windchill.upgrade.phases.AddConstraints.addConstraints(AddConstraints.java:186)
    at com.ptc.windchill.upgrade.phases.AddConstraints.execute(AddConstraints.java:150)
This is a printer-friendly version of Article 255823 and may be out of date. For the latest version click CS255823