Command Timeout not working

Asked Feb 13 '17 at 16:03

Active Feb 13 '17 at 16:03

Viewed 548 times

I am using Entity Framework to communicate with SQL Server. I set connection timeout = 36000 in connection string, then set command Timeout = 36000 for EF context object. I also set this line in web config.

<httpRuntime executionTimeout="36000" />

I also set timeout = 28800 like this.

<authentication mode="Forms">
            <forms loginUrl="~/view/login/Login.aspx" timeout="28800" defaultUrl="~/view/login/WellComePage.aspx"/>
        </authentication>

After setting this all, i fetch data from db. It works fine for small data, but for long queries i got following message after 44 seconds. Although i didn't set 44 anywhere.

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

Any idea what i am doing wrong here.

asked Feb 13 '17 at 16:03

Waqas Ali

1,441
2
20
25

check out this :http://stackoverflow.com/questions/10649843/how-to-increase-executiontimeout-for-a-long-running-query – TheGameiswar Feb 13 '17 at 16:05
Did you have tried to increase the timeout to for example 2 mintues, just to insure that the Connection does not need more time, otherwise your can you go into debug to see where exactly the code is stuck. – Bassam Alugili Feb 13 '17 at 17:11
@TheGameiswar Already checked that link, not worked for me. – Waqas Ali Feb 14 '17 at 07:26
@Bassam Alugili I set both connection and command timeout to 36000. But this didn't impact on execution timeout error. – Waqas Ali Feb 14 '17 at 07:27
where did you do that? in the Connection string you cannot set the command timeout?! you must do that somewhere in the code? – Bassam Alugili Feb 17 '17 at 08:15
Yes, i set command timeout in code. – Waqas Ali Feb 17 '17 at 10:10

Command Timeout not working

0 Answers0