My Oracle Support Banner

P6 Check Project Integrity Utility: Description of Utility Including Detailed SQL Statements Executed (Doc ID 1083481.1)

Last updated on NOVEMBER 01, 2022

Applies to:

Primavera P6 Professional Project Management - Version 5.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 5.0 and later
Information in this document applies to any platform.


The purpose of this article is to provide:

Note:  The 21 Data Join Integrity Checks noted below can be added as a database maintenance plan to automate execute of the SQL statements through a database procedure.  Refer to the following knowledge base document for further instruction:  How To Include Project Integrity Checking In A Database Maintenance Plan (Doc ID 1315895.1)


Before reading this document:

If you have any question from the outcome of running this utility or reading this document, please log a Service Request (SR) through myOracle Support (MOS) for an engineer to assist.

Caution: This document may contain information, software, products or services which are not supported by Oracle Support Services and are being provided 'as is' without warranty. Please refer to the My Oracle Support Terms of Use.

Prior to running any script below, a backup of the database should be made. If you are unsure how to back up your database, do not proceed with the execution of any script. Contact your database administrator, your database vendor, or refer to one of the following solutions for assistance in backing up your database before executing any of the scripts:
Also, ensure that you are familiar with the process of restoring the backup copy of the database in case you need to do so.

For execution of any script below, the following is recommended:
For Oracle:
Log into the instance using SQLPlus or equivalent with the privileged user for the schema (for example: PRIVUSER)

For SQL Server 2005 or SQL Express:
Launch SQL Server Management Studio and login with SQL Authentication as PRIVUSER

For SQL Server 2000:
Launch Microsoft Query Analyzer and login with SQL Authentication as PRIVUSER


Open a dos command window (Start > Run > type 'cmd', hit OK) and log into the instance with OSQL with the following command:
osql -U sa -P <password> -S <server>\<instance> -d <database>
where <password> is the SA password, <server> is the name of the MSDE server, <instance> is the instance name if applicable, <database> is the name of the database


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
 What is the Check Project Integrity Utility?
 Data Join Integrity Check Details
 Other Recommended Checks
 Data Value Integrity Check Details

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