search cancel

What causes the message "invalid comparison condition" in sql_response

book

Article ID: 214152

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

I am receiving the alarm "invalid comparison condition" from the sql_response probe.  What does this mean?

Cause

This is normally caused by the query results unexpectedly returning a non-numeric value when a numeric comparison is defined in the configuration file, but can also be the result of a defect in the probe GUI.


If you receive an alarm with this message during normal probe operation then it means your query is returning a non-numeric value.

If it occurs only when you choose 'Run Now' on the profile in the probe GUI, but does not occur during the probe intervals and does not send an alarm otherwise, then it is a result of the known defect.

Environment

Release : 20.3

Component : UIM - SQL_RESPONSE

Resolution

Ensure your query can only return numeric results or apply the appropriate hotfix.

Additional Information

If this is occurring only in the GUI, but not the actual runtime profile, and you have confirmed you are only getting numeric results, then you can resolve this issue by upgrading to sql_response 1.80-HF2 or later.

 

UIM Hotfix Index Site