SA-19079

Summary

Users encounter errors when attempting to submit updates to their work items. Administrators are observing ORA-01555 errors in the PegaRULES logfile at these times.

Error Messages

java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-22924: snapshot too old

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)

Steps to Reproduce

This error intermittently occurs while submitting or updating the data from the application.

Root Cause

Indexes were missing from several custom tables.  This caused the tables to perform very poorly, which stresses the undo segments.  This caused the undo retention segments to fill up and ORA-01555 errors to occur.

Resolution

Ensure that your custom tables have indexes built on the columns which are commonly used for selection or update criteria.