qos_processor logging update failures - "Monitor update failed" over and over

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The qos_processor probe is logging the following over and over:

Oct 07 09:51:20:380 [Qos Monitor Database Updater #13, qos_processor] Monitor update failed for '1007CE3033E3C02F23D8A0AFEFE3515942BB475E-hostname'

 

Environment

Release : 20.4

Resolution

Excecute the following query - it should return no results:

select CONVERT(VARCHAR(41),HashBytes('SHA1', convert(varchar(1024), CONCAT(qos_data.qos,'#',qos_data.source,'#',qos_data.target,'#',qos_data.origin))),2), *
FROM S_QOS_DATA qos_data
INNER JOIN S_QOS_DATA T on qos_data.table_id = T.table_id
        and T.checksum!=CONVERT(VARCHAR(41),HashBytes('SHA1', convert(varchar(1024),
CONCAT(qos_data.qos,'#',qos_data.source,'#',qos_data.target,'#',qos_data.origin))),2)
order by qos_data.created desc; 

If it in fact returns results this indicates that a script which was intended to update checksums as part of the 8.51->9.02 upgrade had failed.

Run the following query to correct the issue:

- stop data_engine
- execute query:

update qos_data
set checksum = CONVERT(VARCHAR(41),HashBytes('SHA1', convert(varchar(1024),
CONCAT(qos_data.qos,'#',qos_data.source,'#',qos_data.target,'#',qos_data.origin))),2)
FROM S_QOS_DATA qos_data
INNER JOIN S_QOS_DATA T on qos_data.table_id = T.table_id
        and T.checksum!=CONVERT(VARCHAR(41),HashBytes('SHA1', convert(varchar(1024),
CONCAT(qos_data.qos,'#',qos_data.source,'#',qos_data.target,'#',qos_data.origin))),2);

- start data_engine

This will fix the checksums and resolve the errors.

Additional Information

Qos Monitor update failed messages in qos_processor log in UIM 20.4