P6 Check Project Integrity Utility: Description of Utility Including Detailed SQL Statements Executed
(Doc ID 1083481.1)
Last updated on OCTOBER 01, 2020
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:
- Detail of what the Check Project Integrity Utility is.
- Definition of the following two integrity checks performed: Data Join Integrity and Data Value Integrity.
- A list of each integrity check performed including each respective SQL select statement for the Data Join Integrity.
Before reading this document:
- It is recommended the user have good understanding of the Project Management application, however this document is informational and intended for any user.
- It is recommended that you always fix the check project integrity issues through the Project Management Client Application when possible.
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.
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:
For execution of any script below, the following is recommended:
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|