@Ayush Mishra  In addition to the query timeout on the SQL action, have you also increased your timeouts in Service Center?

Additionally, the IIS configuration machine.config under the httpRuntime section has executionTimeout. Make sure you have bumped this one up as well. Documentation For that here: https://success.outsystems.com/support/troubleshooting/application_runtime/timeouts_under_the_hood/ 

Finally, some modules also have module-wide timeout settings set as well, you should also verify that those are not lower than the others.

Hi Ayush, 

I think you need to check your query itself and try to optimize it by adding some indexes to tables you query or add more conditions to narrow range of records that matching your case. 

Also you can use SQL profiler with help from database team and run your query and see execution plan and analysis where is the bottleneck that makes query take long time.