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