How to Validate a P6 EPPM or P6 PPM Database Schema Using 8.1 and Later Releases
(Doc ID 1342977.1)
Last updated on SEPTEMBER 25, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 126.96.36.199 and later
Primavera P6 Professional Project Management - Version 188.8.131.52 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document