Good evening,

I updated PRTG and changed the old Oralce/MsSql/Mysql sensors with the new ones. Everything work except the Oracle one where I get this error "No valid datatable was returned".

It worked a week and without change anything he started saying "No valid datatable was returned".

Why?

Article Comments

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

Hi AndreaM, with one of our changed Oracle sensors we got the same message... Imo it's a Problem that sometimes nothing was returned.

OLD:
select 
EXTRACT (HOUR   FROM (ELAPSED_TIME))*60*60+ 
EXTRACT (MINUTE FROM (ELAPSED_TIME))*60+ 
EXTRACT (SECOND FROM (ELAPSED_TIME))
from all_scheduler_running_jobs where job_name='xyzJOB'

NEW:
select 
nvl(
max(
EXTRACT (HOUR   FROM (ELAPSED_TIME))*60*60+ 
EXTRACT (MINUTE FROM (ELAPSED_TIME))*60+ 
EXTRACT (SECOND FROM (ELAPSED_TIME)) 
), 0)
from all_scheduler_running_jobs where job_name='xyzJOB'

Aug, 2016 - Permalink