TECH TIP: Why won't my TopN report load?

Document created by casph02 Employee on Sep 27, 2016Last modified by Melissa Potvin on Dec 17, 2016
Version 5Show Document
  • View in full screen mode

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.

Attachments

    Outcomes