Incremental Load fails with error 'ORA-01427: single-row subquery returns more than one row' (Doc ID 1376197.1)

Last updated on AUGUST 28, 2014

Applies to:

Primavera P6 Reporting Database - Version R2 and later
Information in this document applies to any platform.
Check for Currency on 03-May-2013

Symptoms

During the execution of the incremental.bat (.sh), the following error is thrown:

incremental [INFO] (Message) - === Run update of Star direct dimension tables
incremental [INFO] (Message) - === Run update of Star direct dimension tables (star_etl_update_table_both_update_project_eps_wid.sql)
incremental [DEBUG] (Message) - SQL Plus(4) : [-s] <'Staruser' account connection info> [SCRIPTNAME:star_etl_update_table_both_update_project_eps_wid.sql]
incremental [INFO] (Message) - set (eps_wid, eps_object_id) =(select e.row_wid, w.wbs_object_id
incremental [INFO] (Message) - *
incremental [INFO] (Message) - ERROR at line 2:
incremental [INFO] (Message) - ORA-01427: single-row subquery returns more than one row
incremental [INFO] (Progress) - Step 22/33 Part 2/10 - FAILED (147)

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