Click here to Skip to main content
14,732,983 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All,

I got below exception while running report.
I wrote stored procedure in sql server 2005 and it taking much more time.
I am fetching more than 1000 rows from database. My website is in C# asp.net. I have tried to set commandTimeout parameter but no luck.

Even i set Max pool Size, pooling parameters in Web.config file but still it gives below exception.

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


Waiting for any suggestions
Posted
Updated 21-Jul-12 3:37am
v2

What about HTTP request timeout? (By Web.config, I think you must have just tried session timeout and not httpruntime)
<httpruntime enable="true" maxrequestlength="10240" executiontimeout="360" />


Checkout following blog entry: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.[^]

Further, you sure it's not commandtimeout? (default 30 sec)
   
Comments
Sweetynewb 23-Jul-12 0:58am
   
Okay but i am extracting report. And stored procedure execution time is 4 mins. User can not wait for 4 mins to view report. Is it possible to fetch more than 1000 in less time? And so that user also get faster response?
Sandeep Mewara 23-Jul-12 1:46am
   
If your SP is taking 4 min... it has to be timeout... either connection or command or request. Please do as suggested and see how it works.
Sweetynewb 23-Jul-12 2:26am
   
Thanks for your suggestion. I changed my SP added some conditions and it worked perfect for me
:)
Sandeep Mewara 23-Jul-12 4:06am
   
Welcome.

For Instant help increase the timeout value to a max.. may it helps you
This is the only way I knew..sorry

Follow the link for clear understatement

http://stackoverflow.com/questions/3977219/sql-server-c-timeout-exception-on-transaction-rollback[^]
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900