My Oracle Support Banner

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

Last updated on FEBRUARY 20, 2019

Applies to:

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

Purpose

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)

Scope

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 following site for My Oracle Support Terms of Use: http://docs.oracle.com/cd/E25290_01/doc.60/e25224/preface.htm#MOSHP983

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

For MSDE:

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

Details

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
Purpose
Scope
Details
 What is the Check Project Integrity Utility?
 Data Join Integrity Check Details
 Data Value Integrity Check Details
References

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