My Oracle Support Banner

ECC Data Load Completes With Error "Another job is already pending for this dataset <dataset_name>. These jobs ids are <request_id(s)>" (Doc ID 2793202.1)

Last updated on JUNE 24, 2022

Applies to:

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

Goal

The following example messages are found in the debug log for when running a data load for one of the Enterprise Command Center (ECC) dashboards.
In this example, ECC V4 is installed.

Concurrent request ID is 45210333
PARAMETERS LIST :
    SystemId -> EBS
    Application Short Name -> inv
    Load Type -> INCREMENTAL_LOAD
    DataSet Key -> Delivery_Details
    Language ->
    Trace Flag ->
    Log Level -> ERROR
Running Incremental Load
ERROR: 400 {"title":"Another job is already pending for this dataset Delivery_Details. These jobs ids are 59631","errorKey":null,"stackTraceStr":null,"status":400,"detail":[{"methodName":"endAuditRequestWithFailure","fileName":"IRDataLoadServiceImpl.java","lineNumber":278,"className":"oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl","nativeMethod":false},{"methodName":"reportOtherJobsInQueueError","fileName":"IRDataLoadServiceImpl.java","lineNumber":393,"className":"oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl","nativeMethod":false},{"methodName":"azzertNoOtherIncrementalPending","fileName":"IRDataLoadServiceImpl.java","lineNumber":319,"className":"oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl","nativeMethod":false}],"timeStamp":"2021-06-21T18:45:36","debugMessage":"oracle.ecc.index.retrieve.exceptions.InvalidRequestException"}
JobId -> -1
data load concurrent program failed
CP main completed runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP

Querying the "Data Load Tracking" form reveals there are no data loads running or pending for this dashboard.
How do you submit the data load?

Solution

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