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.
This is caused by non-standard English characters in the CM_CONFIGURATION_ITEM table
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
set @str = @str + '|' + char(@i)
set @i = @i + 1
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.