My Oracle Support Banner

When Trying to Delete Primavera Gateway Jobs Using the Gateway Job Cleanup Script the Error "ORA-01555: Snapshot Too Old" Occurs (Doc ID 2483595.1)

Last updated on MAY 07, 2021

Applies to:

Primavera Gateway - Version and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version and later
Information in this document applies to any platform.


When attempting to use the Primavera Gateway script to delete old Gateway jobs, the following error occurs.

ORA-01555: snapshot too old: rollback segment number 9 with name "_SYSSMU9_3739287458$" too small
ORA-06512: at line 101
01555. 00000 - "snapshot too old: rollback segment number %s with name \"%s\" too small"
*Cause: rollback records needed by a reader for consistent read are
  overwritten by other writers
*Action: If in Automatic Undo Management mode, increase undo_retention
  setting. Otherwise, use larger rollback segments

The issue can be reproduced at will with the following steps:
1. Edit the Gateway_Job_Cleanup_Script.sql and set the past_days = 100 (this will delete 100 days of data)
2. Run the script and notice the error




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.