IProcurement Endeca Incremental Load Is Failing-RUN_LOAD_DATA_INCREMENTAL

(Doc ID 2357129.1)

Last updated on FEBRUARY 04, 2018

Applies to:

Oracle iProcurement - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Version 12.2.6 v7 iProcurement / Endeca

iProcurement Endeca incremental load failing with error.
Full load ran successfully.
This is the first time to run the incremental load.


ERROR
-------------
Graph : icx-iproc/graph/IncrementalLoadConfig.grf was running for 60 Seconds
Graph execution failed with error message : ERROR
Error Stack for failure is :
org.jetel.exception.JetelRuntimeException:
 Component [Run Load Data Incremental:RUN_LOAD_DATA_INCREMENTAL] finished with status ERROR.
 (In0: 1 recs, Out0: 0 recs) at org.jetel.graph.Node.createNodeException(Node.java:631)
 at org.jetel.graph.Node.run(Node.java:599)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
 at java.lang.Thread.run(Thread.java:745)
Caused by: org.jetel.exception.JetelRuntimeException: Execution of graph './graph/LoadDataIncr.grf' failed!
 at org.jetel.component.RunGraph.logError(RunGraph.java:550)
 at org.jetel.component.RunGraph.runGraphThisInstance(RunGraph.java:543)
 at org.jetel.component.RunGraph.runSingleGraph(RunGraph.java:412)
 at org.jetel.component.RunGraph.execute(RunGraph.java:313)
  at org.jetel.graph.Node.run(Node.java:562) ...
3 moreCaused by: org.jetel.exception.JetelRuntimeException:
 Component [Run Incremental Data Denormalizer:RUN_INCREMENTAL_DATA_DENORMALIZER] finished with status ERROR.
 Execution of graph './graph/Impl/IncrDataDeNormalizerDesc.grf' failed!
  Graph element [Merge Item Records:MERGE_ITEM_RECORDS] failed with unknown cause. ...
7 more
 For error details please login to Clover URL (http://tstendovmid01.us.pioneernrc.pvt:7006/clover)
  and look for run ID : 210249 in Execution History
 Update statement = UPDATE FND_EID_ETL_AUDITS SET REQUEST_ID = :1
 WHERE EID_DATA_STORE_NAME = (
  SELECT EID_DATA_STORE_NAME FROM FND_EID_INSTANCES WHERE EID_INSTANCE_ID = :2
) AND ETL_LAST_RUN_ENDECA_ID = :3
 Parameters passed = Request Id = 791948 Instance Id = 1 runId = 210249
 # records Updated = 1
 After Commit
Request Id Successfully stamped in fnd_eid_etl_audits table

STEPS
-------------
  1. Run incremental load
  2. Error thrown

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms