Dashboard Views display old host name for Interface items

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

We have a set of devices which had the hostname change. The old devices were removed and the new devices were added. However we see in the dashboards the old hostnames are reflecting. 

This is only seen in Dashboards and Reports for the interfaces from affected devices.

They show "HostName - ifDescr" as the name for Interface Items.

The ifDescr is correct, but for some the Host Name is the old host name.

Examining the Interface on it's Context Report or other non-Report areas of the Portal UI shows the correct host name.

If we examine the Alias name for the device, which populates it's DisplayName value, we see it still has the old host name.

Cause

The mechanism for updating the Alias name and thus the DisplayName, after a devices Host Name changes, fails to function properly.

Environment

All supported DX NetOps Performance Management releases r21.2.1 and older.

Resolution

This is being addressed via defect DE496182. Code change in the r21.2.2 and newer releases resolves this. Upgrade to r21.2.2 or newer to resolve this problem.

The following steps will resolve this until able to upgrade to r21.2.2 or newer releases.

1. Log in to the Performance Center server CLI.
2. Go to (default path) /opt/CA/MySql/bin
3. Enter the MySql prompt using this command. Enter the password when prompted.
   • ./mysql -uroot -p netqosportal
4. Run these MySql commands.
   
   1. This first command will set Alias=NULL for all Devices.
      • update t_device set Alias = NULL;
   2. This second command will set DisplayName to use ItemName if it is not already set to the same value as ItemName.
      • update t_device set displayname=itemname where displayname <> itemname;
   3. Exit the MySql prompt with the command:
      • exit
5. Back in the CLI on the Performance Center host run the following two curl commands. The clear out the Performance Center Item and Group cache. Next time a query is run it repopulates it with the new Alias names in the DB. Enter the Performance Center default admin user password when prompted for each curl command.
   • curl -k -v -X PUT -H 'Content-Type: application/xml' -d '<emptybody/>' -su admin http://localhost:8181/pc/center/webservice/invalcache/ITEM
   • curl -k -v -X PUT -H 'Content-Type: application/xml' -d '<emptybody/>' -su admin http://localhost:8181/pc/center/webservice/invalcache/GROUP  

 Running the same Dashboards shows the problem is resolved.