Click here to Skip to main content
11,584,622 members (66,566 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET
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
Edited 6-Jan-13 1:57am
v2
Comments
Kalyan_A at 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.

Cheers

1 solution

Rate this: bad
good
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.
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 430
1 Sergey Alexandrovich Kryukov 367
2 Dave Kreskowiak 260
3 Richard Deeming 220
4 virusstorm 194
0 OriginalGriff 1,703
1 Sergey Alexandrovich Kryukov 1,267
2 Abhinav S 711
3 Dave Kreskowiak 687
4 Suvendu Shekhar Giri 568


Advertise | Privacy | Mobile
Web03 | 2.8.150707.1 | Last Updated 6 Jan 2013
Copyright © CodeProject, 1999-2015
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