Generate a Database Constraint Exceptions Report - Intergraph Smart Engineering Manager - 11 - Installation & Upgrade - Hexagon

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.xlsx) 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.