ECCRUNDL: ECC Run Data Load Failing With Errors "ORA-01652,unable to extend temp segment by 128 in tablespace TEMP2,java.lang.UnsupportedOperationException" (Doc ID 3067616.1)

Last updated on JANUARY 15, 2025

Applies to:

Symptoms

General Ledger Command Center Data Load is completing with error as the child program ECCRUNDL: ECC Run Data Load is failing with the error.
 

ERROR
-----------------------
statusMessage: There is an error while trying to ingest data for this load rule GL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset gl-aa for job 33,548 ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2
 Error Details:
2025-01-02 17:33:56.966 [pool-3-thread-4] ERROR 3.o.e.i.u.services.impl.IndexerImpl - job failed with error code:There was an error while fetching number of records from solr to be deleted, error is :{} There was an error while fetching number of records from solr to be deleted, error is :{} exception details:
java.lang.UnsupportedOperationException: null

Caused by: oracle.jdbc.OracleDatabaseException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2
at java.base/java.lang.Thread.run(Thread.java:834) ~[na:na]
2025-01-02 21:07:46.971 [pool-3-thread-4] ERROR 3.o.e.i.u.services.impl.IndexerImpl - job failed with error code:There was an error while fetching number of records from solr to be deleted, error is :{} There was an error while fetching number of records from solr to be deleted, error is :{} exception details:
java.lang.UnsupportedOperationException: null
at oracle.ecc.context.UserContext$$EnhancerBySpringCGLIB$$7b9da87f.getSourceSystem() ~[ecc-core-1.0.0.jar:na]
at oracle.ecc.persistence.repositories.impl.DatasetBasicRepositoryImpl.getDatasetByKey(DatasetBasicRepositoryImpl.java:98) ~[ecc-core-1.0.0.jar:na]
 Error Details:
CP main completed runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP


The issue can be reproduced at will with the following steps:
1. Log into General Ledger Responsibility
2. View > Requests > Submit New Request > Run General Ledger Command Center Data Load

Changes

Application Upgraded to 12.2.13 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.