1. Home
  2. Support
Article - CS252149

'ORA-01555: snapshot too old: rollback segment number string with name "" too small ORA-22924: snapshot too old' error occurs when accessing WVS Job Monitor in Windchill PDMLink 10.1

Modified: 26-Dec-2019   


Applies To

  • Windchill PDMLink 10.1 to 11.0

Description

  • ORA-01555: snapshot too old: rollback segment number string with name "" too small ORA-22924: snapshot too old error occurs when accessing WVS Job Monitor
  • Following error seen in MethodServer
ERROR [DataSource Task Executor-9300] com.ptc.mvc.components.ds.AbstractDataSourceComponentDataBuilder Administrator - Unable to process component data for component: wvsQueueMonitorTableId
(wt.pom.pomResource/0) wt.pom.PersistenceException:
wt.pom.DatastoreException:
java.io.IOException: ORA-01555:
ORA-22924:
at oracle.jdbc.driver.OracleBlobInputStream.needBytes(OracleBlobInputStream.java:204)
at oracle.jdbc.driver.OracleBufferedStream.needBytes(OracleBufferedStream.java:68)
at oracle.jdbc.driver.OracleBufferedStream.readInternal(OracleBufferedStream.java:122)
at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java:104)
at wt.pds.PDSEncoder$DecodeObjectInputStream.setInput(PDSEncoder.java:774)
at wt.pds.PDSEncoder.setInput(PDSEncoder.java:242)
at wt.pds.AbstractLobHandler.getLobAsObject(AbstractLobHandler.java:387)
at wt.pds.SQLDatabasePds.getLobAsObject(SQLDatabasePds.java:1188)
at wt.pds.WTResultSet.getLobAsObject(WTResultSet.java:974)
at wt.pds.WTResultSet.getObject(WTResultSet.java:325)
at wt.pds.AbstractPersistentRetrieve.getInlineObject(AbstractPersistentRetrieve.java:211)
at wt.queue._QueueEntry.readExternal(_QueueEntry.java:154)
at wt.pds.WTResultSet.readObject(WTResultSet.java:602)
at wt.pds.PersistableItemBuilder.build(PersistableItemBuilder.java:559)
at wt.pds.StandardACProcessor.processResults(StandardACProcessor.java:99)
at wt.pds.SequentialResultBuilder.build(SequentialResultBuilder.java:373)
at wt.pds.BasicResultCursor.next(BasicResultCursor.java:93)
at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:687)
at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1106)
at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1834)
at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1786)
at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1362)
at com.ptc.wvs.server.publish.PublishQueueHelper.getProcessedQueueEntries(PublishQueueHelper.java:1179)
at com.ptc.windchill.enterprise.wvs.wvsQueueMonitor.commands.QueueMonitorTableModels.addProcessedJobsToPage(QueueMonitorTableModels.java:516)
at com.ptc.windchill.enterprise.wvs.wvsQueueMonitor.commands.QueueMonitorTableModels.getQueueEntries(QueueMonitorTableModels.java:406)
at com.ptc.windchill.enterprise.wvs.wvsQueueMonitor.builders.QueueMonitorJobListBuilder.buildComponentData(QueueMonitorJobListBuilder.java:273)
at com.ptc.jca.mvc.components.DefaultJcaComponentDataBuilder.buildRawDataAsync(DefaultJcaComponentDataBuilder.java:91)
at com.ptc.mvc.components.ds.AbstractDataSourceComponentDataBuilder$ComponentDataSourceTask.run(AbstractDataSourceComponentDataBuilder.java:390)
at com.ptc.mvc.ds.server.DefaultDataSourceManager$DataSourceTaskCallable.callInContext(DefaultDataSourceManager.java:226)
at com.ptc.mvc.ds.server.DefaultDataSourceManager$DataSourceTaskCallable.callInContext(DefaultDataSourceManager.java:195)
at com.ptc.mvc.ds.server.MethodContextCallable.call(MethodContextCallable.java:46)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-01555:
ORA-22924:
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
at oracle.jdbc.driver.T4C8TTILob.processError(T4C8TTILob.java:792)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8TTILob.read(T4C8TTILob.java:146)
at oracle.jdbc.driver.T4CConnection.getBytes(T4CConnection.java:2392)
at oracle.sql.BLOB.getBytes(BLOB.java:348)
at oracle.jdbc.driver.OracleBlobInputStream.needBytes(OracleBlobInputStream.java:181)
... 35 more
This is a printer-friendly version of Article 252149 and may be out of date. For the latest version click CS252149