My Oracle Support Banner

Endeca - Incremental Load Fails Wiith ORA-01722 If Shopping Category Have Two Different Parent Category (Doc ID 2398140.1)

Last updated on MAY 13, 2018

Applies to:

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

Symptoms

Version 12.2.6 iProcurement / Endeca

Incremental Load in i-Procurement for Endeca refresh is failing due to some Shopping category hierarchy mapping with Top category and child category.
Oracle allows to assign multiple child shopping categories under the different parent categories , however Endeca Incremental load programs fails in this scenario .
Once those categories hierarchy are deleted Endeca Incremental load gets completed normal.

STEPS
------------
 1. Assign multiple child shopping categories under the different parent categories
 2. Submit Incremental Load :
  N) Information Discovery Administrator > Submit Request > Single Request >
  Program Name # Run Clover ETL Graphs
  Sandbox icx-iproc
  Graph Type ; IncrementalLoadConfig.grf
  3 Program completes in Error .
  Request ID 1157953 Completed / Error

ERROR
------------
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! Component [Read ICX_CAT_ENDECA_ITEMS_V:READ_ICX_CAT_ENDECA_ITEMS_V] finished with status ERROR. (Out0: 0 recs) ORA-01722: invalid number
... 7 more
For error details please login to Clover URL (http://tstendovmid01.us.pioneernrc.pvt:7006/clover) and look for run ID : 371766 in Execution History

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!


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