My Oracle Support Banner

Analytics ETL Job Fails With Error "ORA-30036: unable to extend segment" (Doc ID 2603836.1)

Last updated on MAY 06, 2020

Applies to:

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

Symptoms

When attempting to execute an ETL job, the following error is shown in the log.

ERROR
Complete load on W_RESOURCE_HIERARCHY_D

ODI-1228: Task Procedure-Update Parent Dim SCD Dates-Update Activity Code/UDF Dates fails on the target  connection PRIMAVERA_ANALYTICS_TGT_DS. Caused By: java.sql.SQLException: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1' ORA-06512: at "STARUSER.SCD", line 327 ORA-06512: at line 2 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495) at

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
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.