DX NetOps is No Longer Showing Wifi Alarms on the Wifi Health Dashboard

Products

• Network Observability

Issue/Introduction

After our latest upgrade of DX NetOps Performance Management, wifi alarms are no longer showing in Wifi Health Dashboard. When reviewing detailed view logging for this dashboard, you will see the below exception in the Event Manager logs:

Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'af.StringAttr5' in 'field list'
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:988)
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1056)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:732)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:658)
        ... 73 more

Environment

DX NetOps 25.4.9 - 25.4.11

Cause

Defect

Resolution

This fix will be included in the DX NetOps 25.4.12 release. The workaround for versions 25.4.9 - 25.4.11 is as follows:

1. Open the /opt/CA/PerformanceCenter/EM/webapps/EventManager/WEB-INF/canned/em.canned.xml file.

2. Find the "alarms for items" section and modify:

SELECT DISTINCT

   {FieldList}

FROM alarms al

INNER JOIN alarm_item_properties ai

    ON ( al.LocalID=ai.LocalID AND al.SourceID=ai.SourceID )

INNER JOIN items Item

    ON ( ai.ItemID = Item.ItemID )

to:

SELECT DISTINCT

   {FieldList}

FROM alarms al

INNER JOIN alarm_item_properties ai

    ON ( al.LocalID=ai.LocalID AND al.SourceID=ai.SourceID )

INNER JOIN items Item

    ON ( ai.ItemID = Item.ItemID )

LEFT JOIN alarm_filter_attribute_values af

ON ( al.LocalAlarmID=af.LocalAlarmID AND al.SourceID=af.SourceID )

{Where}

3. Save the file.