My Oracle Support Banner

Error 'ORA-01422: Exact Fetch Returns More than Requested Number of Rows' When Attempting to Run the ETL Process (Doc ID 2438351.1)

Last updated on JULY 29, 2021

Applies to:

Primavera Analytics - Version 17.7 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the ETL Process the following error occurs:

17:38:59.346 [main] INFO ETL.Message - === Step 60, Part 1 ====================
17:38:59.346 [main] INFO ETL.Message - === Merge Temp tables for History (populate_temp_spread_per.sql)
17:38:59.362 [main] DEBUG ETL.Message - SQL Plus(4) : [-s] [********] [@run$script.sql] [SCRIPTNAME:populate_temp_spread_per.sql]
17:39:00.971 [Thread-1] INFO ETL.Message - ACTIVITY HISTORY MERGE :: CURRENT RUN DATE: 22-AUG-18
17:39:00.971 [Thread-1] INFO ETL.Message - Exception: Error during load for table W_ACTIVITY_SPREAD_PER_TS: ORA-01422:
17:39:00.971 [Thread-1] INFO ETL.Message - exact fetch ret
17:39:00.971 [Thread-1] INFO ETL.Message - (100,W_ACTIVITY_SPREAD_PER_TS,W_ACTIVITY_SPREAD_PER_TS,n/a,n/a)
17:39:00.971 [Thread-1] INFO ETL.Message - DECLARE
17:39:00.971 [Thread-1] INFO ETL.Message - *
17:39:00.971 [Thread-1] INFO ETL.Message - ERROR at line 1:
17:39:00.971 [Thread-1] INFO ETL.Message - ORA-01422: exact fetch returns more than requested number of rows
17:39:00.971 [Thread-1] INFO ETL.Message - ORA-06512: at "STARUSER.MERGE_TEMP_HISTORY_PKG", line 228
17:39:00.987 [Thread-1] INFO ETL.Message - ORA-06512: at "STARUSER.GETDAYROW", line 49
17:39:00.987 [Thread-1] INFO ETL.Message - ORA-06512: at "STARUSER.GETDAYROW", line 97
17:39:00.987 [Thread-1] INFO ETL.Message - ORA-06512: at "STARUSER.MERGE_TEMP_HISTORY_PKG", line 50
17:39:00.987 [Thread-1] INFO ETL.Message - ORA-06512: at "STARUSER.MERGE_TEMP_HISTORY_PKG", line 50
17:39:00.987 [Thread-1] INFO ETL.Message - ORA-06512: at line 4
17:39:01.018 [main] INFO ETL.Progress - Step 60/74 Part 1/3 - FAILED (1422) (0 hours, 0 minutes, 3 seconds, 469 milliseconds)

17:39:02.862 [main] DEBUG ETL.Message - Main Arguments(7) : [/ACTION:JAVA] [com.primavera.er.stage.client.RenameLogFileToProcessId] [failed] [STAR] [/LOG:N] [/UPDATESTATUS:N] [/DESC:

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.