My Oracle Support Banner

How to Validate a P6 EPPM or P6 PPM Database Schema Using 8.1 and Later Releases (Doc ID 1342977.1)

Last updated on DECEMBER 03, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version and later
Primavera P6 Professional Project Management - Version 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 Primavera P6, there is a Professional (standalone) version of the software and an Enterprise version of the software. Within each of these downloads, there is a "Database" folder containing the P6 database validation utility (validate.bat, You *MUST USE* the appropriate version of the utility to match your database. For example, if your database was upgraded to release 8.1 or later, with the use of the Professional software, then you must run the validate utility from the Professional release as well.

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 14640298Reference 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.