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 15.2.0.0 and laterPrimavera P6 Enterprise Project Portfolio Management Cloud Service - Version 15.2.0.0 and later
Information in this document applies to any platform.
Symptoms
When attempting to use the Primavera Gateway script to delete old Gateway jobs, the following error occurs.
ERROR
-----------------------
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
STEPS
-----------------------
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
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |