The Database Constraint Report.exe reporting utility delivered with your current version of Smart P&ID is used to help you identify whether the Smart P&ID data stored in your database is compliant with the database constraints. You must run this utility before you begin upgrading Smart P&ID.
Tasks for correcting constraint violations
-
Make a complete backup of the data you are upgrading.
-
Generate a Database Constraint Exceptions Report. See Generate a Database Constraint Exceptions Report.
-
Clean up the database by removing orphan model items. See Clean Data Utility (DelOrpModItems.dll) in the Smart P&ID Utilities Guide.
-
Resolve constraint violations. See Using Constraint Utilities.
-
Generate a database constraint exceptions report again.
-
Run the appropriate constraint utilities again if any exceptions still exist.
-
Continue running the database constraint report and the constraint utilities until no exceptions are reported.
-
Make a complete backup of the now compliant data.
For additional information on resolving discrepancies listed in the database constraint report, contact your Customer Service representative.