Correcting Database Constraint Violations for SmartPlant P&ID - Intergraph Smart P&ID - Installation & Upgrade - Intergraph

SmartPlant P&ID Installation and Upgrade Guide

Intergraph Smart P&ID
Installation & Upgrade
2015 R1 (7.1)
7.1 (2014 R1)
7.2 (2014 R2)

The Database Constraint Report.exe reporting utility delivered with your current version of SmartPlant P&ID is used to help you identify whether the SmartPlant P&ID data stored in your database is compliant with the database constraints. You must run this utility before you begin upgrading SmartPlant P&ID.

Tasks for correcting constraint violations

  1. Make a complete backup of the data you are upgrading.

  2. Generate a Database Constraint Exceptions Report. For more information, see Generate a Database Constraint Exceptions Report.

  3. Clean up the database by removing orphan model items. For more information, see Clean Data Utility (DelOrpModItems.dll) (see ) in the SmartPlant P&ID Utilities Guide.

  4. Resolve constraint violations. For more information, see Using Constraint Utilities.

  5. Generate a database constraint exceptions report again.

  6. Run the appropriate constraint utilities again if any exceptions still exist.

  7. Continue running the database constraint report and the constraint utilities until no exceptions are reported.

  8. 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.