Clean Data Utility (DelOrpModItems.dll) - Intergraph Smart P&ID - Help - Intergraph

Intergraph Smart P&ID Utilities Help (2019)

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

The Clean Data Utility (DelOrpModItems.dll), also referred to as Delete Orphan Model Items, allows you to check for problems in your database records and, if required, to run clean-ups on those records.

  • You should run this utility prior to upgrading your drawings.

  • It is recommended that you make regular back-ups of your database so that you can restore data in the event of database problems.

Database Report — Generates a report, written to the DBCleanup.txt file in your Temp folder, that helps you decide whether a manual cleanup alternative exists before using the Entire Database command to delete the problems from the database.

The report indicates the following problems:

  • Broken database relationships, such as those between the Equipment and Plant Item tables, or between the Symbol and Symbol Representation tables.

  • Orphan model items of the item types listed below under Model Items.

Entire Database — Runs the report and removes orphaned records from the plant database. This option includes all the clean-ups performed by the Model Items, OPCs, and Gaps options. Run this option only after running the Database Report option and examining the report.

Model Items — Finds and deletes any model item in the database that does not have a corresponding entry in the T_Representation table. The utility works on an item type basis and repairs the following model item types: 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. Once the orphan model items for an item type are found, you can select any or all of the items and choose to delete them.

OPCs — Finds and repairs off-page connectors (OPCs) that have lost their associations with the OPC with which they were originally paired. If one OPC has lost the identity of its mated OPC, but the mated OPC still has the identity of the first OPC, then the OPC is considered repairable. To repair the OPC, the utility updates the identity information for the first OPC. However, if both the OPC and its mated OPC have lost the identities of each other, then the OPCs are considered non-repairable, and you are given the option to delete them.

Gaps — Repairs and updates gaps in the representation record with the proper item type. On rare occasions you will need to perform this operation if you have gapping problems in your drawings.

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 for a symbol that is not a gap. If you select Yes for any symbol other than a gap, your data set may get corrupted.