Run Database Integrity Check

In the unlikely event data becomes corrupted in the database, use Database Integrity Check to identify and resolve instances of data inconsistencies. The process performs an audit of the database searching for issues that may prevent PCS from loading or performing basic functions. Its purpose is to clean up data issues that may cause problems for users. For example, database issues the auditing process detects and corrects include:

• Orphan records.

• Invalid hierarchy nodes.

• Outdated or incorrect derived fields. Refer to Work with Derived Fields for information about derived fields.

• Invalid field characters, hierarchy nodes, or folders outside hierarchy levels.

• Duplicate or missing right-of-ways (ROWs) and pipes.

• Blank hierarchy level names and empty or missing hierarchy folders.

• Missing base effective dates (facilities and pipelines).

• Invalid foreign keys in database tables. (A foreign key is a field in a database table that refers to a record in another database table.)

Complete the following steps to run Database Integrity Check:

• Click Tools > Database Integrity Check to open the Data Auditor window. Then click Run.

  The message Running displays during the database audit process.

  

  Data Auditor

  When the process completes, the results of the database audit display in the Data Auditor window. You can select and then copy text in the window to the Windows clipboard. The copied text can then be pasted in another software program such as Microsoft Excel or Word.

  

  Database Integrity Check Completed