Object does not have the requested simple relation - Intergraph Smart 3D - Administration

Intergraph Smart 3D Database Integrity Administration

Language
English
Product
Intergraph Smart 3D
Subproduct
Database Integrity
Search by Category
Administration & Configuration
Smart 3D Version
11 (2016)

Message

Object does not have the requested simple relation.

Severity

The severity of the error depends on the type of object for which this error has occurred. Please see the Detailed Description section for the level of severity for each type of object.

Detailed Description

This error is reported under the following circumstances:

  1. For all Catalog Roots that do not have a parent: Severity - Low

  2. For all Piping commodity filters that are not related to any piping materials class: Severity - Low

  3. For all parts that are not related to any part class: Severity - Low

  4. For all orphaned SymboldefHelper objects that are not associated with any Parts, cross sections, or StructFeatureOrJoint objects: Severity - Low.

  5. For all HVAC Permissible Thickness Objects that are not associated with an HVAC material: Severity - Low

Possible Cause

This situation can happen when there are unexpected errors when editing the data using the Bulkload utility. Under normal circumstances, modification of data using the Bulkload utility will, if necessary, automatically propagate changes to objects that are related to the data. If there is an unexpected error while modifying the data, it can result in some associated objects getting left behind as orphans in the database.

Possible Impacts

  • Error with Catalog Roots: If the Catalog Root object does not have a parent object, then the object and its children will not be visible in the Catalog task.

  • Error with Piping commodity filters objects: This error will impact you when you go into the Piping task. Depending on the piping commodity filter data with which the relation is missing, three types of errors can result - (a) Routing of pipe can fail for one or more sizes, (b) Automatic insertion of components, for instance, elbows, can fail in some scenarios, (c) When inserting components, some of the short codes might not appear in the dropdown box.

  • Error with orphaned parts: These orphaned entries will not be visible in the Catalog task - as a result, you cannot select the part from the Catalog browser. If the orphaned part is an Equipment part, then these parts cannot be placed as Equipment. If the orphaned part is a pipe part, then these parts will not be available for selection from the Catalog browser when the piping designer wants to override the part supplied by the spec with a part that is selected from the Catalog browser.

  • Error with orphaned SymbolDefHelpers: No Impact.

  • Error with HVAC Permissible Thickness Objects: If the relation is missing, then the software cannot access these thickness objects. Because the Reference data APIs will not be able to get to these objects, you cannot specify route ducts in these thicknesses. These objects will not be visible in the Catalog task, either.

What You Should Do

Error with Catalog Roots: The problem can be addressed by using the Bulkload utility to associate the Catalog root to a parent. In most cases, the parent of a Catalog root object is the Catalog root object named CatalogRoot.

  1. Open the Excel workbook that contains the data about Catalog root objects.

  2. Carefully look through the CatalogRoot and R-Hierarchy sheets to identify the Catalog root object that does not have a parent.

  3. After identifying the Catalog root object that does not have a parent, add an entry on the R-Hierarchy sheet specifying both the object name as well as its parent name.

  4. Type A in the first column of the row that was just added.

  5. Start the Bulkload utility.

  6. In the Excel Files box, specify the workbook that was modified in the previous step.

  7. Specify the server, database, schema, and other details on the dialog box.

  8. For the bulkload mode, select Add, modify, or delete records in existing catalog.

  9. Click Load. Bulkload will add a relation between the Catalog root object and the parent that was identified in the previous step.

Error with Piping commodity filters objects: The problem can be addressed by using the Bulkload utility to re-create the piping commodity filter objects.

  1. Open the Excel workbook that contains the PipingCommodityFilter sheet, which contains the data for the piping commodity filter objects.

  2. Create a workbook containing only this sheet.

  3. Start the Bulkload utility.

  4. In the Excel Files box, specify the new workbook that was created in step 1.

  5. Specify the server, database, schema, and other details on the dialog box.

  6. For the bulkload mode, select Delete and replace records in existing catalog.

  7. Click Load. Bulkload will then delete and re-create all the piping commodity filter objects in the database.

Error with HVAC Permissible Thickness objects: The problem can be addressed by using the Bulkload utility to re-create the HVAC Permissible Thickness objects.

  1. Open the Excel workbook that contains the PermissibleDuctThickness sheet, which contains the data for the HVAC Permissible Thickness objects.

  2. Create a workbook containing only this sheet.

  3. Start the Bulkload utility.

  4. In the Excel Files box, specify the new workbook that was created in step 1.

  5. Specify the server, database, schema, and other details on the dialog box.

  6. For the bulkload mode, select Delete and replace records in existing catalog.

  7. Click Load. Bulkload will then delete and re-create all the HVAC Permissible Thickness objects in the database.