Publishing P6 Data to Extended Schema
To publish P6 data to the extended schema:
- Get the p6services.jar file from the P6 build.
- Run the following command:
java -jar "Path to p6services.jar"
- Select Oracle or Microsoft SQL Server from the Database Type list.
- Enter the following database details: database username, publication user username, password, and database service.
- Select Next.
- In the P6 target database, run the following as ADMUSER:
- Ensure that last_update_date is null for all projects that are considered for publishing (PX_ENABLE_PUBLICATION_FLAG = 'Y'). If not, update them as follows:
update project set px_last_update_date = null WHERE PX_ENABLE_PUBLICATION_FLAG = 'Y'; commit;
- Ensure that setting_value has the maximum Project ID for setting_name= 'ProjectNonDemandStopKey'.
update SETTINGS set Setting_value = (select max(proj_id) from project) where Namespace = 'PxService.Project.Arbiter' and Setting_name = 'ProjectNonDemandStopKey'; commit;
- Ensure that last_update_date is null for all projects that are considered for publishing (PX_ENABLE_PUBLICATION_FLAG = 'Y'). If not, update them as follows:
- Ensure that the P6 target database, to which data is synced, is added as a source to the Primavera Data Warehouse.
- To enable Publication Services view on Webapp, run the following query in the STAR database as STARUSER:
UPDATE ETL_PARAMETER SET P_1='true' WHERE P_FEATURE='db.pmdb.cloud'; commit;
Related Topics
Syncing P6 EPPM Data from Cloud to On-Premises
Prerequisites to Sync P6 Cloud and On-Premises Data
Configuring the Sync Environment for P6 EPPM Cloud to On-Premises for Primavera Data Warehouse
Last Published Thursday, December 14, 2023