What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags

View all Tags

No Valid Datatable was Returned error for a SQL v2 BETA sensor



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.

error no-valid-datatable sql-v2

Created on Sep 29, 2016 5:48:12 AM

3 Replies




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  Arne Seifert [Paessler Support]

Last change on Sep 29, 2016 2:55:04 PM by  Arne Seifert [Paessler Support]



I am using "Process Data Table" option.

Created on Oct 3, 2016 8:44:23 AM



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  Arne Seifert [Paessler Support]

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.