Object does not have the requested 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 relation.

Severity

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

Detailed Description

This error is reported under the following circumstances:

  1. For all Outfitting Cross-sections that are not related to an outfitting cross- section definition: Severity - High

  2. For all orphaned pipe ports in the database that are not associated with any parts: Severity - Low

  3. For all Name Rule Holder objects that are not associated with a class node object: Severity - High

  4. For all Insulation Thickness rule objects that are not related to an Insulation spec: Severity - Low.

  5. For all Allowable Insulation Thickness objects that are not related to an Insulation 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 Outfitting Cross-Section: This error will impact you when you use the HVAC and Electrical modeling tasks. If this relation is missing, then the software cannot get to these outfitting cross-section objects. Because the Reference data APIs will not be able to get to these objects, you cannot place ducts in these sizes. These objects will not be visible in the Catalog task, either.

  • Error with orphaned pipe ports: These are just orphaned entries in the database. No Impact.

  • Error with Name Rule Holder objects: This error will impact you when you are modeling objects. In order to get the Name rule that is associated with the type of object that they are modeling, the association between the class node and the Name Rule Holder is necessary. If this relation is missing, then the software cannot use the Name Rule to generate a new name for the object that is being modeled.

  • Error with Insulation Thickness Rule and Allowable Insulation Thickness objects: This error means that the software will not be able to access the insulation data, even though the data actually resides in the database. This error will impact you when you attempt to assign an insulation thickness to the objects that were placed in the model.

What You Should Do

Error with Outfitting Cross-Section: The problem can be addressed by using the Bulkload utility to delete the outfitting cross-sections and re-create them. Because the outfitting cross-section objects are referenced by other objects like HVAC specs, cableway specs, and parts that contain HVAC nozzles, you must update these references when the outfitting cross-section objects are deleted and re-created.

  1. Open the Excel workbook that contains the OutfittingCrossSections sheet, which contains the data for the outfitting cross-section objects.

  2. Create a workbook containing only this sheet.

  3. Start the Bulkload utility.

  4. In the Excel Files box, specify the newly created workbook.

  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 outfitting cross- sections in the database.

    The outfitting cross-section objects could be referenced by other workbooks. For example, HvacSpec, CablewaySpec and all parts that have HVAC nozzles can contain a reference to data from the OutfittingCrossSections sheet.

  8. Locate the HvacSpec sheet, and type M in the first column of all the rows on this sheet.

  9. Next, search through all the part class sheets and locate the parts that have HVAC nozzles. Type M in the first column of all these parts. Parts that contain HVAC nozzles with references to outfitting cross-section objects can be located by searching for the string "):CrossSection" in the Head row.

  10. Start the Bulkload utility.

  11. Select all the workbooks that were modified.

  12. Specify the server, database, log file, and other details on the dialog box.

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

  14. Click Load. Bulkload will update the objects that have references to the outfitting cross-sections that were created.

  15. Locate all the workbooks that contain the CableWaySpec sheet and type D in the first column of all the rows on the sheet.

  16. Start the Bulkload utility.

  17. Select all the workbooks that were modified.

  18. Specify the server, database, log file, and other details on the dialog box.

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

  20. Click Load. Bulkload will delete all the cableway spec objects and the relations that they might have with other outfitting cross-section objects. This step is necessary because it is not possible to directly delete the relation between the cableway spec and the outfitting cross-section objects.

  21. Locate all the workbooks that contain the CableWaySpec, CableWayNominalSizes, and CableWayBendRadius sheets. Type A in the first column of all the rows on the sheets.

  22. Start the Bulkload utility.

  23. Select all the workbooks that were modified.

  24. Specify the server, database, log file, and other details on the dialog box.

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

  26. Click Load. Bulkload will create the objects and also update the references to the outfitting cross-sections that were created.

Error with Name Rule Holder objects: The problem can be addressed by using the Bulkload utility to re-create the Name Rule Holder objects.

  1. Open the Excel workbook that contains the NamingRules sheet, which contains the data for the Name Rules. In the set of data that is delivered with the software, this data can be found in the GenericNamingRules.xls workbook.

  2. On this sheet, type A in the first column of all the rows.

  3. Start the Bulkload utility.

  4. In the Excel Files box, specify the workbook that was modified.

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

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

  7. Click Load. Bulkload will attempt to re-create all the entries on the sheet.

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

  1. Open the Excel workbook that contains the InsulationThicknessTable sheet, which contains the data for the Insulation Thickness Rule. In the set of data that is delivered with the software, this data can be found in the InsulationData.xls workbook.

  2. On the sheet, type D in the first column of all the rows that define the thickness values. Be sure to leave out the rows that define a spec name.

  3. Start the Bulkload utility.

  4. In the Excel Files box, specify the workbook that was modified.

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

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

  7. Click Load. Bulkload will delete all the thickness objects from the database.

  8. Re-open the Excel sheet that was modified.

  9. This time, replace the D in the first column with A.

  10. Start the Bulkload utility.

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

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

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

  14. Click Load. Bulkload will re-create all the thickness objects in the database. This process will re-create the relations that were reported as missing by the database integrity scripts.

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

  1. Open the Excel workbook that contains the InsulationMaterial sheet, which contains the data for the Allowable Insulation Thickness Rule. In the set of data that is delivered with the software, this data can be found in the InsulationData.xls workbook.

  2. On this sheet, type D in the first column of all the rows that define the thickness values. Be sure to leave out the rows that define a material type and density.

  3. Start the Bulkload utility.

  4. In the Excel Files box, specify the workbook that was modified.

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

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

  7. Click Load. Bulkload will delete all the thickness objects from the database.

  8. Re-open the Excel sheet that was modified.

  9. This time, replace the D in the first column with A.

  10. Start the Bulkload utility.

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

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

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

  14. Click Load. Bulkload will re-create all the thickness objects in the database. This process will re-create the relations that were reported as missing by the database integrity scripts.