Article - CS51402
Update_tools fails with "ORA-30556: functional index is defined on the column to be modified" in Windchill PDMLink
Modified: 10-Dec-2019
Applies To
- Windchill PDMLink 9.1 to 11.0
Description
- update_tools fails with ORA-30556: functional index is defined on the column to be modified
- Error in update_tool log
wt.util.WTException: (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[ALTER TABLE EXCHANGECONTAINER MODIFY(category VARCHAR2(600), classnamekeyA6 VARCHAR2(600), classnamekeyA2containerInfo VARCHAR2(600), classnamekeyB2containerInfo VARCHAR2(600), classnamekeyC2containerInfo VARCHAR2(600), classnamekeyD2containerInfo VARCHAR2(600), namecontainerInfo VARCHAR2(600), classnamekeyE2containerInfo VARCHAR2(600), classnamekeyF2containerInfo VARCHAR2(600), classnamekeyG2containerInfo VARCHAR2(600), classnamekeyH2containerInfo VARCHAR2(600), classnamekeycontainerReferen VARCHAR2(600), classnamekeycontainerTemplat VARCHAR2(600), classnamekeydomainRef VARCHAR2(600), classnamekeyorganizationRefe VARCHAR2(600), classnameA2A2 VARCHAR2(600)) ].
Nested exception is: java.sql.SQLException: ORA-30556: functional index is defined on the column to be modified
Nested exception is: java.sql.SQLException: ORA-30556: functional index is defined on the column to be modified
- Exception occur when extend column width: java.sql.SQLException: ORA-30556: functional index is defined on the column to be modified
This is a printer-friendly version of Article 51402 and may be out of date. For the latest version click CS51402