My Oracle Support Banner

ECC Process Genealogy And Trace Full Load Program Fails With Error "DataLoadControllerServiceImpl - job failed with error code:There is an error while trying to ingest data for this load rule GMO_ECC_GNT_PVT.GET_ECC_DATA_LOAD_INFO" (Doc ID 3075419.1)

Last updated on MARCH 05, 2025

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

Process Genealogy and Trace - Full Load program is failing after ECC upgrade to V12.2.9
This program run for around 3 hours and fails in the end.

ERROR
-----------------------
.DataLoadControllerServiceImpl - job failed with error code:There is an error while trying to ingest data for this load rule GMO_ECC_GNT_PVT.GET_ECC_DATA_LOAD_INFO with dataset opm-gnt-processbatch for job 951,558. There is an error while trying to ingest data for this load rule GMO_ECC_GNT_PVT.GET_ECC_DATA_LOAD_INFO with dataset opm-gnt-processbatch for job 951,558 exception details:
java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Go to ECC Developer responsibility -> Data Load Submission
Application Name = Process Genealogy and Trace
Data Set = Process Batch (opm-gnt-processbatch)
Load Type = Full Load


Changes

 ECC upgrade to V12.2.9

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