db integrity

7/25/2019 Db Integrity

1/292

SmartPlant 3D

Database Integrity Guide

Version 2011 R1 (9.1)

May 2012

DSP3D-PE-200044J


2/292

Copyright

Copyright 2000-2012 Intergraph Corporation. All Rights Reserved.

Including software, file formats, and audiovisual displays; may be used pursuant to applicable software license agreement;contains confidential and proprietary information of Intergraph and/or third parties which is protected by copyright law, tradesecret law, and international treaty, and may not be provided or otherwise made available without proper authorization fromIntergraph Corporation.

Portions of this software are owned by Spatial Corp. 1986-2010. All Rights Reserved.

U.S. Government Restricted Rights Legend

Use, duplication, or disclosure by the government is subject to restrictions as set forth below. For civilian agencies: This wasdeveloped at private expense and is "restricted computer software" submitted with restricted rights in accordance withsubparagraphs (a) through (d) of the Commercial Computer Software - Restricted Rights clause at 52.227-19 of the Federal

Acquisition Regulations ("FAR") and its successors, and is unpublished and all rights are reserved under the copyright laws ofthe United States. For units of the Department of Defense ("DoD"): This is "commercial computer software" as defined at DFARS252.227-7014 and the rights of the Government are as specified at DFARS 227.7202-3.

Unpublished - rights reserved under the copyright laws of the United States.

Intergraph CorporationP.O. Box 240000Huntsville, AL 35813

Terms of Use

Use of this software product is subject to the End User License Agreement ("EULA") delivered with this software product unlessthe licensee has a valid signed license for this software product with Intergraph Corporation. If the licensee has a valid signed

license for this software product with Intergraph Corporation, the valid signed license shall take precedence and govern the useof this software product. Subject to the terms contained within the applicable license agreement, Intergraph Corporation giveslicensee permission to print a reasonable number of copies of the documentation as defined in the applicable license agreementand delivered with the software product for licensee's internal, non-commercial use. The documentation may not be printed forresale or redistribution.

Warranties and Liabilities

All warranties given by Intergraph Corporation about equipment or software are set forth in the EULA provided with the softwareor applicable license for the software product signed by Intergraph Corporation, and nothing stated in, or implied by, thisdocument or its contents shall be considered or deemed a modification or amendment of such warranties. Intergraph believesthe information in this publication is accurate as of its publication date.

The information and the software discussed in this document are subject to change without notice and are subject to applicabletechnical product descriptions. Intergraph Corporation is not responsible for any error that may appear in this document.

The software discussed in this document is furnished under a license and may be used or copied only in accordance with theterms of this license. No responsibility is assumed by Intergraph for the use or reliability of software on equipment that is notsupplied by Intergraph or its affiliated companies. THE USER OF THE SOFTWARE IS EXPECTED TO MAKE THE FINAL

EVALUATION AS TO THE USEFULNESS OF THE SOFTWARE IN HIS OWN ENVIRONMENT.Intergraph is not responsible for the accuracy of delivered data including, but not limited to, catalog, reference and symbol data.Users should verify for themselves that the data is accurate and suitable for their project work.

Trademarks

Intergraph, the Intergraph logo, PDS, SmartPlant, FrameWorks, I-Convert, I-Export, I-Sketch, SmartMarine, IntelliShip, INtools,ISOGEN, MARIAN, SmartSketch, SPOOLGEN, SupportManager, and SupportModeler are trademarks or registered trademarksof Intergraph Corporation or its subsidiaries in the United States and other countries. Microsoft and Windows are registeredtrademarks of Microsoft Corporation. ACIS is a registered trademark of SPATIAL TECHNOLOGY, INC. Infragistics, PresentationLayer Framework, ActiveTreeView Ctrl, ProtoViewCtl, ActiveThreed Ctrl, ActiveListBar Ctrl, ActiveSplitter, ActiveToolbarsCtrl, ActiveToolbars Plus Ctrl, and ProtoView are trademarks of Infragistics, Inc. Incorporates portions of 2D DCM, 3D DCM, andHLM by Siemens Product Lifecycle Management Software III (GB) Ltd. All rights reserved. Gigasoft is a registered trademark,and ProEssentials a trademark of Gigasoft, Inc. VideoSoft and VXFlexGrid are either registered trademarks or trademarks ofComponentOne LLC 1991-2009, All rights reserved. Oracle, JD Edwards, PeopleSoft, and Retek are registered trademarks ofOracle Corporation and/or its affiliates. Tribon is a trademark of AVEVA Group plc. Alma and act/cut are trademarks of the Almacompany. Other brands and product names are trademarks of their respective owners.


3/292

SmartPlant 3D Database Integrity Guide 3

ContentsPreface ........................................................................................................................................................ 13

SmartPlant 3D Documentation Set ....................................................................................................... 13

Documentation Comments ................................................................................................................... 15

What's New in Database Integrity ............................................................................................................ 15

Understanding Database Integrity ........................................................................................................... 17

Workflow for Addressing Database Integrity ......................................................................................... 19

Database Integrity Custom Commands ................................................................................................ 20Check Database Integrity ...................................................................................................................... 21

Database Integrity Command ............................................................................................................... 22

Check Database Integrity ............................................................................................................... 23

Schedule Check Data Consistency Task Using Batch Services .................................................... 23Clean a Database ................................................................................................................................. 24

Clean Database Dialog Box ........................................................................................................... 24Find Objects by Report ......................................................................................................................... 25Run Database Administration Processes (Matrix) ................................................................................ 26

CommonApp .............................................................................................................................................. 27

Control point does not have a parent .................................................................................................... 27 Hierarchy filter with missing Adapter ProgId ......................................................................................... 28Invalid number of related objects .......................................................................................................... 28LineFeature doesn't have minimum number of TurnPoints .................................................................. 29Missing object entry in related table ..................................................................................................... 29Name rule AE is not associated to a named item ................................................................................. 30

Note does not have a parent ................................................................................................................. 30

Only one as-built object allowed in a model ......................................................................................... 31PointFeature has no TurnPoint associated with it ................................................................................ 32Sketch3d is not associated to SketchByPointsAE ................................................................................ 32 Sketch3d Point is not associated to a TurnPoint .................................................................................. 33

