I am running an Oracle v2 SQL Sensor on a remote probe, and am also running the same SQL in an Oracle Depracated SQL sensor. The V2 sensor will intermittantly return "No Data", whereas the V1 sensor does not.
The SQL is a query that will never return a null result, as below -
select (cast(sys_extract_utc(systimestamp) AS DATE) - cast(max(eventtimecolumn) AS DATE)) * 24 * 60 * 60 from eventtable
We use this to check the number of minutes difference between the current UTC time & the max UTC time of a column in a (small) table.
As the V1 sensor is OK, but the V2 sensor returns "No Data" - is there a problem with the V2 sensor ?