E-COB/AE: "ORA-01555: snapshot too old: rollback segment number 8 with name..." Error When Running Cobol Program SRPCAARP

(Doc ID 2254410.1)

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.

PeopleTools: 8.53
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