FA_EID_F_ASSET_V.xdf Sub Query Returns More That One Row$Header FA_EID_F

(Doc ID 2225816.1)

Last updated on JANUARY 23, 2017

Applies to:

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


On : 12.1.3 version, FA Addition

When attempting to run the FullLoadConfig.grf for endecca data refresh
the following error occurs.

2017-01-15 13:13:06,066 ERROR 170940 [WatchDog_170940] Component [FA_EID_F_ASSET_V:FA_EID_F_ASSET_V] finished with status ERROR. (Out0: 0 recs)
 ORA-01427: single-row subquery returns more than one row
2017-01-15 13:13:06,068 ERROR 170940 [WatchDog_170940] Error details:
org.jetel.exception.JetelRuntimeException: Component [FA_EID_F_ASSET_V:FA_EID_F_ASSET_V] finished with status ERROR. (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: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

The issue can be reproduced at will with the following steps:
1. Navigate to Information Discovery responsibility
2. Run the Endeca full load program
3. Program is ending with error

The issue has the following business impact:
Due to this issue, users cannot refresh the Endeca data
and reports cannot be extract because of this


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