Unable to View Project Data in Primavera Analytics STAR Data Warehouse Schema W_PROJECT_D Table

(Doc ID 2128862.1)

Last updated on APRIL 28, 2016

Applies to:

Primavera Data Warehouse - Version R3.1 and later
Information in this document applies to any platform.


When logged into the STARUSER schema in Data Warehouse, there is no project data from W_PROJECT_DS or W_PROJECT_D tables after STAR ETL completed successfully.

P6 publication also completed successfully and PXRPTUSER schema contains all project data after publication.

Should be able to view Project data in Primavera Analytics STAR Data Warehouse schema after ETL Process completes successfully.

The issue can be reproduced at will with the following steps:
1. Connect to reporting database with STARUSER
2. Select count(*) from W_PROJECT_D;
3. Return : 0
4. Select count(*) from project@dslink01; 
5. Return : 100

The issue has the following business impact:
Due to this issue, users cannot view project data from P6 Analytics.


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