SketchByPointsAE is not associated to Sketch3d ................................................................................ 33 SketchByPointsAE requires minimum two input points ........................................................................ 34TurnPoint can have one or two LineFeatures associated with it .......................................................... 34TurnPoint is not associated to a Point .................................................................................................. 35WBS Item does not have a parent ........................................................................................................ 35 WBS Project does not have a parent .................................................................................................... 36

Common Route .......................................................................................................................................... 39

Added port with no object connected .................................................................................................... 39

Attach connection without 2 ports ......................................................................................................... 39Branch feature not at end of leg............................................................................................................ 40Branch Feature with no corresponding Along Leg Feature .................................................................. 40 Connection associated with only one port ............................................................................................ 41Connection has relation to Specification ............................................................................................... 41 Connection Item missing relation to catalog part .................................................................................. 42


4/292

Contents

4 SmartPlant 3D Database Integrity Guide

Connection Item missing relation to the object ..................................................................................... 42Connection Items not associated to the owner part.............................................................................. 43Connection not associated with a port .................................................................................................. 44Connection not associated with a run ................................................................................................... 44Connection not connected to correct parent ......................................................................................... 45

Connection not having valid connection size ........................................................................................ 45

Connection Permission Group/Approval Status not same as connected parts or owner ..................... 46

Dormant Part associated to the Feature ............................................................................................... 46End/Branch/Turn feature not a Terminating Feature of the leg ............................................................ 47 Feature not associated with a Leg ........................................................................................................ 47 Feature not associated with a run ......................................................................................................... 48Feature with branch parent function did not generate part occurrence ................................................ 48Feature with component Function did not generate component occurrence ....................................... 49Feature with end leg function did not generate component occurrence ............................................... 49

Feature with user specified parts did not generate part occurrence ..................................................... 50Feature with zero outer diameter .......................................................................................................... 51

Feature without UserSpecifiedPart Relation ......................................................................................... 51

Inline feature & Branch Feature belong to same leg ............................................................................ 52Intermediate End Feature and Connected Intermediate End Feature generating part ........................ 52

Invalid Zero Length Straight Feature .................................................................................................... 53Leg with features belonging to multiple runs ........................................................................................ 54

Leg with no associated features ........................................................................................................... 54Need to remove the RelConnectionAndPartOcc between the cableocc and theDistribconn ............................................................................................................................................ 55No connection items generated by the connection ............................................................................... 55Objects with invalid cross sectional parameters ................................................................................... 56

Parent Connection is generating Non-BoltSet Connection Items ......................................................... 56

Part and Feature data is not matching .................................................................................................. 57Part not associated with a feature......................................................................................................... 57Part not associated with a run ............................................................................................................... 58PipeSurfaceMount Feature without Attach Connection ........................................................................ 58Ports with no association to Parts ......................................................................................................... 59Route part missing relation with ports ................................................................................................... 59Route part occurrence with missing relation to Catalog part ................................................................ 60

Route part occurrence with missing relation to Material Control Data .................................................. 60Route part occurrence with wrong made relation name ....................................................................... 61Route part occurrence with wrong permission group or approval status.............................................. 61

Run with no feature that has an entry in the Spatial Index table (Range) ............................................ 62Run without specification ...................................................................................................................... 63Run without system parent ................................................................................................................... 63Straight feature generating a mating part ............................................................................................. 64 Straight feature not generating stock part occurrence .......................................................................... 64SurfaceMount Feature not connected to Inline Feature ....................................................................... 65Tap Feature with no association to Tapped Feature ............................................................................ 65Turn Feature Angle is very small .......................................................................................................... 66Turn feature missing primary leg association ....................................................................................... 66

Turn Feature not associated to two legs ............................................................................................... 67

Common Space ......................................................................................................................................... 69

Active Entity has no Space Geometry associated with it ...................................................................... 69Hierarchical Loop Detected ................................................................................................................... 69Space Association Active Entity has no Graphic Object....................................................................... 70Space Association Active Entity has no Space Entity associated to the Graphic Object ..................... 70


5/292

Contents


Space Boolean Operator does not have a Space Geometry ............................................................... 71Space Boolean Operator is not connected to Space By Boolean Active Entity ................................... 72Space By Boolean Active Entity is not connected to Space Boolean Operator ................................... 72Space By Path Active Entity does not have Path ................................................................................. 73Space By Path Active Entity has no CrossSection ............................................................................... 73

Space By Plane and Offset Active Entity does not have the Fence input Points ................................. 74

Space By Plane and Offset Active Entity does not have the Reference Plane .................................... 74

Space By Points Active Entity has no input Points ............................................................................... 75 Space By Primitive Active Entity has no Geometry .............................................................................. 75Space Entity does not have a Catalog Part .......................................................................................... 76Space Entity does not have Range ...................................................................................................... 77Space Entity does not have Space Geometry ...................................................................................... 77Space Geometry has no Active Entity associated with it ...................................................................... 78Space Geometry is not connected to any Space Entity........................................................................ 78

Space Object does not have Local coordinate system ......................................................................... 79Space object has two parents ............................................................................................................... 79

SpaceChild does not have a Parent ..................................................................................................... 80

SpatialOrientation is not connected to a Space Object or Sketch3d object ......................................... 80

Common Structure .................................................................................................................................... 83

Bad StructObject Permission Group ..................................................................................................... 83Bad StructPortSelector permission group ............................................................................................. 83Connection without relation to route part .............................................................................................. 84

Cutout not in spatial index ..................................................................................................................... 85

Invalid SketchReference Relationship .................................................................................................. 85Missing Attributes in StructLayer .......................................................................................................... 86Missing relation between Structcutoutcontour object and openingtype object ..................................... 86Not Accessible Port Selector ................................................................................................................ 87Object with inappropriate Range ........................................................................................................... 87Opening without any OpeningType relation .......................................................................................... 88Orphaned Basic Geometric Construction ............................................................................................. 88Orphaned CommonStruct Internal Object ............................................................................................ 89

Orphaned Custom Component coming from Sketch2D ....................................................................... 89

