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.
No Valid Datatable was Returned error for a SQL v2 BETA sensor
Votes:
0
3 Replies
Votes:
0
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.
Created on Sep 29, 2016 2:53:55 PM by
Last change on Sep 29, 2016 2:55:04 PM by
Votes:
0
In that case please change the SQL statement to have always a return result. "Process data table" cannot process and empty result.
Created on Oct 3, 2016 9:32:40 AM by
Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.
Add comment