技术文章 - CS252149
Windchill PDMLink 10.1 M040 中，WVS 作业监视器有报错信息“错误：ORA-01555 快照过旧；回退段号（名称为""）过小 ORA-22924：快照过旧”
已修改: 01-Mar-2019
适用于
- Windchill PDMLink 10.1 to 11.0
说明
- WVS 作业监视器有报错信息错误：ORA-01555 快照过旧；回退段号（名称为""）过小 ORA-22924：快照过旧
- 方法服务器日志中报告如下错误：
2016-12-06 06:03:30,935 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: 出现一个 SQL 错误。数据库系统消息如下:
嵌套异常是: 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
(wt.pom.pomResource/0) wt.pom.PersistenceException: 出现持续性错误，系统消息如下:
嵌套异常是: wt.pom.DatastoreException: 出现一个 SQL 错误。数据库系统消息如下:
嵌套异常是: 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
这是文章 252149 的 PDF 版本，可能已过期。最新版本 CS252149