Error "ORA-30926: Unable To Get A Stable Set Of Rows In The Source Tables" When Attempting To Merge Project History In The Star Database
Last updated on MAY 16, 2017
Applies to:
Primavera P6 Reporting Database - Version R2 to R2 [Release R2]Information in this document applies to any platform.
***Checked for relevance 28-Aug-2014***
Symptoms
The following error is encountered in the Incremental.log, for procedure ETL_Run_Staruser_Merge_Project_History.sql:
<10.26.2010 23:32:59> incremental [INFO] (Progress) - Step 26/32 Part 1/1 - [10/26/2010 23:32:59] MergeProjectHistory -- Merge Project history in Star (ETL_Run_Staruser_Merge_Project_History.sql)
<10.26.2010 23:32:59> incremental [INFO] (Message) - Connecting to jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=host-name) (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=erd))) as STAGEUSER
<10.26.2010 23:32:59> incremental [INFO] (Message) - === Step 26, Part 1 ====================================================
<10.26.2010 23:32:59> incremental [INFO] (Message) - === Merge Project history in Star (ETL_Run_Staruser_Merge_Project_History.sql)
<10.26.2010 23:34:25> incremental [INFO] (Message) - PROJECT HISTORY MERGE :: CURRENT RUN DATE: 25-OCT-10
<10.26.2010 23:34:25> incremental [INFO] (Message) - PROJECT HISTORY MERGE :: INPUT INTERVAL: W
<10.26.2010 23:34:25> incremental [INFO] (Message) - GETDAYROW :: TIME INTERVAL: W [Week]
<10.26.2010 23:34:25> incremental [INFO] (Message) - GETDAYROW :: DATE: 25-OCT-10
<10.26.2010 23:34:25> incremental [INFO] (Message) - GETDAYROW :: DATE (YEAR): 2010
<10.26.2010 23:34:25> incremental [INFO] (Message) - GETDAYROW :: DATE (MONTH): 10
<10.26.2010 23:34:25> incremental [INFO] (Message) - GETDAYROW :: DATE (WEEK): 24-Oct
<10.26.2010 23:34:25> incremental [INFO] (Message) - GETDAYROW :: RETURN: 11254
<10.26.2010 23:34:25> incremental [INFO] (Message) - BEGIN
<10.26.2010 23:34:25> incremental [INFO] (Message) - *
<10.26.2010 23:34:25> incremental [INFO] (Message) - ERROR at line 1:
<10.26.2010 23:34:25> incremental [INFO] (Message) - ORA-30926: unable to get a stable set of rows in the source tables
<10.26.2010 23:34:25> incremental [INFO] (Message) - ORA-06512: at line 29
<10.26.2010 23:34:25> incremental [INFO] (Progress) - Step 26/32 Part 1/1 - FAILED (206) (0 hours, 1 minutes, 26 seconds, 706 milliseconds)
<10.26.2010 23:32:59> incremental [INFO] (Message) - Connecting to jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=host-name) (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=erd))) as STAGEUSER
<10.26.2010 23:32:59> incremental [INFO] (Message) - === Step 26, Part 1 ====================================================
<10.26.2010 23:32:59> incremental [INFO] (Message) - === Merge Project history in Star (ETL_Run_Staruser_Merge_Project_History.sql)
<10.26.2010 23:34:25> incremental [INFO] (Message) - PROJECT HISTORY MERGE :: CURRENT RUN DATE: 25-OCT-10
<10.26.2010 23:34:25> incremental [INFO] (Message) - PROJECT HISTORY MERGE :: INPUT INTERVAL: W
<10.26.2010 23:34:25> incremental [INFO] (Message) - GETDAYROW :: TIME INTERVAL: W [Week]
<10.26.2010 23:34:25> incremental [INFO] (Message) - GETDAYROW :: DATE: 25-OCT-10
<10.26.2010 23:34:25> incremental [INFO] (Message) - GETDAYROW :: DATE (YEAR): 2010
<10.26.2010 23:34:25> incremental [INFO] (Message) - GETDAYROW :: DATE (MONTH): 10
<10.26.2010 23:34:25> incremental [INFO] (Message) - GETDAYROW :: DATE (WEEK): 24-Oct
<10.26.2010 23:34:25> incremental [INFO] (Message) - GETDAYROW :: RETURN: 11254
<10.26.2010 23:34:25> incremental [INFO] (Message) - BEGIN
<10.26.2010 23:34:25> incremental [INFO] (Message) - *
<10.26.2010 23:34:25> incremental [INFO] (Message) - ERROR at line 1:
<10.26.2010 23:34:25> incremental [INFO] (Message) - ORA-30926: unable to get a stable set of rows in the source tables
<10.26.2010 23:34:25> incremental [INFO] (Message) - ORA-06512: at line 29
<10.26.2010 23:34:25> incremental [INFO] (Progress) - Step 26/32 Part 1/1 - FAILED (206) (0 hours, 1 minutes, 26 seconds, 706 milliseconds)
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