Advanced Query Timeout

Stanley Mok

Question

I have an Advanced Query which when tested, returns data within seconds, but when test deployed with the same parameters it returns a time out error. I have tried to extend the time out value to 60 second but no effect.

How to troubleshoot this one?

Version 9.1.300.0

22 Mar 2016

Guilherme Pereira

Staff

Hi Staley,

Without further context is hard to "guess" why. One common issue is if before executing the query you have some sort of lock on the table (for example if you call a webservice that inserts a record there which is using a different transaction).

i'd recommend you checking with your DBA if you have any locks and try to identify the source of those if present.

Hope this helps,
Guilherme

23 Mar 2016

Ivo Gonçalves

Hi Stanley,

To complement what Guilherme mentioned, please have a look on the following post:

https://www.outsystems.com/forums/discussion/15702/tip-performance-of-query-in-outsystems-platform-slower-than-running-in-database/

There you have additional information on how to troubleshoot this kind of issues.

Kind regards,
Ivo Gonçalves

24 Mar 2016

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines