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

SmartPlant P&ID Installation and Upgrade Guide

Language
English
Product
Intergraph Smart P&ID
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
Smart Electrical Version
2015 R1 (7.1)
Smart Instrumentation Version
(none)
Smart P&ID Version
7.1 (2014 R1)
Smart Engineering Manager Version
7.2 (2014 R2)
Smart P&ID Web API Version
(none)

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.

  2. On the Database Constraint Exception Report Utility dialog box, click 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, click the Create Database Constraint Report button. This process may 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.xls) in the list box on the right side of the Database Constraint Exception Report Utility dialog box.

  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. We recommend running this utility again until no discrepancies are reported.