P6 Check Project Integrity Utility: Description of Utility Including Detailed SQL Statements Executed
(Doc ID 1083481.1)
Last updated on MARCH 11, 2025
Applies to:
Primavera P6 Professional Project Management - Version 5.0 and laterPrimavera P6 Enterprise Project Portfolio Management - Version 5.0 and later
Information in this document applies to any platform.
Purpose
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.
Scope
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.
Please refer to the My Oracle Support Terms of Use.
BE SURE TO GET A BACKUP OF THE DATABASE prior to running any script below. Do not proceed with the execution of any script without being sure how to backup AND restore the database. If necessary contact the local database administrator or the database vendor, or refer to one of the following solutions for assistance in backing up the database before executing any of the scripts:
* For an Oracle Database: SRDC - Process for Exporting an Oracle Primavera P6 Project Management or Methodology Management Database (Doc ID 907089.1)
* For a Microsoft SQL Server/SQL Express database: How to Backup and Restore a SQL Server Database (Doc ID 905825.1)
To execute SQL commands/scripts:
* For Oracle: Using SQLPlus, SQL Developer, or similar tool, connect to the database instance as the privileged user (default privuser) as directed below.
* For SQL Server or SQL Express: Launch SQL Server Management Studio, Select SQL Authentication, and connect as the privileged user (default privuser) as directed below.
* For SQLite standalone P6 Professional databases: Download a SQLite database utility and connect to the database using the instructions in Obtaining SQLite Database Tools for Use with P6 Professional (Doc ID 1968205.1).
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 |
| Other Recommended Checks |
| References |