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.
300.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags

View all Tags

V2 SQL Sensor returning "No Data"



Your Vote:



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 ?

no-data oracle sensor v2

Created on Apr 26, 2016 10:13:40 AM by  davederrick (60) 1

Last change on Apr 26, 2016 12:16:30 PM by  Luciano Lingnau [Paessler]

1 Reply



Your Vote:



Hello Dave,
thank you for your post.

  • Please confirm, the SQL v2 sensor is intermittent?

We'll need to confirm the exact version of PRTG that you're running, additionally, we'll need you to enable the " Write sensor result to disk (Filename: "Result of Sensor [ID].txt")" option from the sensor and share the result (which will be stored under C:\ProgramData\Paessler\PRTG Network Monitor\Logs (Sensors)\ on the probe on which the sensor was deployed.)

Ideally we suggest that you open a Support ticket so that you may share a support bundle and the other required logs, which can't be easily attached here.

Best Regards,

Created on Apr 26, 2016 12:21:07 PM by  Luciano Lingnau [Paessler]

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.