P6 Analytics ETL Fails Step 35 Part 1 Step 35/50 Part 1/1 - FAILED ORA-01427: single-row subquery returns more than one row and Publications are in Pending status java.lang.interruptedexception (Doc ID 2072358.1)

Last updated on NOVEMBER 09, 2015

Applies to:

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


On : version, ETL Process

When attempting to execute ETL, the following error occurs.

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] [********] [@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
staretl [INFO] (Progress) - Step 35/50 Part 1/1 - FAILED (1427) (0 hours, 0 minutes, 2 seconds, 278 milliseconds)

The issue can be reproduced at will with the following steps:
1. Run ETL
2. Observe reported error in the ETL log

The issue has the following business impact:
Due to this issue, the user cannot successfully run the ETL process.


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