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

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