Article - CS27344
Upgrade Database Schema returns ORA-02429 during upgrade of Windchill
Modified: 11-Nov-2025
Applies To
- Windchill PDMLink 9.1 to 13.1
- FlexPLM 11.0 to 12.0
Description
- Upgrade Database Schema returns index-constraint related errors, such as:
An error occurred during execution of SQL executor command SQLCommand[DROP INDEX FVITEM$COMPOSITE]. Nested exception is: java.sql.SQLException: ... (ORA-02429: Index to enforce the unique / primary key is not deleted) An error occurred during execution of SQL executor command SQLCommand[DROP INDEX ATTRCRITERIONDEF$COMPOSITE12]. Nested exception is: java.sql.SQLException: ORA-02429: cannot drop index used for enforcement of unique/primary key
WARN [main] com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper - Not retrying original command: DROP INDEX LCSSKUCOSTSHEET$NMCOMPOSITE2 ERROR [main] com.ptc.windchill.upgrade.statemachine.state.PhaseEventUpgradeState - Upgrade execution failed with the exception: wt.util.WTException: Message: Resource bundle/Message key = com.ptc.windchill.upgrade.dbservices.dbservicesResource/4 at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeCommand(AbstractUpgradeDBHelper.java:580) ~[wnc.jar:?] at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeSql(AbstractUpgradeDBHelper.java:487) ~[wnc.jar:?] at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeBatchByName(AbstractUpgradeDBHelper.java:949) ~[wnc.jar:?] at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeBatchAsSchemaOwner(AbstractUpgradeDBHelper.java:880) ~[wnc.jar:?] at com.ptc.windchill.upgrade.phases.upgradeschema.UpgradeSchema.dropRemovedIndexes(UpgradeSchema.java:1428) ~[wnc.jar:?] at com.ptc.windchill.upgrade.phases.upgradeschema.OracleUpgradeSchemaWorker.execute(OracleUpgradeSchemaWorker.java:84) ~[wnc.jar:?] at com.ptc.windchill.upgrade.phases.upgradeschema.UpgradeSchema.execute(UpgradeSchema.java:594) ~[wnc.jar:?] at com.ptc.windchill.upgrade.statemachine.state.DefaultRunningUpgradeState.execute(DefaultRunningUpgradeState.java:34) ~[wnc.jar:?] at com.ptc.windchill.upgrade.statemachine.state.PhaseEventUpgradeState.execute(PhaseEventUpgradeState.java:55) [wnc.jar:?] at com.ptc.windchill.upgrade.statemachine.state.PersistPhaseUpgradeState.execute(PersistPhaseUpgradeState.java:100) [wnc.jar:?] at com.ptc.windchill.upgrade.statemachine.state.ReportWriterUpgradeState.execute(ReportWriterUpgradeState.java:76) [wnc.jar:?] at com.ptc.windchill.upgrade.statemachine.UpgradeFrameworkStateMachine.run(UpgradeFrameworkStateMachine.java:460) [wnc.jar:?] at com.ptc.windchill.upgrade.statemachine.UpgradeFrameworkStateMachine.main_(UpgradeFrameworkStateMachine.java:896) [wnc.jar:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at com.ptc.windchill.upgrade.statemachine.DynamicLauncher.runUpgradeFrameworkStateMachine(DynamicLauncher.java:76) [wnc.jar:?] at com.ptc.windchill.upgrade.statemachine.DynamicLauncher.main(DynamicLauncher.java:43) [wnc.jar:?] Caused by: java.sql.SQLException: ORA-02429: cannot drop index used for enforcement of unique/primary key at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[wc3rdpartylibs.jar:?] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[wc3rdpartylibs.jar:?] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[wc3rdpartylibs.jar:?] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553) ~[wc3rdpartylibs.jar:?] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) ~[wc3rdpartylibs.jar:?] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[wc3rdpartylibs.jar:?] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229) ~[wc3rdpartylibs.jar:?] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41) ~[wc3rdpartylibs.jar:?] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:928) ~[wc3rdpartylibs.jar:?] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205) ~[wc3rdpartylibs.jar:?] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1823) ~[wc3rdpartylibs.jar:?] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1778) ~[wc3rdpartylibs.jar:?] at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:303) ~[wc3rdpartylibs.jar:?] at wt.tools.sql.SQLCommand.doExecute(SQLCommand.java:187) ~[wnc.jar:?] at wt.tools.sql.AbstractCommand.doExecute(AbstractCommand.java:74) ~[wnc.jar:?] at wt.tools.sql.AbstractCommand.execute(AbstractCommand.java:56) ~[wnc.jar:?] at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeCommand(AbstractUpgradeDBHelper.java:562) ~[wnc.jar:?] ... 18 more
- Attempting to run Upgrade Manager again without correcting the issue may result in unexpected errors
- After installing new CPS, the Update Tool fails in step Upgrade Database Schema on task Prepare For Dropping Removed Indices
This is a printer-friendly version of Article 27344 and may be out of date. For the latest version click CS27344