1. Home
  2. Supporto
Article - CS79439

Getting ORA-01555 "snapshot too old: rollback segment ### too small" error in Windchill

Modified: 12-Aug-2024   


Applies To

  • Windchill PDMLink 8.0 to 12.1

Description

  • Some reported use cases:
    • Happens when trying to view queue from Site > Utilities > Queue Manager
    • Running WinDu task, e.g. DanglingPBORef report, SequenceAnalysis
    • Executing search which will cost much time
  • Error reported in the log files:
Caused by: wt.util.WTException: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number ### with name "_SYSSMUxxxxxxxxx$" too small
Nested exception is: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number ### with name "_SYSSMUxxxxxxxxx$" too small
    <some specific stack from the use case> 
Caused by: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number ### with name "_SYSSMUxxxxxxxxx$" too small

     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
     at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1108)
     at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:373)
     at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:277)


     
This is a printer-friendly version of Article 79439 and may be out of date. For the latest version click CS79439