ETL Fails With ORA-30036:Unable to Extend Segment in UNDO Tablespace

(Doc ID 2325928.1)

Last updated on DECEMBER 13, 2017

Applies to:

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

Symptoms

When attempting to run the ETL process (staretl.bat),
the following error occurs.

Error

staretl [INFO] (Message) - === Step 38, Part 1 ====================================================
staretl [INFO] (Message) - === Rollup activity spread to WBS and project (spread_rollup/wbs_spread_rollup.sql)
staretl [DEBUG] (Message) - SQL Plus(4) : [-s] [********] [@runscript.sql] [SCRIPTNAME:spread_rollup/wbs_spread_rollup.sql]
staretl [INFO] (Message) - Roll up activity spread to WBS level :: CURRENT RUN DATE: 03-NOV-17
staretl [INFO] (Message) - Exception: Error during load for table W_WBS_SPREAD_F: ORA-30036: unable to
staretl [INFO] (Message) - extend segment
staretl [INFO] (Message) - (100,W_ACTIVITY_SPREAD_F,W_WBS_SPREAD_F,n/a,n/a)
staretl [INFO] (Message) - declare
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS2'
staretl [INFO] (Message) - ORA-06512: at "STARUSER.SPREAD_ROLLUP_PKG", line 390
staretl [INFO] (Message) - ORA-06512: at line 4
staretl [INFO] (Progress) - Step 38/51 Part 1/2 - FAILED (84) (0 hours, 11 minutes, 1 seconds, 915 milliseconds)


Steps to Reproduce
1. Run staretl.bat (.sh)


Changes

 

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