STARETL Step 35, Part 1 (update_project_wbs_ids.sql) Fails With Error: "ORA-01427: single-row subquery returns more than one row" (Doc ID 1632908.1)

Last updated on OCTOBER 11, 2015

Applies to:

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


The STARETL process fails with an error similar to:

staretl [INFO] (Message) - === Step 35, Part 1 ====================================================
staretl [INFO] (Message) - === Update Project WBS Object IDs (update_project_wbs_ids.sql)
staretl [DEBUG] (Message) - SQL Plus(4) : [-s] [STAR4547AF01/{}@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HOSTNAME)(PORT=PORTNUMBER))(CONNECT_DATA=(SERVICE_NAME=SERVICENAME)))] [@run$script.sql] [SCRIPTNAME:update_project_wbs_ids.sql]
staretl [INFO] (Message) - Exception: Error during update for table W_PROJECT_D and W_PROJECT_HD:
staretl [INFO] (Message) - ORA-01427: single-ro
staretl [INFO] (Message) - (100,W_PROJECT_D,W_PROJECT_D,n/a,n/a)
staretl [INFO] (Message) - declare
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-01427: single-row subquery returns more than one row
staretl [INFO] (Message) - ORA-06512: at line 36


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