We have a SQL sensor that is working just fine. When we created a new SQL v2 BETA for the said sensor, we are getting a "No Valida Datatable was Returned" error. The query looks for the top service which is running slow. If the query does not return anything, the sensor should be up.
Article Comments
In that case please change the SQL statement to have always a return result. "Process data table" cannot process and empty result.
Oct, 2016 - Permalink
Dear APLACIDO
How do you evaluate the SQL result? Are you using the "Count table row" option? If that is the case, please update your PRTG as we changed the result to return 0 if there is just an empty table.
Sep, 2016 - Permalink