My Oracle Support Banner

Error: 'ORA-06512: at "STARUSER.REBUILD_INDEXES", line 6' & 'ORA-01555: snapshot too old: rollback segment number with name "" too small' When Running Data Warehouse ETL (Doc ID 2436283.1)

Last updated on AUGUST 17, 2018

Applies to:

Primavera Analytics Cloud Service - Version 16.1.0.0 and later
Primavera Analytics - Version 15.2.0.0 and later
Primavera Data Warehouse - Version 15.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the Primavera Analytics ETL (aka, Data Warehouse ETL) process the following error occurs:

ERROR
-----------------------
staretl [INFO] (Progress) - Finished Script resource_assignment_spread.sql
staretl [INFO] (Message) - ORA-06512: at "STARUSER.REBUILD_INDEXES", line 6
staretl [INFO] (Message) - ORA-06512: at line 209
staretl [INFO] (Message) - Exception: Error during extract for table W_ACTIVITY_SPREAD_HF: ORA-01555:
staretl [INFO] (Message) - snapshot too old
staretl [INFO] (Message) - (100,W_ACTIVITY_SPREAD_FS,W_ACTIVITY_SPREAD_HF,n/a,n/a)
staretl [INFO] (Message) - declare
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-01555: snapshot too old: rollback segment number with name "" too small


Steps to Duplicate
-----------------------
The issue can be reproduced at will with the following steps:

  1. Log into Primvara Analytics Administration
  2. Run ETL

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!


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