Group Scorecard views display incorrect event count

Products

• Network Observability

Issue/Introduction

observed an issue affecting the Group Scorecard views across multiple dashboards.

The views initially display the  group/subgroup names, event counts, status indicators, and availability. However, even though events are present for the perios still counts show as 0

Environment

25.4.x

Cause

when using {.EventType.TypeName} in em.queries.xml, they are surrounded by single quotes.

When SQL runs, it is unable to replace :rib0 because it's a literal now.  

Resolution

DE210698 for Group Scorecard views display incorrect event count status

Workaround

Backup em-queries.xml 
 EM/webapps/EventManger/WEB-INF/canned/em.queries.xml

Edit EM/webapps/EventManger/WEB-INF/canned/em.queries.xml

Removing single quotes cause the SQL to replace :rib0 with the string set in the parameter map.

Find:
        cast(ifnull(eventtype_l10n.TypeName, 'none') as char) LIKE '{.EventType.TypeName}' AND
        cast(ifnull(eventtype_l10n.SubTypeName, 'none') as char) LIKE '{.EventSubType.SubTypeName}' AND
Replace with:
        cast(ifnull(eventtype_l10n.TypeName, 'none') as char) LIKE {.EventType.TypeName} AND
        cast(ifnull(eventtype_l10n.SubTypeName, 'none') as char) LIKE {.EventSubType.SubTypeName} AND

There are 5 instances

restart EM

To Stop
systemctl stop caperfcenter_eventmanager

To check status
 systemctl status caperfcenter_eventmanager

To Start
systemctl start caperfcenter_eventmanager

Not Fixed but targeted

NetOps 25.4.12 Release