Hi,
While executing DB query in Automation Studio of Community Edition, i am facing following error:
“execution timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding”
Is it because the query is taking lot of time(40-50sec) to execute? I am not able to figure it out. Please help me out.
Hi Mayank,
In the main folder of Automation Studio, there is a configuration file named “Automation Studio.exe”, Open this file and search for “StudioSearchTime” parameter. The time consider here is in miliseconds. Increase it according to your requirements and save the file and start the studio again.
Hope this will solve your problem.
Regards,
Shubham.
Hi Shubham,
I have already increase “StudioSearchTime” and all other parameters. Web applications and everything else is working fine, this problem is only in case of “Execute DB Query”. No matter what is the value of StudioSearchTime parameter Execute DB Query activity only runs for about 30 sec and then gives the error.
Hi,
DB query time out cannot be changed as of Rel 18.0 community edition. Its default time out is 30 sec
Option to configure DB query time is available in latest Enterprise edition
Regards,
Amit Anand
