My Oracle Support Banner

FA_EID_F_ASSET_V.xdf Sub Query Returns More That One Row$Header FA_EID_F (Doc ID 2225816.1)

Last updated on OCTOBER 26, 2020

Applies to:

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

Symptoms

On : 12.1.3 version, FA Addition

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

ERROR
-----------------------
2017-01-15 13:13:06,066 ERROR 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 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


STEPS
-----------------------
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

BUSINESS IMPACT
-----------------------
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

Changes

 

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.