Article - CS54747
UpgradeManager failed at Task "Add Constraints to Database Schema" in Windchill
Modified: 08-Apr-2025
Applies To
- Windchill PDMLink 6.2 to 13.0
- FlexPLM 11.0 to 12.1
Description
- Add Constraints to Database Schema task of the UpgradeManager failed
- UpgradeManager failed with error:
cannot CREATE UNIQUE INDEX; duplicate keys found
- Error in UpgradeManager log :
ERROR [pool-5-thread-12] 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 WTUser$UNIQUE50 ON WTUser(name) TABLESPACE INDX STORAGE ( INITIAL 50k NEXT 50k PCTINCREASE 0 ) ]. Nested exception is: java.sql.SQLException: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
This is a printer-friendly version of Article 54747 and may be out of date. For the latest version click CS54747