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.
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.
Release : 20.3.3
Component : UIMUMQ : UIM - UMP_QOSCHART,NET_TRAFFIC PROBE.
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.
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%'
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>