Endeca: ONT Fullload fails with ORA-06502 ORA-06512: at "APPS.OE_ENDECA_UTILS" (Doc ID 1948426.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Order Management - Version 12.1.3.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3.4 version, Endeca Intregration

When attempting to complete load in order management with endeca, the following error occurs.

ERROR
-----------------------
2014-10-27 13:41:13,292 WARN 34459 [RUN_LOAD_DATA_FULL_34459] Some graph(s) finished with error.
2014-10-27 13:41:13,292 ERROR 34459 [WatchDog] Graph execution finished with error
2014-10-27 13:41:13,294 ERROR 34459 [WatchDog] Node RUN_LOAD_DATA_FULL finished with status: ERROR caused by: Graph './graph/LoadDataFull.grf' failed!
2014-10-27 13:41:13,294 ERROR 34459 [WatchDog] Node RUN_LOAD_DATA_FULL error details:
org.jetel.exception.JetelException: Graph './graph/LoadDataFull.grf' failed!
at org.jetel.component.RunGraph.execute(RunGraph.java:333)
at org.jetel.graph.Node.run(Node.java:453)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
2014-10-27 13:41:13,295 WARN 34459 [exNode_34459_1340062310906_LOG_ERROR_MESSAGE] LOG_ERROR_MESSAGEthread interrupted, it will interrupt child threads
java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at java.lang.Thread.join(Thread.java:1266)
at org.jetel.component.Trash.executeWithoutWriter(Trash.java:276)
at org.jetel.component.Trash.execute(Trash.java:239)
at org.jetel.graph.Node.run(Node.java:453)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
2014-10-27 13:41:13,295 ERROR 34459 [LOG_ERROR_MESSAGE_34459.InputThread#0] 515: thread forcibly aborted
java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:503)
at org.jetel.graph.DirectEdge.fillReadBuffer(DirectEdge.java:204)
at org.jetel.graph.DirectEdge.readRecordDirect(DirectEdge.java:170)
at org.jetel.graph.Edge.readRecordDirect(Edge.java:365)
at org.jetel.component.Trash$InputReader.run(Trash.java:482)
2014-10-27 13:41:13,305 ERROR 34459 [WatchDog] !!! Phase finished with error - stopping graph run !!!

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the fullload for order management.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the functionality.

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