Hello,
We have a large numer (30+) of Oracle SQL v2 Beta sensors. Most of them perform very well. A few of the queries against the target database are quite complex and take a few seconds to return a result. It appears that if this is longer than about 5 seconds, the sensor throws a "Timeout (code: PE018)" error.
It is quite normal for some of these queries to take a long time to return a result (5 or even 10 seconds), so we need some way of extending the timeout on these particular sensors.
I have noticed that the Oracle SQL sensor (not the v2 Beta version) as well as the Custom ssh / exe / script sensors all have a timeout setting which can be increased: if the script takes longer than this to return a result, then return an error.
However there appears to be no such setting for Oracle SQL v2 Beta sensors. Is there any way that I can change this timeout setting "behind the scenes" maybe?
I guess another way would be to run the SQL via Powershell and add a custom Powershell sensor instead, but I'd rather find an easier way.
Any information greatly appreciated
Many thanks in advance
Tom
Add comment