Unable to generate Trend and Group Trend reports

book

Article ID: 5754

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

Reports that the Trend and Group Trend reports are showing the following for the Metric Type and Element drop downs: 

Error: Could not load metric list. 
Error: Could not load element list.

Cause

This is caused by non-standard English characters in the CM_CONFIGURATION_ITEM table

Environment

UMP 8.5

Resolution

1/ Run the following query to select rows from CM_CONFIGURATION_ITEM which contain characters outside of the standard English character set. 

declare @str varchar(255) 
declare @i int 
set @str = '' 
set @i = 32 
while @i <= 127 
begin 
set @str = @str + '|' + char(@i) 
set @i = @i + 1 
end 
SELECT * from CM_CONFIGURATION_ITEM 
WHERE ci_name LIKE '%[^' + @str + ']%' escape '|' 

2/ Confirm that the rows located do contain either non-displayable or otherwise invalid characters. 

3/ Backup table CM_CONFIGURATION_ITEM 

4/ Run the same query as in 1/ but this time replacing the SELECT with DELETE and remove the * between Select & from to delete those rows. 

5/ Once the delete has completed, deactivate and then activate the discovery_server probe.

6/ Check if you are now able to access the Trend and Group Trend reports for the groups/servers under which they previously failed.