In Oracle E-Business Suite Information Discovery, Release 12.2 V7, Product-Specific Full Load Fails for iProcurement - Attempt to add/replace record with multiple assignments from single-assign property "ZONESB"

(Doc ID 2190355.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

In Oracle EBS Information Discovery V7 for EBS Release 12.2.6, an error occurs when attempting to perform the full load as part of the initial installation/setup.
The full load is failing for "icx-iproc" (Oracle iProcurement product-specific).

Due to this issue, users complete the setup for Information Discovery and the product cannot be used.


Error

154403 node01 icx-iproc/graph/FullLoadConfig.grf (3 children)
==============================================================

2016-10-03 08:19:07,127 ERROR 154403 [WatchDog_154403] Component [Run Load Data Full:RUN_LOAD_DATA_FULL] finished with status ERROR. (In0: 1 recs, Out0: 0 recs)
 Execution of graph './graph/LoadDataFull.grf' failed!
  Component [Run Data Denormalizer:RUN_DATA_DENORMALIZER] finished with status ERROR.
  Execution of graph './graph/Impl/DataDeNormalizerDesc.grf' failed!
  Graph element [Bulk Add/Replace Records:BULK_ADD_OR_REPLACE_FOR_ITEMS] failed with unknown cause.
2016-10-03 08:19:07,127 ERROR 154403 [WatchDog_154403] Error details:
org.jetel.exception.JetelRuntimeException: Component [Run Load Data Full:RUN_LOAD_DATA_FULL] 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/LoadDataFull.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 more
Caused by: org.jetel.exception.JetelRuntimeException: Component [Run Data Denormalizer:RUN_DATA_DENORMALIZER] finished with status ERROR.
 Execution of graph './graph/Impl/DataDeNormalizerDesc.grf' failed!
  Graph element [Bulk Add/Replace Records:BULK_ADD_OR_REPLACE_FOR_ITEMS] failed with unknown cause.
  ... 7 more

2016-10-03 08:19:07,189 ERROR 154403 [WatchDog_154403] !!! Phase finished with error - stopping graph run !!!
2016-10-03 08:19:07,194 ERROR 154403 [JobFinalizer_154403]
--------------------------------------------- Error details -----------------------------------------------
  Component [Run Load Data Full:RUN_LOAD_DATA_FULL] finished with status ERROR. (In0: 1 recs, Out0: 0 recs)
  Execution of graph './graph/LoadDataFull.grf' failed!
  Component [Run Data Denormalizer:RUN_DATA_DENORMALIZER] finished with status ERROR.
  Execution of graph './graph/Impl/DataDeNormalizerDesc.grf' failed!
  Graph element [Bulk Add/Replace Records:BULK_ADD_OR_REPLACE_FOR_ITEMS] failed with unknown cause.
-----------------------------------------------------------------------------------------------------------



154412 node01 icx-iproc/graph/LoadDataFull.grf (4 children)
============================================================

2016-10-03 08:19:07,079 ERROR 154412 [WatchDog_154412] Component [Run Data Denormalizer:RUN_DATA_DENORMALIZER] finished with status ERROR.
 Execution of graph './graph/Impl/DataDeNormalizerDesc.grf' failed!
  Graph element [Bulk Add/Replace Records:BULK_ADD_OR_REPLACE_FOR_ITEMS] failed with unknown cause.
2016-10-03 08:19:07,080 ERROR 154412 [WatchDog_154412] Error details:
org.jetel.exception.JetelRuntimeException: Component [Run Data Denormalizer:RUN_DATA_DENORMALIZER] finished with status ERROR.
  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/Impl/DataDeNormalizerDesc.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:288)
  at org.jetel.graph.Node.run(Node.java:562)
  ... 3 more
Caused by: org.jetel.exception.JetelRuntimeException: Graph element [Bulk Add/Replace Records:BULK_ADD_OR_REPLACE_FOR_ITEMS] failed with unknown cause.
  ... 7 more

2016-10-03 08:19:07,080 ERROR 154412 [WatchDog_154412] !!! Phase finished with error - stopping graph run !!!
2016-10-03 08:19:07,119 ERROR 154412 [JobFinalizer_154412]
------------------------------------------ Error details --------------------------------------------
  Component [Run Data Denormalizer:RUN_DATA_DENORMALIZER] finished with status ERROR.
  Execution of graph './graph/Impl/DataDeNormalizerDesc.grf' failed!
  Graph element [Bulk Add/Replace Records:BULK_ADD_OR_REPLACE_FOR_ITEMS] failed with unknown cause.
-----------------------------------------------------------------------------------------------------



154417 node01 icx-iproc/graph/Impl/DataDeNormalizerDesc.grf
============================================================

2016-10-03 08:19:06,670 ERROR 154417 [SocketReader] Received error message from server: Attempt to add/replace record with multiple assignments from single-assign property "ZONESB",-
2016-10-03 08:19:06,676 ERROR 154417 [WatchDog_154417] Graph element [Bulk Add/Replace Records:BULK_ADD_OR_REPLACE_FOR_ITEMS] failed with unknown cause.
2016-10-03 08:19:06,677 ERROR 154417 [WatchDog_154417] Error details:
org.jetel.exception.JetelRuntimeException: Graph element [Bulk Add/Replace Records:BULK_ADD_OR_REPLACE_FOR_ITEMS] failed with unknown cause.
  at org.jetel.graph.runtime.WatchDog.watch(WatchDog.java:507)
  at org.jetel.graph.runtime.WatchDog.executePhase(WatchDog.java:687)
  at org.jetel.graph.runtime.WatchDog.call(WatchDog.java:288)
  at org.jetel.graph.runtime.WatchDog.call(WatchDog.java:71)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  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)

2016-10-03 08:19:06,677 ERROR 154417 [WatchDog_154417] !!! Phase finished with error - stopping graph run !!!
2016-10-03 08:19:06,706 ERROR 154417 [JobFinalizer_154417]
----------------------------------------- Error details -------------------------------------------
  Graph element [Bulk Add/Replace Records:BULK_ADD_OR_REPLACE_FOR_ITEMS] failed with unknown cause.
---------------------------------------------------------------------------------------------------




Steps to Reproduce

This is per the instructions in <Note:2097196.1> "Installing Oracle E-Business Suite Information Discovery, Release 12.2 V7".
The process fails from Section "4.3.3.2 Deploy Oracle E-Business Suite Artifacts and Integrate with Oracle E-Business Suite Instance "", section "c) Perform product-specific configuration" for product Oracle iProcurement.

Oracle E-Business Suite Information Discovery Integration and System Administration Guide, Release 12.2 V7
Chapter 20 "Oracle iProcurement Information Discovery Plus" lists the product-specific steps required.
- Page 20-31 - "Running the Full Load Configuration Graph"
is the task being performed.



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