My Oracle Support Banner

Error: "ORA-30926: unable to get a stable set of rows in the source tables" When Executing PROC_AFTER_LOADING_PKG_CODES_PROJECT Or PROC_AFTER_LOADING_PKG_CODES_RESOURCE Or PROC_AFTER_LOADING_PKG_CODES_ACTIVITY From A P6 EPPM ETL (Doc ID 2368054.1)

Last updated on MARCH 30, 2019

Applies to:

Primavera Analytics Cloud Service - Version and later
Primavera Data Warehouse - Version and later
Primavera Analytics - Version and later
Information in this document applies to any platform.


When running an ETL for a P6 Data Source, the ETL fails with the following errors while processing data in the project code history dimension table:

[ERROR] After loading package codes, duration = ## seconds
  [DONE] 0 \-\ Load Codes Project
  [DONE] 1 /-/ Procedure - Load Codes Project - Code Step 2
  [DONE] 2 /-/ Procedure - Load Codes Project - Code Step 3
  [DONE] 3 /-/ Procedure - Load Codes Project - Code Step 4
  [ERROR] 1 \-\ Load Codes Project HD
  [ERROR] 4 /-/ Procedure - Load Codes Project HD - Load project codes HD
       ODI-1228: Task Procedure-Load Codes Project HD-Load project codes HD fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
       Caused By: java.sql.SQLException: ORA-30926: unable to get a stable set of rows in the source tables
          ORA-06512: at "STARUSER.SCD", line 956
          ORA-06512: at "STARUSER.SCD", line 970
          ORA-06512: at line 2

Note - The same issue can occur while processing data in the resource code or activity code history dimension tables.

The issue can be reproduced at will with the following steps:
1. Run the ETL process.
2. The process fails.
3. Note the above error in the log.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.