ORA-01427 Errors While Running prj-pmc and prj-pjt Full Load

(Doc ID 2405768.1)

Last updated on MAY 31, 2018

Applies to:

Oracle Project Planning and Control - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Endeca Integration

When attempting to prj-pmc full load the following error occurs.

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 [Customer Invoice:CUSTOMER_INVOICE] finished with status ERROR. (Out0: 0 recs)
 ORA-01427: single-row subquery returns more than one row

 

while running prj-pjt full load it is failed with

ERROR 264127 [WatchDog_264127] Component [Load Views in Data Domain:LOAD_VIEWS_IN_DATA_DOMAIN1] finished with status ERROR. (In0: 1 recs, Out0: 0 recs)

In statement "SOV_BCC_CHART_TEMP": In computing attribute "TOTAL_PROGRESS_AMOUNT": This corpus does not have an attribute named "SOV_BCC_ACTUAL_PROGRESS_AMT"
ERROR 264127 [WatchDog_264127] Error details:
org.jetel.exception.JetelRuntimeException: Component [Load Views in Data Domain:LOAD_VIEWS_IN_DATA_DOMAIN1] 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:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.axis2.AxisFault: In statement "SOV_BCC_CHART_TEMP": In computing attribute "TOTAL_PROGRESS_AMOUNT": This corpus does not have an attribute named "SOV_BCC_ACTUAL_PROGRESS_AMT"
at com.opensys.cloveretl.component.ws.proxy.b.onFault(Unknown Source)
at org.apache.axis2.description.OutInAxisOperationClient$NonBlockingInvocationWorker.run(OutInAxisOperation.java:462)
... 3 more

 ERROR 264127 [WatchDog_264127] !!! Phase finished with error - stopping graph run !!!
 ERROR 264127 [JobFinalizer_264127]
------------------------------------------------------------------------ Error details -------------------------------------------------------------------------
Component [Load Views in Data Domain:LOAD_VIEWS_IN_DATA_DOMAIN1] finished with status ERROR. (In0: 1 recs, Out0: 0 recs)
In statement "SOV_BCC_CHART_TEMP": In computing attribute "TOTAL_PROGRESS_AMOUNT": This corpus does not have an attribute named "SOV_BCC_ACTUAL_PROGRESS_AMT"
----------------------------------------------------------------------------------------------------------------------------------------------------------------

 





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