Article - CS398322
Upgrademanager failed with error "java.sql.SQLException: ORA-01502" while running "Update Container Templates" in Windchill PDMLink
Modified: 03-Aug-2023
Applies To
- Windchill PDMLink 12.0 to 12.1
Description
- Upgrademanager failed with below error while running "Update Container Templates"
- Error in Methodserver log
ERROR [RMI TCP Connection(160)-10.0.0.113] wt.pds.exception <user> - Suppressing internal message (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows: Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "INSERT INTO StreamData(classnameA2A2,updateCountA2,lobLoc,quarantined,revaultSessionId,streamId,markForDeleteA2,uniqueSequenceNumber,updateStampA2,createStampA2,modifyStampA2,idA2A2) VALUES ('wt.content.StreamData',1,?,?,?,?,?,?,?,?,?,?)". Database system message follows: Nested exception is: java.sql.SQLException: ORA-01502: index '<dbuser>.PK_STREAMDATA' or partition of such index is in unusable state
This is a printer-friendly version of Article 398322 and may be out of date. For the latest version click CS398322