Exception Timeout Expired

Question

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 21-Jul-12 2:14am

Sweetynewb

Updated 21-Jul-12 2:37am

v2

Add a Solution

2 solutions

Solution 2

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[^]

Posted 21-Jul-12 5:34am

Ganesh Kumar Kaki

Updated 21-Jul-12 5:40am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Sandeep Mewara · Accepted Answer · 2012-07-21T03:38:00

Solution 1

What about HTTP request timeout? (By Web.config, I think you must have just tried session timeout and not httpruntime)

HTML

<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)

Posted 21-Jul-12 3:38am

Sandeep Mewara

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.