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 FEBRUARY 27, 2019

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 XXXXXXX 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

Changes

 

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!


In this Document
Symptoms
Changes
Cause
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.