E-COB/AE: "ORA-01555: snapshot too old: rollback segment number 8 with name..." Error When Running Cobol Program SRPCAARP
Last updated on APRIL 25, 2017
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
Getting below error when trying to manually run SRPCAAPR Academic Advisement Report Generation to process 55K students.
ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8_1001157730$" too small
Our DBA increased UNDO tablespace from 24GB to 28GB and UNDO_RETENTION from 900 to 1800, and still couldn't fix the issue.
We tried to narrow down the population during the first step of the process SAA_RPT_RQST (App Engine), but the run control page of SRPCAAPR is picking up the population by the report date, not date/time. Therefore it won't help resolve the issue.
Application : CS 9.0
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms