What causes the message "invalid comparison condition" in sql_response
Article ID: 214152
Updated On:
Products
Issue/Introduction
I am receiving the alarm "invalid comparison condition" from the sql_response probe. What does this mean?
Environment
Release : 20.3
Component : UIM - SQL_RESPONSE
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.
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.
Feedback
