Clean Data (Delete Orphan Model Items) - Intergraph Smart P&ID - Help - Intergraph

Intergraph Smart P&ID Utilities Help (2019)

PPMProduct
Intergraph Smart P&ID
PPMCategory_custom
Help
Version_SPPID_custom
9 (2019)
Version_SPEM_custom
10 (2019)

The clean data utility allows you to check your database for broken database relationships or orphan drawing items and to clean up the database by deleting orphan model items.

  • The Clean Data utility must be run from within the Smart P&ID modeler.

  • For easy access to this utility, you can create a custom menu in the Smart P&ID interface to run the Clean Data utility. For information about how to do this, see the topic Create a New Menu in the Smart P&ID User's Guide.

  • Log messages generated when orphaned records are deleted from the plant database are written to the DBCleanup.txt file in the folder assigned to the TEMP environment variable.

  • Log messages are placed in SPDelOrpModItems.log file in the folder assigned to the TEMP environment variable. The log file contains information about deleted items including the item type and SP_ID number.

Generate a Report

  1. Open a drawing in Smart P&ID.

  2. Click Tools > Custom Commands.

  3. On the Custom Command dialog box, browse to ..\SmartPlant\P&ID Workstation\bin and double-click DelOrpModItems.dll.

  4. On the Clean Data dialog box, click Database Report. The results are written to the DBCleanup.txt file in your Temp folder. This report helps you decide if a manual cleanup alternative exists before using the Entire Database command to automatically delete the problems from the database.

Perform Automatic Database Clean-Up

Before starting the clean-up, ensure that all other users have logged out of the plant.

  1. Click Entire Database to generate the report and automatically delete the problems from the plant database. This command results in the deletion of items where there are problems of referential integrity or non-unique records and includes all the clean-ups performed by the Model Items, OPCs, and Gaps options.

    Running this option will result in the deletion of many corrupted records in the database. To perform a less drastic set of clean-ups, skip this step and follow the rest of the steps in this procedure.

  2. Click Model Items.

  3. On the Delete Orphan Model Items dialog box, select each model item type from Item Type Names list to see if any orphan items exist in the database. The following model item types are checked: Vessel, Mechanical, Exchanger, Equipment: Other, Equipment Component, Instrument, Nozzle, Piping Component, Ducting Component, Pipe Run, Signal Run, Duct Run, OPC, Item Note, Area Break, Room, and Room Component.

  4. In the List view, select the model orphan items to delete, and click Delete.

    You can also click Delete All to select and delete all the items in the list view.

  5. Click Close to return to the Clean Data dialog box.

  6. On the Clean Data dialog box, click OPCs.

  7. On the Repair OPCs dialog box, chose either repairable or non-repairable from the OPC Type list. Repairable OPC pairs retain one link out of two between the mates. Non-repairable OPC pairs retain neither link.

  8. Choose the OPC pair you are interested in from the OPC list, and click Fix if it is a repairable pair or Delete if it is non-repairable.

  9. Click Close to return to the Clean Data dialog box.

  10. On the Clean Data dialog box, click Gaps to find and repair gaps that do not have the correct representation in the database.

    We do not recommend using the Gaps command as part of your database constraint cleanup. If you find it necessary to run Gaps, you must be careful not to select Yes to a symbol that is not a gap. If you select Yes to any symbol other than a gap, you may corrupt your data set.

  11. On the Clean Data dialog box, click Close to return to the design software.