Enterprise Command Center (ECC) ECCRUNDL: ECC Run Data Load Errors During Full Load (Doc ID 2977124.1)

Last updated on OCTOBER 02, 2023

Applies to:

Symptoms

General Ledger is successfully imported into ECC.However, GL full data load is failing. (The metadata job which is spawned by General Ledger Command Center Data Load runs successfully, but the full load job which is spawned completes in error.)

ERROR
-----------------------

ECCRUNDL: ECC Run Data Load

Error Details:
2023-09-07 10:59:38.854 [pool-5-thread-1] ERROR 3.o.e.i.u.s.i.DataLoadControllerServiceImpl - job failed with error code:Invalid state: Trying to run data load for a dataset that seems to be empty. Full load (with reset) must run before running any incremental load flow. Invalid state: Trying to run data load for a dataset that seems to be empty. Full load (with reset) must run before running any incremental load flow. exception details:
org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.invokeDataLoad(DataLoadControllerServiceImpl.java:1730) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.loadDataForDataset(DataLoadControllerServiceImpl.java:693) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.startJob(IRDataLoadServiceImpl.java:968) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.tryToStartJob(IRDataLoadServiceImpl.java:552) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.lambda$runLoadDataForApplicationWorkFlow$22(IRDataLoadServiceImpl.java:2316) [ecc-ir-1.0.0.jar:na]
at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1640) ~[na:1.8.0_321]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_321]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_321]
at java.lang.Thread.run(Thread.java:750) ~[na:1.8.0_321]


The issue can be reproduced at will with the following steps:
1. Log into Applications.
2. General Ledger Super User
3. Other > Requests
4. Choose General Ledger Command Center Data Load

Cause

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