Troubleshooting Scenarios

Description

In APM, when you attempt to access the Asset Hierarchy, a message with Entities with multiple parents exist appears and the hierarchy does not display.

Note that this issue is possible if you include a Many-to-Many relationship in the asset hierarchy configuration, which is not recommended, or if a relationship priority is not correctly configured in the asset hierarchy configuration. See Asset Hierarchy Configuration for more information.

Cause

An Asset in the hierarchy that you are attempting to access may have multiple parent relationships.

Solution

Perform the following steps:

1. Run the following query and analyze the results.

   SELECT enty_key,fmly_key,enty_id
   from MIV_MI_AST_HRCY_MV
   

2. If only one row appears with an error message Entities with multiple parents exist, run the following query.

   SELECT MIV_MI_AST_HRCY_MV_DUP.parent_enty_key
   , MIV_MI_AST_HRCY_MV_DUP.parent_fmly_key
   , MIV_MI_AST_HRCY_MV_DUP.enty_key
   , MIV_MI_AST_HRCY_MV_DUP.enty_id
   , mi_families.fmly_id
   FROM MIV_MI_AST_HRCY_MV_DUP 
    JOIN mi_families ON MIV_MI_AST_HRCY_MV_DUP.fmly_key = mi_families.FMLY_KEY
   ORDER BY MIV_MI_AST_HRCY_MV_DUP.enty_key Asc

3. All the assets with multiple parents will be listed.
4. Access the parent record in the Record Manager that has the duplicate relationship to be removed.
5. Navigate to the child record and select > to view the child record datasheet.
6. Select and select Unlink this record.
7. Repeat steps 4-6 for each duplicate relationship.
8. Rebuild the asset hierarchy.
9. Repeat step 1 to validate that duplicate relationships no longer exist in the hierarchy.
   Note: If asset data is automatically synched from the EAM system, you may need to correct the asset hierarchy in the EAM system as well, otherwise the relationships that were deleted in step 6 may be recreated next time the sync runs.