Po-proc-sup Full Sandbox Slow (Doc ID 2257154.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Version 12.1.3 Purchasing / Endeca

PO-PROC-SUPP Full Load graph errors.
READ_SUPPLIER_ANALYSIS_VIEW_DATA finished with status ERROR.

Installed Information Discovery 12.1v7 (12.1.3.7)
Run po-proc-sup full sandbox is slow and it failed after three days on DenormalizeData.grf
This is a large purchasing environment , sandbox needs to collect two years of data.

It is running forever on this query:
SELECT SUM (DECODE(POLL.QUANTITY, NULL, (POLL.AMOUNT - POLL.AMOUNT_CANCELLED), (( POLL.QUANTITY - POLL.QUANTITY_CANCELLED ) * NVL(POLL.PRICE_OVERRIDE,0)) ) ) FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL WHERE POLL.PO_LINE_ID = POL.PO_LINE_ID AND POL.FROM_HEADER_ID = :B1 AND NVL(POLL.CONSIGNED_FLAG,'N') <> 'Y'

po line locations and po lines all all have 6 million rows each

ERROR

ERROR 170808 [WatchDog_170808] Component [Read supplier analysis view data:
  READ_SUPPLIER_ANALYSIS_VIEW_DATA] finished with status ERROR. (Out0: 0 recs, Out1:0 recs)
executeQuery, Exception = 2048
2017-01-18 21:49:26,629 ERROR 170808 [WatchDog_170808] 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)
 ...
... 3 more
Caused by: java.sql.SQLException: executeQuery, Exception = 2048
at weblogic.jdbc.wrapper.JDBCWrapperImpl.invocationExceptionHandler(JDBCWrapperImpl.java:142)
at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:518)
at org.jetel.connection.jdbc.SQLCloverStatement.executeQuery(SQLCloverStatement.java:480)
at org.jetel.connection.jdbc.SQLDataParser.setDataSource(SQLDataParser.java:324)
... 6 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 2048
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readLongMSB(T4CSocketInputStreamWrapper.java:200)
at oracle.jdbc.driver.T4CMAREngineStream.buffer2Value(T4CMAREngineStream.java:851)
at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB4(T4CMAREngineStream.java:538)
at oracle.jdbc.driver.T4CMAREngine.unmarshalDALC(T4CMAREngine.java:1709)
at oracle.jdbc.driver.T4C8TTIuds.unmarshal(T4C8TTIuds.java:150)
..

....
!!! Phase finished with error - stopping graph run !!!
2017-01-18 21:49:26,661 ERROR 170808 [JobFinalizer_170808]
------------------------------------------------------------ Error details -------------------------------------------------------------
 Component [Read supplier analysis view data:READ_SUPPLIER_ANALYSIS_VIEW_DATA] finished with status ERROR. (Out0: 0 recs, Out1: 0 recs)
  executeQuery, Exception = 2048
----------------------------------------------------------------------------------------------------------------------------------------


STEPS

1.  Run po-proc-sup full sandbox
- po-proc-sup full load does not complete

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