View Map in Event Management doesn't work properly and no CIs correlated are showed.


Description

Event Management " Service - Application Services" and " Event management - Operator Workspace" the View Map doesn't work properly. No CIs correlated are showed.

Steps to reproduce :

Some time the Map populates and some time the Map does not populates and we can see the below warnings in the node when the Map is not populated.

Default-thread-10 10AAD90901E42010FBCBFAB076D4835F txid=7bab5d4d01e4 WARNING *** WARNING *** BusinessServiceTreeBuilder: Multiple root nodes.
Default-thread-10 10AAD90901E42010FBCBFAB076D4835F txid=7bab5d4d01e4 WARNING *** WARNING *** BusinessServiceTreeBuilder: Multiple root nodes.

Release or Environment

NewYork

Cause

When we click on the View Map, on the backend we are doing queries on sa_service_group_member, sa_m2m_service_entry_point and then em_impact_status and ending up with taking the severity from these record in that process we get the multiple root nodes warning.

Resolution

The issue is related to the wrong calculation for service groups

The solution is to add the attached script include and run it with the help of scheduled script.

Script Include

Scheduled Script

Note : You can run the script on a weekly basis and in case if you are facing the issue frequently you can increase the frequency of scheduled run.