1. Home
  2. Support
Article - CS281134

Oracle deadlock error is generated when attempting to delete vault folders before "Reset Content Replication" operation finishes

Modified: 18-May-2018   


Applies To

  • Windchill PDMLink 11.0 M030-CPS04
The error occurs if the documents are atleast 60k 

Description

A Oracle deadlock error is generated while attempting to delete vault folders before "Reset Content Replication" operation finishes.
Error in the MethodServer.log file

wt.pom.DeadlockDetectedException: Deadlock is detected on one or more objects in the database
Nested exception is: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
 at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:929)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
 at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
 at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:575)
 at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:539)
 at wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:282)
 at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234)
 at wt.pds.BasicResultCursor.next(BasicResultCursor.java:82)
 at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:837)
 at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1076)
 at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:985)
 at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972)
 at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1465)
 at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1123)
 
This is a printer-friendly version of Article 281134 and may be out of date. For the latest version click CS281134