I am receiving the alarm "invalid comparison condition" from the sql_response probe. What does this mean?
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.
Release : 20.3
Component : UIM - SQL_RESPONSE
Ensure your query can only return numeric results or apply the appropriate hotfix.
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.