Object has an unexpected relation - Intergraph Smart 3D - Administration & Configuration

Intergraph Smart 3D Database Integrity Administration

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

Message

Object has an unexpected 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:

A: A Catalog Root object that has a relation with Class Node: Severity - Crucial

B: For pipe parts that have a relation to more than one commodity piping material control data object: Severity - Crucial

Possible Cause

A: This error is reported when one of the hierarchical nodes (objects from ClassNodeType sheet) is related directly to the Catalog Root (top node in the Catalog task, which is represented by the name of the catalog), instead of its respective hierarchy Root node.

B: This error is reported when the Catalog database contains pipe parts that have a relation to more than one commodity piping material control data object. This situation can happen when the material control data-pipe component semantic (which is triggered when the part is created) encounters an unexpected error. Incorrect data on the PipingCommodityMatlControlData sheet will lead to such an error. An example is when multiple entries on the PipingCommodityMatlControlData sheet have identical contractor commodity codes, but overlapping first size and/or second size ranges.

Possible Impacts

A: Error with Catalog Root: If the Catalog Root object has a relation with any of the hierarchy nodes (class nodes), then sometimes nothing will come up under the top root node in the Catalog task.

B: Error with pipe parts: This error will impact you when you go into the Piping task. One or more of the reference data APIs will return an error code when encountering a piping part that is related to more than one piping commodity material control data object.

What You Should Do

A: Error with Catalog Root: The problem can be corrected by using the Bulkload utility to remove the unexpected relation with the Catalog Root. Open the Excel workbook and go to the R-Hierarchy sheet. Locate the incorrect relation made on this sheet with the Catalog Root. Type D in the first column and bulk load using the Add/Modify/Delete mode.

B: Error with pipe parts: The problem can be addressed by using the Bulkload utility to delete and re-create the piping commodity material control data.

  1. Open the Excel workbook that contains the PipingCommodityMatlControlData sheet. Carefully review and correct the data to make sure that there are no entries with overlapping size ranges for a given contractor commodity code.

  2. Create a new workbook with only this sheet.

  3. Start the Bulkload utility.

  4. In the Excel Files box, specify the workbook that you edited 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 delete and re-create all the piping commodity material control data objects.