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 22.214.171.124 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 126.96.36.199 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