Click here to Skip to main content
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 CPallini 365
1 Sergey Alexandrovich Kryukov 252
2 OriginalGriff 165
3 George Jonsson 159
4 Richard MacCutchan 110
0 OriginalGriff 6,344
1 Sergey Alexandrovich Kryukov 5,860
2 CPallini 5,125
3 George Jonsson 3,559
4 Gihan Liyanage 2,522


Advertise | Privacy | Mobile
Web02 | 2.8.140916.1 | Last Updated 6 Jan 2013
Copyright © CodeProject, 1999-2014
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