ETL Process Fails With Error: "ORA-25153: Temporary Tablespace is Empty" (Doc ID 1672378.1)

Last updated on MAY 02, 2017

Applies to:

Primavera P6 Analytics - Version R1.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the STARETL PROCESS, the following error occurs.

ERROR
-----------------------

staretl [INFO] (Message) - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 85
staretl [INFO] (Message) - Exception: Error during extract for table W_WBS_HIERARCHY_DS: ORA-25153: Temporary Tablespa
staretl [INFO] (Message) - (100,WBSHIERARCHY,W_WBS_HIERARCHY_DS,n/a,n/a)
staretl [INFO] (Message) - BEGIN
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-25153: Temporary Tablespace is Empty
staretl [INFO] (Message) - ORA-02063: preceding line from DSLINK01
staretl [INFO] (Message) - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 132
staretl [INFO] (Message) - ORA-06512: at line 2
staretl [INFO] (Progress) - Finished Script W_WBS_HIERARCHY_DS.sql

 

Cause

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 hundreds of Community platforms