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 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.
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:
- 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.
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:
For execution of any script below, the following is recommended:
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:
- If using an Oracle Database: Document 907089.1
- If using a SQL Database: Document 905825.1
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 |
| Other Recommended Checks |
| Data Value Integrity Check Details |
| References |