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 JULY 25, 2019

Applies to:

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


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

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




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.