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
(Doc ID 1261505.1)
Last updated on NOVEMBER 15, 2019
Applies to:
Primavera Data Warehouse - Version R2 to R2 [Release R2] Information in this document applies to any platform.
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=<HOSTNAME>) (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<SERVICE NAME>))) as <USERNAME> <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)
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!