Orphaned Geometric Construction Macro ............................................................................................ 90Orphaned Geometric Construction Set ................................................................................................. 90

Orphaned Sketch2D Output .................................................................................................................. 91Orphaned Sketched Cutout Contour not related to CutoutAE .............................................................. 91Orphaned Struct Coordinate System .................................................................................................... 92Orphaned StructLayer ........................................................................................................................... 92Orphaned Structural connection is not associated to any port (IJPort) ................................................ 93Sketch2D Custom Component is not related to a Wall, Opening, or Slab boundary ........................... 93Sketched Cutout Contour is not associated to any symbol .................................................................. 94Sketched Cutout Contour is not related to SketchWireBodyOutput geometry ..................................... 94StandAlone Struct Generation Active Entity has no parent input ......................................................... 95

StandAlone Struct Operation Active Entity has no Operand input ....................................................... 95

StandAlone Struct Port not associated to a StructPortSelector AE ...................................................... 96StandAlone StructGenericEntity not associated to a Struct Generic Geometry ................................... 96

StandAlone StructPortSelector not associated to a StructGenericEntity .............................................. 97Struct Coordinate System is not associated to a FCBO ....................................................................... 97

Core ............................................................................................................................................................. 99

Error on symbol internal object ............................................................................................................. 99


6/292

Contents


Error on symbol relation ...................................................................................................................... 100Error on the To Do list data ................................................................................................................. 100 Generic SmartPlant Error .................................................................................................................... 101Graphic object is an orphan ................................................................................................................ 101Object has an unexpected relation ..................................................................................................... 102

Object has invalid geometry ................................................................................................................ 103

Object is not accessible ...................................................................................................................... 103

Object naming error ............................................................................................................................ 104SmartPlant Error : Cardinality violation in design basis relation ......................................................... 104SmartPlant Error : Dead object or correlation wrong .......................................................................... 105SmartPlant Error : Multiple objects with the same name .................................................................... 106SmartPlant Error : Multiple view files with same name ....................................................................... 106SmartPlant Error: Multiple objects with the same name ..................................................................... 107The object does not exist but another object has a relation to it ........................................................ 108

The proxy does not have a parent; therefore, it cannot find its source............................................... 108The proxy exists but is not connected to any other object .................................................................. 109

Undefined/unknown error on the object .............................................................................................. 109

Drawings and Reports ............................................................................................................................ 111

Blob in the DocumentData object table is not valid ............................................................................ 111

Child Property object's approval status or permission group does not match with theparent Property Object ........................................................................................................................ 111Doc Output Mgr has duplicate data documents .................................................................................. 112

Document Output Manager object has duplicate generated document relations ............................... 113

Document Output Manager object's approval status or permission group does notmatch with the owning SnapIn or Sheet object................................................................................... 113DocumentData object's approval status or permission group does not match withDocument Output Manager ................................................................................................................. 114Drawing Issue object's approval status or permission group does not match withProperty Object Child .......................................................................................................................... 115Drawing Key Plan View object's approval status or permission group does not matchwith Drawing View object .................................................................................................................... 115

Drawing object has duplicate relations ............................................................................................... 116

Drawing Revision object's approval status or permission group does not match withProperty Object Child .......................................................................................................................... 116

Drawing View Info object's approval status or permission group does not match withDrawing View object ........................................................................................................................... 117Drawing View object's approval status or permission group does not match withDrawing Sheet object .......................................................................................................................... 118Drawing View on Drawing Component Template has Overrides ....................................................... 118Drawing Volume object's approval status or permission group does not match withDrawing View object ........................................................................................................................... 119Element Broker object's approval status or permission group does not match withDrawing View object ........................................................................................................................... 120

Missing Filter on Drawings by QueryManager with children ............................................................... 121

Property object's approval status or permission group does not match with DrawingSheet or SnapIn .................................................................................................................................. 121

PropertyChild entity has no parent PropertyObject ............................................................................ 122PropertyObject has no associated SnapIn or Sheet ........................................................................... 122Report object's approval status or permission group does not match with ViewGenerator object ................................................................................................................................. 123Report Template object's approval status or permission group does not match withDrawing View object ........................................................................................................................... 124


7/292

Contents


Sheet entity has no associated parent SnapIn ................................................................................... 124SnapIn entity has no associated parent .............................................................................................. 125SnapIn entity has no associated PropertyObject ................................................................................ 125Snapshot view is not associated to a volume ..................................................................................... 126Template Manager object's approval status or permission group does not match withParent Drawing Type or Sheet ............................................................................................................ 127

Template Mgr object has no parent Snapin or Sheet ......................................................................... 127

Template Sheet is corrupted ............................................................................................................... 128

Equipment and Furnishings ................................................................................................................... 131

Assembly Constraint is not associated to a part occurrence .............................................................. 131Cable Nozzle does not have proper orientation values ...................................................................... 131

Conduit Nozzle does not have proper orientation values ................................................................... 132Design Equipment has Invalid Range ................................................................................................. 133Design Solid unspecified error 3 ......................................................................................................... 133Equipment does not have a system parent ........................................................................................ 134Equipment has DBL_UNDEFINED values persisted for CG value .................................................... 134Equipment is not associated to a part ................................................................................................. 135 Equipment or Equipment component does not have a coordinate system ........................................ 136Equipment ports do not have a parent ................................................................................................ 137

Error code 58 - unspecified error description ...................................................................................... 137Invalid WCGProperties for the object that has valid weight and CG .................................................. 138Nozzle is not associated to an EFCorrelation object .......................................................................... 138

Orphaned Nozzle ................................................................................................................................ 139

Permission Group of the object is different from the Parent Object ................................................... 139Permission Group of the shape is different from the corresponding Smart Equipment ..................... 140Shape does not have an equipment parent ........................................................................................ 141Smart Equipment has a missing relation with symbol sub system ..................................................... 141Smart Item associated to Equipment has different permission group ................................................ 142

General Errors ......................................................................................................................................... 143

Object does not have a parent ............................................................................................................ 143

Geometry and Topology ......................................................................................................................... 145

