How to Validate a P6 EPPM or P6 PPM Database Schema Using 8.1 and Later Releases
Last updated on MARCH 29, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 18.104.22.168 and later
Primavera P6 Professional Project Management - Version 22.214.171.124 and later
Information in this document applies to any platform.
This document provide instructions on how to use the schema validation tool to find missing, extra, and modified schema objects for a P6 database (either Professional or Enterprise) for releases 8.1 and later.
- For 6.2 - 8.0 releases, see: How to Validate a Project Management / Methodology Management Database Schema - Versions 6.2 through 8.0 (Doc ID 911561.1)
- For 6.1 and earlier releases, see: How to Validate a Project Management / Methodology Management Database Schema Prior to P6 Version 6.2 (Doc ID 909599.1)
Note: If you run the incorrect version of validate, you will get an error during the comparing database schema stage.
After applying Service Pack 1 to P6 v8.2 EPPM, the schema validation tool will fail with the following error when run against the database: "Error in Comparing database schema : NullPointerException (java.lang.nullpointerException)". To resolve this issue, please download the following patch for updated schema validation files: Patch 14640298. Reference Bug for schema validation issue: Bug 14548712
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