Entity <ObjectID> is a subentity of itself.

^{Entity <ObjectID> is a subentity of itself.}

Message Text

This entity is a subentity of itself, due to a loop in the subentity hierarchy. One of the entities in this hierarchy should not be a subentity.

Explanation

The subentity hierarchy cannot be circular. It must go in one direction from the subentity to the parent entity. The following examples show an incorrect hierarchy:

• Enlisted is a subentity of Military Personnel.
  
  
• Officer is a subentity of Enlisted.
  
  
• Military Personnel is a subentity of Officer.

This error occurs when:

• An error is introduced while editing the Semantic Modeling Format (SMF).

Action

To prevent this error:

• Redirect the foreign keys when you make one entity a subentity of the other.

To correct this error, redirect the join and make one entity a subentity of the other:

1. In the Join/New Join dialog box, correct the joins between the table so that they point in the right direction. In the Military Personnel example, point the join for Enlisted to Military Personnel and delete the join from Enlisted to Officer as seen in the following diagram:

   

2. In the Advance Entity Properties dialog box for the subentity, on the Semantics Properties tab, in the Is subentity of list, click the parent entity. In this example, Military Personnel would be listed in the Is subentity of option for both the Enlisted and Officer entities.

See Also

Compile-Time Error Messages (Authoring Object Model)

How to add a join

How to delete a join

How to edit a join

Join/New Join Dialog Box

Semantic Properties Tab (Advanced Entity Properties Dialog Box)

Specify Join Path Dialog Box

SQL Database Normalization Rules

Table/New Table Dialog Box