Cannot enclose void to construct a solid ............................................................................................ 145Cannot stitch and orient the given surface bodies .............................................................................. 145Model body has no topology ............................................................................................................... 146Model body is self-intersecting ............................................................................................................ 146Model geometries do not intersect ...................................................................................................... 147

Model geometries do not overlap........................................................................................................ 147Unexpected failure in GeomOperations module ................................................................................. 148

Grids ......................................................................................................................................................... 149

Coordinate System contains some Planes/Cylinders at same position.............................................. 149Object does not have the requested data ........................................................................................... 150

Object does not have the requested relation ...................................................................................... 152Object has invalid geometry ................................................................................................................ 154

Hangers and Supports ............................................................................................................................ 155

Active entity with no Leg ..................................................................................................................... 155


8/292

Contents


Active entity with no outputs ............................................................................................................... 155Active entity with no supported entities ............................................................................................... 156Component without WBSProjectChild and WBSItemChild ................................................................. 156Connection without support ................................................................................................................ 157Corrupted Hanger Connections .......................................................................................................... 157

Duplicate relations exist in the database ............................................................................................ 158

Error code 63 - unspecified error description ...................................................................................... 159

Extra/Orphaned group monitors exist ................................................................................................. 159Hierarchical Loop Detected ................................................................................................................. 160Joint exists without a support .............................................................................................................. 160 Object has Different Permission Group than the Parent Object ......................................................... 161Occurrence Assembly without part ..................................................................................................... 161Orphaned Hanger Port(s) ................................................................................................................... 162Support as an assembly child, but not being a parent ........................................................................ 162

Support Component with no Support .................................................................................................. 163Support exists without active entity ..................................................................................................... 163

Support exists without joint ................................................................................................................. 164

Support has no components ............................................................................................................... 164Support not associated to a definition ................................................................................................. 165

Support without CoordinateSystem .................................................................................................... 165Support without Name ........................................................................................................................ 166

SupportPort without Support ............................................................................................................... 166SupportPort without SupportComponent ............................................................................................ 167Wrong ComponentToSupportedPort Relation .................................................................................... 167

Interference Checking ............................................................................................................................. 169

Bad part Interference has no part ....................................................................................................... 169Interference has only one part and not in Todo List ........................................................................... 170

Piping ........................................................................................................................................................ 171

Feature has an Offline relation without a HasTapFeature relation................................................... 171

Non-spool object with SpoolHierarchy relation to ConfigProjectRoot................................................. 171

Project Management ............................................................................................................................... 173

A 3D Reference object has an incorrect parent in the hierarchy ........................................................ 173A 3D Reference object has more than one parent in the hierarchy .................................................... 174A 3D Reference object has no parent in the hierarchy ....................................................................... 175Access Control Rule is not associated to Permission Group ............................................................. 176Database is not associated to any plant ............................................................................................. 176

Detected unassociated Location object .............................................................................................. 177Folder is not associated to the parent Folder ..................................................................................... 177Invalid relationship between the Workspace Explorer root and the plant in the sitedatabase ............................................................................................................................................. 178Model database has more than one site occurrence for catalog ........................................................ 178

Model has multiple ProxyOwners (site) for projectdb ......................................................................... 179Multiple ConfigProjectRoot objects exists in the model ...................................................................... 180

Permission Group contains duplicate Access Control Rules .............................................................. 180Permission Group has multiple relations with Folder Parent .............................................................. 181Permission Group is not associated to a Folder ................................................................................. 181Permission Group is not associated to a Location .............................................................................. 182Plant is not associated to Plants root .................................................................................................. 182


9/292

Contents


The database contains more than one occurrence of the Reference Root class ............................... 183

Reference Data ........................................................................................................................................ 185

Object does not have the requested relation ...................................................................................... 185Object does not have the requested simple relation........................................................................... 188

Object has an unexpected relation ..................................................................................................... 190

Route Cable .............................................................................................................................................. 193

Cable feature not associated with cable leg ....................................................................................... 193

Cable feature not associated with cable run ....................................................................................... 193 Cable has no cable part in the catalog ............................................................................................... 194Cable is not connected to any equipment ........................................................................................... 194Cable Leg not associated with Cable Feature .................................................................................... 195Cable occurrence not associated with cable feature .......................................................................... 196Cable occurrence not associated with cable run ................................................................................ 196Cable run not associated with any cable feature ................................................................................ 197Cable run not associated with cable occurrence ................................................................................ 197EntryExit not connected to leg ............................................................................................................ 198

Leg without two terminus features ...................................................................................................... 199Marker not connected to feature ......................................................................................................... 199

Marker Not connected to leg ............................................................................................................... 200

Segment not associated to any boundary .......................................................................................... 200Segment not connected to any cableway Feature .............................................................................. 201Segment not connected to any leg ..................................................................................................... 201

Structural Analysis .................................................................................................................................. 203

Analysis Model has more than one boundary condition folder ........................................................... 203

Analysis Model has more than one load combination folder .............................................................. 204

Analysis Model has more than one member folder ............................................................................ 204

Analysis Model is missing its association to the model ...................................................................... 205

Analysis Model is missing its boundary condition folder ..................................................................... 206

Analysis Model is missing its load combination folder ........................................................................ 206

Analysis Model is missing its member folder ...................................................................................... 207Analysis WSE folder has no parent .................................................................................................... 207Boundary condition is not associated to a member part ..................................................................... 208Duplicate naming rule assigned to a boundary condition ................................................................... 209Duplicate naming rule assigned to a load ........................................................................................... 209 Duplicate naming rule assigned to a load case .................................................................................. 210Duplicate naming rule assigned to a load combination ...................................................................... 210

Duplicate naming rule assigned to an analysis model ........................................................................ 211Load associated to more than one load case ..................................................................................... 211Load associated to more than one member ....................................................................................... 212Load case does not have a parent load case folder ........................................................................... 213Load combination has a factor to a load case that does not exist ...................................................... 213

Load combination has no assigned load cases .................................................................................. 214Load has a force or moment magnitude of 0 ...................................................................................... 214

Load not assigned to a member part .................................................................................................. 215 Load not associated to a load case .................................................................................................... 215Load relative position is not between 0 and 1 ..................................................................................... 216Multiple boundary conditions are assigned to the same end of a member part ................................. 216There is more than one analysis load case folder .............................................................................. 217


