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 18.104.22.168 and later
Information in this document applies to any platform.
When attempting to execute an ETL job, the following error is shown in the log.
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
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