sql_response probe does not clear value alarm

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

In the sql_response probe based on query return value, breached threshold and alarm got triggered. 

However when value goes back to normal , alarm does not clear.

Environment

Release :

Component : UIM - SQL_RESPONSE

Resolution

From sql_response configuration it was observed  "row_key" value was defined 

This field is normally empty for the profile which returns a single value.

This field should not be manually populated for profile which returns a single value .

row_key is used in below scenario:-

Defines one or more columns that make the unique identifier for every row.

This option is used if the query returns more than one row to distinguish alarm and QoS messages issued by the profile for every row.

After removing the row key value configured and tested by changing values in database the alarm got triggered.

After changing this back to a value within threshold, alarm got cleared .

Only use the row_key option if your query returns more than one row to distinguish alarm and QoS messages issued by the profile for every row.i.e for getting correct suppression key to clear alarms otherwise it is not required to specify row_key 

Additional Information

url_response IM configuration