10/292

Contents


There is more than one unassigned members folder ......................................................................... 217

Structure ................................................................................................................................................... 219

Assembly connection does not have a cutting plane .......................................................................... 219Assembly connection does not have an associated feature ............................................................... 219

Assembly connection feature is incorrectly related to member part ................................................... 220

Assembly connection is missing a relation to the supported members end port ................................ 221Assembly connection is missing one or more of its custom plate parts ............................................. 221Assembly connection is missing one or more related axis ports ........................................................ 222Assembly connection missing relation to supported member part end port ....................................... 223Assembly connection missing relation to supporting member part .................................................... 224Assembly connection missing relation to supporting member part end port ...................................... 224

Axis joint copy property flag is not zero or the point on value is not -1.0............................................ 225Door or Window is missing its mating constraint ................................................................................ 226Door or Window is missing its opening ............................................................................................... 226End frame connection missing a relation to the supporting member joint .......................................... 227Equipment foundation component does not have a relation to its parent........................................... 228Equipment foundation exists without Equipment ................................................................................ 228Equipment foundation material is missing .......................................................................................... 229Footing material is missing ................................................................................................................. 230

Footing without sufficient supporting members .................................................................................. 230Frame connection associated to more than one member part end port ............................................. 231Frame connection found that is unrelated to a member system ......................................................... 231

Frame connection is missing its reference collection ......................................................................... 232

Frame connection missing its reference collection relation to the member system ........................... 233Frame connection without member part end port relation .................................................................. 233Handrail exists without its geometry ................................................................................................... 234Handrail is not associated to HandrailAE ........................................................................................... 235HandrailAE is not associated to Handrail ........................................................................................... 235Joint found that is unrelated to a member system .............................................................................. 236Member end port associated to more than one Frame Connection ................................................... 236Member part axis end port found with invalid properties .................................................................... 237

Member part cutLength is zero ........................................................................................................... 238

Member part does not have an attached cross section occurrence ................................................... 238Member part generator missing .......................................................................................................... 239

Member part has more than one attached cross section definition .................................................... 240Member part has more than one attached cross section occurrence................................................. 241Member part has more than one material definition ........................................................................... 241Member part has no attached catalog cross section definition ........................................................... 242Member part has no attached material definition................................................................................ 242Member part is missing a start or end port ......................................................................................... 243Member part is missing its end ports .................................................................................................. 244Member part not attached to member part generator ......................................................................... 244Member part solid geometry missing .................................................................................................. 245

Member system axis end port (at end) is related to more than one axis joint .................................... 246

Member system axis end port (at start) is related to more than one axis joint ................................... 246Member system can be point on to only one member system ........................................................... 247

Member system end port found with invalid properties ...................................................................... 248Member system exists without any member parts .............................................................................. 248Member system is missing a start or end port .................................................................................... 249Member system is missing its attached wirebody ............................................................................... 249Member system is missing its end ports ............................................................................................. 250Member system missing one or more frame connections .................................................................. 251


11/292

Contents


Member system Type property cannot be 0 ....................................................................................... 252Member system TypeCategory property cannot be 0......................................................................... 252More than one assembly connection is attached to the end port of a member part ........................... 253No frame connection found on end of member system ...................................................................... 254Object not in the same permission group as its parent....................................................................... 255

One or more outputs of a Designed Member exist in a different Permission Group .......................... 255

Opening without any OpeningType relation ........................................................................................ 256

Orphaned Cross section symbol occurrences having no relationships to any objects ....................... 256Orphaned structure member part along port ...................................................................................... 257Orphaned structure member part end port ......................................................................................... 258Orphaned structure member system end port .................................................................................... 258Port face selector is missing its root contour ...................................................................................... 259Port face selector is missing its source object .................................................................................... 260Port face selector root contour is not unique ...................................................................................... 260

Port face selector source object is not unique .................................................................................... 261Reference collection for a FrameConnection uses unexpected relation ............................................ 261

Reference Collection for an unsupported Frame Connection contains more than oneelement ............................................................................................................................................... 262Slab entity catalog type reference is not unique ................................................................................. 263

Slab entity composition reference is not unique ................................................................................. 263Slab entity is missing its catalog type reference ................................................................................. 264

Slab entity is missing its composition ................................................................................................. 264Slab entity is missing its composition reference ................................................................................. 265Slab layer catalog type reference is not unique .................................................................................. 265Slab layer composition is not unique .................................................................................................. 266Slab layer is missing its catalog type reference .................................................................................. 266

Slab layer is missing its composition .................................................................................................. 267

Slab with duplicate boundary index .................................................................................................... 267Slab Without Any Slab Assembly Connection .................................................................................... 268Slab Without Supporting Object .......................................................................................................... 268Stair or Ladder has more than one related bottom plane ................................................................... 269Stair or Ladder has more than one related reference plane or edge .................................................. 270Stair or Ladder has more than one related top plane or edge ............................................................ 271Stair or Ladder is missing its bottom supporting plane ....................................................................... 271

Stair or Ladder is missing its top supporting plane or edge ................................................................ 272Stair or Ladder is not associated to its AE .......................................................................................... 273StairAE is not associated to Stair or Ladder ....................................................................................... 273

Structure SmartOcc related objects with missing flavor relation ........................................................ 274Surface frame connection is missing its reference collection relation to the surface ......................... 274Wrong reference collection relation to member for end port @end .................................................... 275Wrong reference collection relation to member for end port @start ................................................... 276

Systems and Specifications ................................................................................................................... 277

Missing relationship for Correlated object ........................................................................................... 277

Object does not have a parent ............................................................................................................ 278

Object has more than one parent ....................................................................................................... 279Object is the parent of itself ................................................................................................................ 280

System does not have a parent .......................................................................................................... 281System has more than one parent ...................................................................................................... 282System has unneeded NamingParent relation ................................................................................... 283 System is the parent of itself ............................................................................................................... 283


12/292

Contents


Index ......................................................................................................................................................... 287


13/292


This document is a database integrity guide for Intergraph SmartPlant 3D. The purpose of thisdocument is to describe the database integrity messages for the different tasks in the software.

