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.

Symptoms

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

Cause

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