My Oracle Support Banner

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

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.

Values and dates shown below have been changed to fictitious values and do not represent any specific real case.
Error

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

2016-10-10 03:03:03,127 ERROR 151111 [WatchDog_151111] 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-10 03:03:03,127 ERROR 151111 [WatchDog_151111] 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-10 03:03:03,189 ERROR 151111 [WatchDog_151111] !!! Phase finished with error - stopping graph run !!!
2016-10-10 03:03:03,194 ERROR 151111 [JobFinalizer_151111]
--------------------------------------------- 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.
-----------------------------------------------------------------------------------------------------------



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

2016-10-10 03:03:03,079 ERROR 152222 [WatchDog_152222] 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-10 03:03:03,080 ERROR 152222 [WatchDog_152222] 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-10 03:03:03,080 ERROR 152222 [WatchDog_152222] !!! Phase finished with error - stopping graph run !!!
2016-10-10 03:03:03,119 ERROR 152222 [JobFinalizer_152222]
------------------------------------------ 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.
-----------------------------------------------------------------------------------------------------



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

2016-10-10 03:03:02,670 ERROR 153333 [SocketReader] Received error message from server: Attempt to add/replace record with multiple assignments from single-assign property "ZONESB",-
2016-10-10 08:03:02,676 ERROR 153333 [WatchDog_153333] Graph element [Bulk Add/Replace Records:BULK_ADD_OR_REPLACE_FOR_ITEMS] failed with unknown cause.
2016-10-10 08:03:02,677 ERROR 153333 [WatchDog_153333] 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-10 08:03:02,677 ERROR 153333 [WatchDog_153333] !!! Phase finished with error - stopping graph run !!!
2016-10-10 08:03:02,706 ERROR 153333 [JobFinalizer_153333]
----------------------------------------- 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.



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