SmartPlant 3D Documentation SetSmartPlant 3D documentation is available as Adobe PDF files. The content is the same asonline Help. To access these PDF documents, click Help > Printable Guidesin the software.

The documentation set is divided into four categories:

Administrative guides contain information about installing, configuring, customizing, andtroubleshooting SmartPlant 3D.

User's guides provide command reference and how-to information for working in eachSmartPlant 3D task.

Reference data guides define the reference data workbooks. Not all tasks have referencedata.

ISOGEN guides

Administrative Guides

SmartPlant 3D Installation Guide- Provides instructions on installing and configuring thesoftware.

Project Management User's Guide - Provides instructions for setting up the databases, creatingpermission groups, backing up and restoring project data, assigning access permissions to themodel, defining and managing locations for Global Workshare, and version migration.

SmartPlant 3D Global Workshare Guide- Provides instructions for setting up the software andthe databases to work in a workshare environment.

SmartPlant 3D Interference Checking Guide- Provides information on installing, configuring,and using the interference detection service.

SmartPlant 3D Integration Reference Guide- Provides information about installing, configuring,and using SmartPlant 3D in an integrated environment.

SmartPlant 3D Interpreting Human Piping Specifications- Provides information about how tointerpret human piping specifications so that you can create the corresponding pipingspecification in the software.

SmartPlant 3D Export to PDMS- Provides information about how to export model data fromSmartPlant 3D to PDMS. Specific guidelines relating to best practices and known limitations ofthe export functionality are also included.

SmartPlant 3D Point Cloud Reference- Provides information for referencing point cloud filesprovided by point cloud vendors in SmartPlant 3D.

SmartPlant 3D Troubleshooting Guide - Provides information on how to resolve errors that youmay encounter in the software by documenting troubleshooting tips, error messages, and To DoListmessages.

SmartPlant 3D Plant Design System (PDS) Guide- Provides all information needed to use PDSwith SmartPlant 3D. Topics include referencing active PDS projects in SmartPlant 3D, exportingPDS data and importing that data into SmartPlant 3D, and converting PDS reference data toSmartPlant 3D reference data.

Preface


14/292

Preface


SmartPlant 3D/SmartMarine 3D Programmer's Guide- Provides information about customcommands, naming rules, and symbol programming. This document is delivered, if you installthe Programming Resources, to the [Product Folder]\3D\Programming\Help folder.

User's Guides

Catalog User's Guide- Provides information about viewing, editing, and creating reference dataand select lists (codelists).

Common User's Guide- Provides information about defining workspaces, manipulating views,and running reports.

Electrical User's Guide- Provides information about routing electrical cable, cableway, cabletray, and conduit.

Equipment and Furnishings User's Guide- Provides information about placing equipment.

Grids User's Guide- Provides instructions for creating coordinate systems, elevation gridplanes, vertical grid planes, radial cylinders, radial planes, grid arcs, and grid lines.

Hangers and Supports User's Guide- Provides instructions on placing piping, duct, andcableway supports in the model.

HVAC User's Guide- Provides instructions for routing HVAC duct.

Orthographic Drawings User's Guide- Provides information about creating and managingorthographic drawings.

Piping Isometric Drawings User's Guide- Provides information about creating and managingpiping isometric drawings.

Piping User's Guide- Provides instructions for routing pipe and placing valves, taps, and pipejoints.

Reports User's Guide- Provides information about creating and managing spreadsheet reports.

Space Management User's Guide- Provides instructions for placing space objects such asareas, zones, interference volumes, and drawing volumes in the model.

Structural Analysis User's Guide- Provides instructions for defining loads, load cases, loadcombinations, and the importing and exporting of analytical data.

Structure User's Guide- Provides instructions for placing structural members such as: beams,columns, slabs, openings, stairs, ladders, equipment foundations, and handrails.

Systems and Specifications User's Guide- Provides instructions for creating systems andselecting which specifications are available for each system type.

Reference Data Guides

SmartPlant 3D 2D Symbols User's Guide- Provides command reference information andprocedural instructions for creating 2D symbols used to represent collars, clips, profiles,brackets, and other items.

SmartPlant 3D 2D Symbols Reference Data Guide- Provides information about thetwo-dimensional symbols used in all tasks.

Drawings and Reports Reference Data Guide- Provides information about reports referencedata.

Electrical Reference Data Guide- Provides information about electrical cable, cableway, cabletray, and conduit reference data.

Electrical 3D Symbols Reference- Provides information about the cable tray and conduit 3Dsymbols that are available.

Equipment and Furnishings Reference Data Guide- Provides information about equipmentreference data.


15/292

Preface


Equipment 3D Symbols Reference- Provides information about the equipment, equipmentcomponent, design shapes, and design aides 3D symbols that are available.

Hangers and Supports Reference Data Guide- Provides information about hangers andsupports reference data.

Hangers and Supports 3D Symbols Reference- Provides information about the hanger and

support 3D symbols that are available.Hangers and Supports SmartPart Symbols Reference- Provides information about the hangerand support SmartPart symbols that are available.

HVAC Reference Data Guide- Provides information about HVAC reference data.

HVAC 3D Symbols Reference- Provides information about the HVAC 3D symbols that areavailable.

SmartPlant 3D Reference Data Guide- Provides instructions about the Bulkload utility,codelists, and the reference data common to several disciplines.

Piping Reference Data Guide- Provides information about piping reference data including pipingspecifications, piping specification rules, piping parts, and piping symbols.

Piping 3D Symbols Reference- Provides information about the piping 3D symbols that areavailable.

Space Management Reference Data Guide- Provides information about space managementreference data.

Structure Reference Data Guide- Provides information about structural reference data.

Structure 3D Symbols Reference- Provides information about the stair, ladder, footings, andequipment foundation 3D symbols that are available.

ISOGEN Guides

Symbol Keys Reference Guide- Provides information about the symbol keys for isometricdrawings. This guide is from Alias, the makers of ISOGEN.

Documentation CommentsWe welcome comments or suggestions about this documentation. You can send us an email at:[email protected].

Documentation updates for supported software versions are available from eCustomerhttps://crmweb.intergraph.com.

