Support Article
ORA-01555 exception while running prpcUtils to index data class
SA-51513
Summary
ORA-01555 exception while performing indexing on data class. The prpcUtils script did not complete.
Error Messages
[java] [ pegprdweb022] [ STANDARD] [ ] [ ] (.access.ResultPageIteratorImpl) ERROR - Encountered a problem when getting a result from the database
[java] java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 100 with name "_SYSSMU100_1593974939$" too small
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
Steps to Reproduce
Perform indexing on a data class using the prpcUtils script.
Root Cause
A software use or operation error. The database tablespace was less.
Resolution
Perform the following local-change:Increase the retention period by 40% with the query execution tenure.
Published March 17, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.