Error "none" in Event List Columns Following DX NetOps Upgrade to 25.4.7

Products

• Network Observability
• CA Performance Management

Issue/Introduction

Empty columns appear in the DX NetOps event list view after upgrading to version 25․4․7, displaying "none" or "No Data to display" inside affected column cells instead of their expected string values․․․․

ERROR MESSAGE: "No Data to display"

SYMPTOMS:

• Column cells for event type, sub type, item type, and item sub type report "none" or are completely empty․

• Sorting an empty column displays the message "No Data to display"․

• Columns containing data can still be sorted successfully․

• The Description column remains unaffected and displays data normally․

Environment

DX NetOps  Performance Management 25․4․7

Cause

A code modification in version 25․4․7 parameterized SQL to mitigate security risks from SQL injection caused this issue.

Resolution

PREREQUISITES:

• Access to the command line interface of the Performance Center server․

• Root or administrative privileges to modify product configuration files and restart backend services․

STEPS:

1․ BACK UP AND EDIT THE QUERY CONFIGURATION FILE: Open the event manager queries XML file for editing․

sudo cp /opt/CA/PerformanceCenter/EM/webapps/EventManager/WEB-INF/canned/em.queries.xml /opt/CA/PerformanceCenter/EM/webapps/EventManager/WEB-INF/canned/em.queries.xml.bak

2․ REMOVE PROBLEMATIC QUOTES FROM CULTURE AND LOCALE ATTRIBUTES: 

Find: '{․Culture}' and replace with: {․Culture}

Find: '{․Locale}' and replace with: {․Locale}

sudo sed -i -e "s/'{\.Culture}'/{.Culture}/g" -e "s/'{\.Locale}'/{.Locale}/g" /opt/CA/PerformanceCenter/EM/webapps/EventManager/WEB-INF/canned/em.queries.xml

3․ SAVE CHANGES AND RESTART THE EVENT MANAGER SERVICE:

Save the file changes and restart the Event Manager (EM) service to reload the updated queries XML configuration․

$ sudo systemctl restart caperfcenter_eventmanager

VERIFY SUCCESS:

• Log in to the DX NetOps Portal view․

• Open the Event List and confirm that columns such as event type, sub type, item type, and sub type display expected data rather than remaining blank or showing "none"․

• Verify that sorting functions correctly on all visible columns․

Additional Information

• Target Fix Milestone: NetOps 25․4․9 Release