Metrics to select for custom view unavailable but dashboard has metrics

Products

• DX Infrastructure Management

Issue/Introduction

Devices  in the Inventory Dashboard for  device shows metrics in charts but

choosing the Metrics view to create a custom Metric view, does not display a

metric tree to select  for this device.

Cause

The issue was due to  missing unit_type for Metric Type 2.1:3 & 2.1:4 of the net_traffic probe which was not  in use.

Environment

Release : 20.3.3

Component : UIMUMQ : UIM - UMP_QOSCHART,NET_TRAFFIC PROBE.

Resolution

1) Delete probe from the system, then Delete the QOS objects from Operator Console --> SLM --> Database Status. Select QOS objects and from right hand side menu click on DELETE objects menu item.

 

 

 

2)From the sql database

 follow below steps to delete QOS objects from database. 

Step 1: 

Run below query to get the list of QOS objects to be deleted. Replace the SERVERNAME with the actual server name for which we want to delete the data. Review the result and make sure the list is accurate as the data will be deleted permanently. 

SELECT * FROM S_QOS_DATA WHERE source LIKE 'SERVERNAME%'
 

Step 2: 

Delete the QOS objects from S_QOS_DATA using below query. Replace the SERVERNAME with the actual server name.

delete from S_QOS_DATA where table_id IN (SELECT table_id FROM S_QOS_DATA WHERE source LIKE 'SERVERNAME%')

Data related to r_table, h_table, v_table remains in the database and would get cleared when retention period is crossed. But if you want to clean this data immediately, you may run the below statements. Note the r_table, h_table, v_table values from Step1 and replace them below along with table_id. 

DELETE FROM <R_TABLE> WHERE table_id = <TABLE_ID>    
DELETE FROM <H_TABLE> WHERE table_id = <TABLE_ID>    
DELETE FROM <V_TABLE> WHERE table_id = <TABLE_ID>