Click here to Skip to main content
13,451,731 members (35,032 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Opertaion has Timeout

I m using (My own)WebMethods in My Project, when more hen 1 user access the showing error "Opertation has Timeout" on Login screen and 1 more place when have 5-6 tables joined in query, there showing "Server was unable to process request".
For this problem i tried may solutions
1.Added Connect Timeout=5000; pooling='true'; Max Pool Size=200; in Connection string.
2. Added in
<System Web><httpRuntime  executionTimeout="5000" maxRequestLength="2097151"/>

3.Added in my function SqlCommand.CommandTimeout=5000;
4.Increased "Remote Query Timeout" from Sql Server usinf sp_Configure.

But Still getting same issue, If any one knows, Please suggest me.
Thanks in advance.
Posted 5-Jan-13 0:25am
Updated 6-Jan-13 1:57am
Kalyan_A 6-Jan-13 9:23am
Setting timeout is useful only when you know that the process will finish in said time. Looks like you have locking issues with simultaneous access.

Identify the source of timeout/locks (DB or front-end) and fix the underlying problem. setting a large enough timeout without identifying the problem may be counter productive.


1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

The timeout is still pretty low. But, overall it sounds like your table design or SQL is very inefficient. You can try adding 'nolock' to your select statements, so they don't lock the tables, but I suspect a more complete redesign is needed, if you can't get two people to log in at once.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.180318.3 | Last Updated 6 Jan 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100