Hi,
We are using OutSystems managed cloud environment. We are facing SQL query timeout issue.
Advanced SQL Timeout is default set to -> Module Default Timeout
We have set Module Server Request Timeout as 240 seconds.
Our SQL query is always getting timed out after 1.5 mins. What's the module default timeout?
Best Regards,
Nitin
You need to Open support ticket for Outsystems and they Can change it on configuration tool.
But if is only in This query I suggest you to Change ONLY here
Hi Nitin,
You can manually remove the "module default timeout" and place you desired timeout in sec. But you have to do it for the SQL as well as the sever action that has the SQL .
But obviously this is not a good approach. You can use BPT to process such large data. Otherwise you should utilize the max records attribute in SQL.
Hope this might help you.
Thanks & Regards,
Sudip Pal
Thanks @Sudip Pal !
Does "Modules Default Timeout" is same as "Server Request Timeout" set for module?
As we have set 240 secs (4 Mins) timeout for module "Server Request Timeout" ,
but the SQL query is always getting timed out after 1.5 mins.
In your case, you have set "Server Request Timeout" is 4 mins but SQL query is timed out after 1.5 mins. So, it means they are different.
First of all it is interesting to find where this value 1.5 min is comming from.
I am trying to guess that it is configured in Configuration Tool, in your case it is 90 sec.
Doc Configuration tool
I suggest you to try to optimize the query, since 1.5min running one query is not a good practice.
Hope it helps you.
Thanks
Luís Dinis
Thanks @Luis Dinis !
I am also interested to find where the value 90 sec. is configured.
We are using OutSystems managed cloud and Configuration tool is only available for self managed infrastructures.
This is specific large data scenario. We have tried optimizing the database query, but we have 40 million records with SQL join of 7 tables.