My Oracle Support Banner

'Run Clover ETL Graphs' Fails With Error 'CloverETL Data Record PO_ENDECA_BWC_PROCPLAN_V (Doc ID 2548099.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Project Procurement - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version,

When trying to run Clover ETL Graph after application of patch 28038357 the process
encounters Error

ERROR
-----------------------
 'CloverETL data record PO_ENDECA_BWC_PROCPLAN_V contains less fields than source JDBC record !'.
+
Response from clover server - Run ID : 12345
You can check the graph status by accessing 'Executions History' from clover URL - http://domain.country.com:1234
Graph : prj-pmc/graph/Incremental.grf was running for 1020 Seconds
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:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)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 more
Caused by: org.jetel.exception.JetelRuntimeException: Component [Call incr load procedure:CALL_INCR_LOAD_PROCEDURE] finished with status ERROR.

ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.PA_ENDECA_INTEGRATION", line 12547 ORA-06512: at "APPS.PA_ENDECA_INTEGRATION", line 10623 ORA-06512: at line 1 ... 7 more

Changes

 Applied patch 28038357

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.