How to Validate a P6 EPPM or P6 PPM Database Schema Using 8.1 and Later Releases
Last updated on SEPTEMBER 13, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 184.108.40.206 and later
Primavera P6 Professional Project Management - Version 220.127.116.11 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).
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