po-proc-sup Full Load Failed with JetelRuntimeException createNodeException and SQLException: ORA-01489

(Doc ID 2275099.1)

Last updated on JULY 11, 2017

Applies to:

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

Symptoms

When attempting to Run the PO-PROC-SUP Graph/Full.grf the following error occurs.

ERROR

2017-04-04 19:35:27,322 ERROR 264127 [WatchDog_264127] Component [Read supplier analysis view data:READ_SUPPLIER_ANALYSIS_VIEW_DATA] finished with status ERROR. (Out0: 0 recs, Out1: 0 recs)
ORA-01489: result of string concatenation is too long
2017-04-04 19:35:27,322 ERROR 264127 [WatchDog_264127] Error details:
org.jetel.exception.JetelRuntimeException: Component [Read supplier analysis view data:READ_SUPPLIER_ANALYSIS_VIEW_DATA] finished with status ERROR. (Out0: 0 recs, Out1: 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: java.sql.SQLException: ORA-01489: result of string concatenation is too long
..

STEPS TO REPRODUCE

1.  Follow the instructions in <Note:2097196.1> "Installing Oracle E-Business Suite Information Discovery, Release 12.2 V7".
 
2.  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.

3. Run Full Load for 'PO-PROC-SUP' and get the exceptions

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