When running the TopN report in USM, it fails with "Error: could not load metric list."
This is often caused by special chars in the S_QOS_DATA table for one or more of the devices in the group that the TopN report is running for.
Document ID: TEC000005335
Last Modified Date: 11/10/2015
Hide Technical Document Details
Products
- CA Unified Infrastructure Management
Components
- UNIFIED INFRASTRUCTURE MGMT:CAUIM
Introduction
Sometimes it is necessary to search for and eliminate bad data in tables such as S_QOS_DATA, NAS_ALARMS, etc. especially when the UMP/USM cannot display the data or remains at "Retrieving data..." or the interface/module simply never finishes loading data or hangs. The queries can be run in the SLM portlet or a database tool such as MS SQL Server studio.
Procedure
THIS ARTICLE explains how to search for non-ASCII chars in MS SQL.