What's New in Database IntegrityThe following items have changed in or been added to the Database Integrity Guide:

Version 2011 R1 (9.1)

Common Structure

Bad StructObject Permission Group(on page83)

Cutout not in spatial index(on page85) Invalid SketchReference Relationship(on page85)

Missing Attributes in StructLayer(on page86)

Not Accessible Port Selector(on page87)

Object with inappropriate Range(on page87)

Orphaned Basic Geometric Construction(on page88)

Orphaned CommonStruct Internal Object(on page89)
https://crmweb.intergraph.com/https://crmweb.intergraph.com/https://crmweb.intergraph.com/


16/292

Preface


Orphaned Custom Component coming from Sketch2D(on page89)

Orphaned Geometric Construction Macro(on page90)

Orphaned Geometric Construction Set(on page90)

Orphaned Sketch2D Output(on page91)

Orphaned Struct Coordinate System(on page92)

Orphaned StructLayer(on page92) Sketch2D Custom Component is not related to a Wall, Opening, or Slab boundary(on page

93)

Struct Coordinate System is not associated to a FCBO (on page97)

Core

Error on the To Do list data(on page100)

Undefined/unknown error on the object(on page109)

General Errors

Object does not have a parent(on page143)

Hangers and Supports

Object has Different Permission Group than the Parent Object(on page161)

Route Cable

Leg without two terminus features(on page199)

Structure

Slab with duplicate boundary index(on page267)


17/292


S E C T I O N 1

Database integrity problems are data problems that can prevent modeling and can impact theaccuracy of deliverables such as reports. These problems can be grouped into the followingtypes:

Session files that cannot be read

Runtime objects and relations that are not in a workable state or are incorrect

Persisted objects and relations that are not in a workable state or are incorrect

A typical example of a database integrity issue is an object that exists without a mandatoryrelation to another object in the model. On the other hand, manufacturing issues are notconsidered database integrity problems.

This document contains a list of errors that are of the third type (persisted objects and relations).Some examples of this type of error are route parts without a relationship to a feature or run, or

a system without a parent.In this document, "database integrity" and "DB integrity" are used interchangeably.

These errors are not expected. However, in the event that they occur, you can correct themby taking the actions described in this Help file.

We strongly recommend that you check the databases from time to time and promptly reportany problems to Intergraph. Please provide details about how to reproduce the problem.

If you receive a database integrity error that is not listed in this document, contact IntergraphProcess, Power & Marine Support. Be prepared to provide a backup of the databases ifrequested.

To contact Intergraph Process, Power & Marine Support, visit the web athttp://support.intergraph.com(http://support.intergraph.com/).

See Also

Workflow for Addressing Database Integrity(on page19)

Understanding Database Integrity
http://support.intergraph.com/http://support.intergraph.com/http://support.intergraph.com/http://support.intergraph.com/


18/292

Understanding Database Integrity



19/292


S E C T I O N 2

The workflow to address database integrity has three overall steps:

1. Check the database integrity.

2. Run reports to review the errors.

3. Clean the database to correct the errors.

Checking Database Integrity

The Database > Integritycommand, which is available in Project Management, runs directly ona database (Site, Catalog, Model, or Reports), and creates records for the objects that need tobe cleaned. The databases available for checking vary depending on what you select before

clicking this command. After a database has been scanned for errors, you can generate a reportto review the errors that the Database > Integritycommand generated (see Running DatabaseIntegrity Reportsbelow).

You can run the Database > Integritycommand in Project Management, or as a customcommand in Project Management or the host. The ProgID for the custom command isSP3DCheckDatabaseIntegrity.CCheckObj.

Using the Command Line to Check Database Integrity (DBI)

You can use the command line to check database integrity outside SmartPlant 3D. When DBI isexecuted in Project Management, a text file called DbIntegrityCommandLine-.txt isgenerated in local temp folder with a command string reflecting all selections and options used.This method is especially helpful for scheduling this command to execute periodically without

user interaction. You can also update diagnostics reports using the Drawing Batch Server basedon this DBI schedule.

Running Database Integrity Reports

The software includes report templates intended for diagnosing database integrity issues. Youcan run these templates by opening a session in the software and clicking the Run Reportcommand on the Tools menu. The report templates are located in the Diagnostic folder on theCatalog Reportstab of the Run Reportdialog box. The Diagnostic Clean Database Issuestemplate lists errors, with each error occupying two rows in the report. Other Diagnostic CleanDatabase Issues templates group the errors by problem description or status. There is also atemplate that allows you to easily sort the errors using Excel's filtering capability on columns.The reports include the following information for the errors:

DataStore - Displays whether the problem exists in the model or catalog.

Problem Description- Provides a brief description of the error. Click the Searchtab in theDatabase Integrity Help and type the problem description to find more information about theerror, including how to fix it.

Status- Displays the current status of the object: New, Existing, Resolved, Closed, orProcessed. If the status is New, the error has been introduced recently due to operations inthe software. If the status is Existing, the error has been present for some time. If the statusis Resolved, the object had an error, and the problem was corrected. If the status is Closed,

Workflow for Addressing Database

Integrity


20/292

Workflow for Addressing Database Integrity


the object has been deleted or cleaned since the Database > Integritycommand was lastrun and no further action is necessary. If the status is Processed, the object has beencleaned, and you should run the Database > Integritycommand to see if further actionsshould be taken.

Severity- Displays the severity of the error: Fatal, Crucial, High, or Normal. The severity isa quick way to evaluate how important the problem is. Usually, a Normal severity has no

impact, and a Fatal severity is a very serious problem.

Action to Take- Describes what to do to fix the problem. The actions include No Action, ToBe Removed, To Be Repaired, and To Be Checked By DBChecker. If the action is To BeChecked By DBChecker, you should run the Database > Integritycommand again. For theTo Be Removed and To Be Repaired actions, see the following section.

Cleaning Errors

If the action on the report is To Be Removed or To Be Repaired, run the Clean Databasecustom command to delete or clean the object. For more information about deleting andcleaning objects, see Clean a Database(on page24).

When a database integrity error is logged against an object, the software specifies an ActionOIDthat denotes the object on which a possible correction will be performed. The Clean Database

