Generate a Database Constraint Exceptions Report - Intergraph Smart P&ID - 10 - Installation & Upgrade - Hexagon

Intergraph Smart P&ID Installation and Upgrade

Language
English
Product
Intergraph Smart P&ID
Search by Category
Installation & Upgrade
Smart P&ID Version
10

Use Smart P&ID or one of its manager applications to connect to the plant on which you want to run the Database Constraint Exception Report utility. If you use Smart P&ID to connect to the plant, be sure to close all drawings before proceeding. Microsoft Excel must be installed on any workstation from which you run the Database Constraint Exception Report utility.

  1. In the ..\SmartPlant\P&ID Workstation\bin folder, double-click the Database Constraint Report.exe file to open the Database Constraint Exception Report Utility dialog.

  2. Select Connect to Active Plant.

    The utility runs the report on the active plant that you are connected to at the time. To run a report on another plant, connect to that plant using Smart P&ID or one of its manager applications.

  3. After connecting to the database, select Create Database Constraint Report. This process can take several minutes, depending on the amount of data you have in your plant.

  4. When complete, the utility automatically saves a copy of the report in the temp directory under your user profile and displays the file name (plant name - ConstraintExceptions.xlsx) in the list on the right side of the Database Constraint Exception Report Utility dialog.

  5. Exit the Database Constraint Exception Report utility.

  6. Open the report using Microsoft Excel and save a copy of the report to another location other than the Temp folder.

  7. Review the completed report for discrepancies that must be resolved before you can upgrade to the new version of Smart P&ID. It is recommended to run this utility again until no discrepancies are reported.