What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

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

Votes:

0

Your Vote:

Up

Down

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 by  APLACIDO (0) 1



3 Replies

Votes:

0

Your Vote:

Up

Down

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

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



Votes:

0

Your Vote:

Up

Down

I am using "Process Data Table" option.

Created on Oct 3, 2016 8:44:23 AM by  APLACIDO (0) 1



Votes:

0

Your Vote:

Up

Down

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]



Please log in or register to enter your reply.


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.