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.
-
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.
-
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.
-
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.
-
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.
-
Exit the Database Constraint Exception Report utility.
-
Open the report using Microsoft Excel and save a copy of the report to another location other than the Temp folder.
-
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.