Error: "ORA-30926: Unable to Get a Stable Set of Rows in the Source Tables" When Executing PROC_AFTER_LOADING_PKG_CODES_PROJECT During the P6 EPPM ETL Process

(Doc ID 2368054.1)

Last updated on MARCH 07, 2018

Applies to:

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

Symptoms

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
  [ERROR] PROC_AFTER_LOADING_PKG_CODES
  [DONE] PROC_AFTER_LOADING_PKG_CODES_RESOURCE
  [DONE] PROC_AFTER_LOADING_PKG_CODES_ACTIVITY
  [DONE] PROC_AFTER_LOADING_PKG_CODES_MAPPINGS
  [ERROR] PROC_AFTER_LOADING_PKG_CODES_PROJECT
  [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

 

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.

Changes

 

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