ORA-01427-Endeca PO-SCC Full Load Failing In Clover (Doc ID 2229585.1)

Last updated on JUNE 15, 2017

Applies to:

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

Symptoms

On : 12.2.5 version, Item Endeca Integration (v5 and lower)

Endeca PO-SCC full load failing in clover

When running the PO-SCC full load config. grf graph in clover it is failing with below error.
 ORA-01427: single-row sub query returns more than one row

ERROR
-----------------------
2016-09-27 01:19:22,074 ERROR 410855 [WatchDog_410855] Component [Run Load Data Full:RUN_LOAD_DATA_FULL] finished with status ERROR.
Execution of graph './graph/LoadDataFull.grf' failed!
 Component [Operational Dashboard:OPERATIONAL_DASHBOARD] finished with status ERROR.
  SQLException when reading resultSet
  ORA-01427: single-row subquery returns more than one row
 Inner exception: org.jetel.exception.JetelRuntimeException: Component [Operational Dashboard:OPERATIONAL_DASHBOARD] finished with status ERROR.
  at org.jetel.graph.Node.createNodeException(Node.java:543)
  at org.jetel.graph.Node.run(Node.java:522)
  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)
 Caused by: org.jetel.exception.JetelException: SQLException when reading resultSet
  at org.jetel.connection.jdbc.SQLDataParser.parseNext(SQLDataParser.java:184)
  at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:127)
  at org.jetel.component.DBInputTable.processSqlQuery(DBInputTable.java:352)
  at org.jetel.component.DBInputTable.execute(DBInputTable.java:301)
  at org.jetel.graph.Node.run(Node.java:493)
  ... 3 more
 Caused by: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Purchasing.
2. run the concurrent request: PO-SCC full load config. grf graph



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