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 AUGUST 19, 2019

Applies to:

Primavera Gateway - Version 15.2.0.0 and later
Primavera 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


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