command performs its cleaning action on this object referred to by the ActionOID. This objectmay be the object in error, or it may be a related object.

An example is when a weld is in error, but the update to correct the problem needs to be doneon the related connection.

After you fix a problem, be sure to check that it is solved and that no new problems havebeen created. Re-run the Database > Integritycommand and the DB Integrity reports, and thencheck the results.

Working in an Integrated Environment

When working in an integrated environment, database integrity issues can arise that require youto remove the design basis and register to another SmartPlant Foundation database. TheRemove Design Basiscustom command removes all correlation relationships and deletes all

design basis objects in the 3D model.Then, you can register the model, retrieve information, and re-correlate objects. For moreinformation, see the Troubleshooting section in the Integration Guide.

See Also

Database Integrity Custom Commands(on page20)

Database Integrity Custom CommandsThe following table summarizes the database integrity custom commands, their programidentification strings, and the purpose of the commands.

Custom

Command

ProgID Purpose

CheckDatabaseIntegrity

SP3DCheckDatabaseIntegrity.CCheckObj

Checks for database integrityproblems in a specified database.

If you are working in ProjectManagement, you can run this


21/292



CustomCommand

ProgID Purpose

command as a customcommand or with the Database> Integritycommand.

If you are working in the host,you can run this command as acustom command using Tools >Custom Commands.

CleanDatabase

SP3DCleanDatabaseCmd.CCheckObj

Cleans or deletes objects in aspecified database.

Find Object byOID

SP3DFindObjectByReport.FindObjects

Highlights the selected object (from areport) in a graphic view. Youchoose a previously run report,highlight a row in the report, andthen the selected object highlights inthe active graphic view. This

command only works for reports thatreturn OIDs.

See Also

Workflow for Addressing Database Integrity(on page19)

Check Database IntegrityThe Database > Integritycommand is available in the Project Management environment. Formore information on database integrity, see the Database Integrity Guide.

1. Select a Plant, catalog, or site in the Project Management tree view. Your selectiondetermines the databases available for checking database integrity: select a Plant if youwant to check all of the databases associated with that Plant; select a catalog if you want tocheck the Catalog database only; select a site to check the Site database only.

2. Select Database > Integrity. The Database Integritydialog box appears. For moreinformation, see Check Data Consistency Dialog Box.

3. Check the database you want to the command to process. You can check more than onedatabase.

4. Select Basic checkor Full check.

5. Click Runto start the command. Processing displays in the Checkingwindow.

6. When the command is done processing the selected databases, click Exitto dismiss thedialog box.


22/292



7. Go to the Commontask to use the Tools > Run Reportscommand and generate reportsof the records generated by the Database > Integritycommand.

Four example reports for Diagnostic Clean Database Issues are delivered.

Reports can be created persistently in the Drawings and Reports task and scheduled in theDrawing Batch server to run periodically after a scheduled DBI check.

Database Integrity CommandDatabase > Integrity - Runs directly on a database (Site, Catalog, Model, or Reports) andcreates records for the objects that need to be cleaned. After you scan the database forproblems, you can use the Tools > Run Reportcommand in the Commontask to review theerrors that the Database > Integritycommand generated.

In addition, you can use the Submit Jobbutton on the Check Data Consistency Dialog Box toaccess Batch Services to check integrity at times when the server may be less busy. Forinformation on setting up Batch Services, see Batch Services Quick Start Guide.

You can run this command for several different reasons:

To check the database for objects with integrity problems

To confirm that objects have been deleted or cleaned

To check for new problems

For more information on database integrity, see the Database Integrity Guide.

What do you want to do?

Check Database Integrity(on page21)

Schedule Check Data Consistency Task Using Batch Services(on page23)


23/292



Check Database IntegrityThe Database > Integritycommand is available in the Project Management environment. Formore information on database integrity, see the Database Integrity Guide.

1. Select a Plant, catalog, or site in the Project Management tree view. Your selection

determines the databases available for checking database integrity: select a Plant if youwant to check all of the databases associated with that Plant; select a catalog if you want tocheck the Catalog database only; select a site to check the Site database only.

2. Select Database > Integrity. The Database Integritydialog box appears. For moreinformation, see Check Data Consistency Dialog Box.

3. Check the database you want to the command to process. You can check more than onedatabase.

4. Select Basic checkor Full check.

5. Click Runto start the command. Processing displays in the Checkingwindow.

6. When the command is done processing the selected databases, click Exitto dismiss thedialog box.

7. Go to the Commontask to use the Tools > Run Reportscommand and generate reports

of the records generated by the Database > Integritycommand.

Four example reports for Diagnostic Clean Database Issues are delivered.

Reports can be created persistently in the Drawings and Reports task and scheduled in theDrawing Batch server to run periodically after a scheduled DBI check.

Schedule Check Data Consistency Task Using BatchServices

1. In Project Management, click Database > Integrity.

2. Complete the Check Data Consistencydialog box and click Submit Job.

3. Complete the Schedule Data Consistency Checkdialog box, including any Options.

4. Click OK.


24/292



Clean a DatabaseIn some cases, cleaning objects will cause a loss of data. Before working through thisprocedure, you should try to find a matching error message in this document. In the What YouShould Dosection of each error topic, there may be some steps that will easily fix the problemwithout loss of data.

Before running this command, make a backup of all the databases using the Backupcommandin Project Management. You can later provide this backup to Intergraph if further analysis isnecessary.

In order to clean objects, you must have access to the objects. You must have Full Control on allpermission groups in order to delete the objects.

1. Start the software.

2. Click Tools > Custom Commands.

3. Click Addon the dialog box.

4. In the Command ProgIDbox, type SP3DCleanDatabaseCmd.CCheckObj.

5. In the Command namebox, type text such as Clean Database.

6. Click OKon the Add Custom Commanddialog box.

7. Select the command name, and then click Run.

8. On the Clean Databasedialog box, specify the type of database in the Database typebox.

9. In the grid, select the object(s) to clean and click Clean Now.

You can select multiple objects by holding SHIFT or CTRL while clicking the objects.

You can sort the columns on the dialog box by clic

db integrity

Documents