Execution Timeout Expired

Question

User1203305613 posted

Hi All,

The Query execution in .NET aspx application is failing nearly after 30 seconds.The web.config remains same but we know for sure the application has been moved to new IIS.

Could you please point me out to the appropriate settings in IIS where we could increase the timeout

Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Thanks,

Kalyan

Answer 1

User-943250815 posted

Until you discover why query is taking so long time, you can set timeout on web.config Connection String adding "Connection Timeout=<max seconds to wait>"
https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectiontimeout?redirectedfrom=MSDN&view=netframework-4.7.2#System_Data_SqlClient_SqlConnection_ConnectionTimeout

Answer 2

User-1038772411 posted

I) Connection timeout setting

For IIS 6.0 :
1.On the Web server, click Start, point to Control Panel, point to Administrative Tools, and then click Internet Information Services (IIS) Manager. 
2.Expand the local computer node, expand Web Sites, right-click the appropriate Web site, and then click Properties. 
3.Click the Web Site tab.
4.In the Connections area, change the value in the Connection timeout field, and then click OK.

For IIS 7.0 / IIS 7.5 :
1.On the Web server, click Start, point to Control Panel, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
2.Expand the local computer node, expand Web Sites, right-click the appropriate Web site, point to Manage Web Site, click Advanced Settings. 
3.In the Advanced Settings window, expand Connection Limits, change the value in the Connection time-out field, and then click OK.

Answer 3

User-893317190 posted

Hi KALYANA ALLAM,

You could also set executiontimeout property in web.config's httpRuntime node.

<httpRuntime  executionTimeout = "your time" />

Please refer to https://stackoverflow.com/questions/10649843/how-to-increase-executiontimeout-for-a-long-running-query

Best regards,

Ackerly Xu