Search code examples
sqlasp.netconnection

The wait operation timed out. ASP


I created an internal website for our company. It run smoothly for several months and then I made a major update due to user suggestion. When I run in live, it run normally. Then suddenly one of my user from japan sending me an "The Wait operation timed out." error. When I check access that certain link, It run normally for me and some other who I ask to check if they access that page. I already update the httpRuntime executionTimeout but still no luck. Is it the error come from database connection? If I increase the timeout in the database connection it will be fix the problem?


Solution

  • If you found the exact error "The wait operation timed out" then it is likely you have a database call that took longer than expected. This could be due to any number of things:

    1. Transient network problem
    2. High SQL server load
    3. Problem with SAN, RAID, or storage device
    4. Deadlock or other form of multiprocess contention

    You haven't shared enough information to troubleshoot. The way I would manage this would be to check for other occurrences of the problem and see if there is a pattern, e.g. if the problem occurs at a certain time of day.

    Certainly increasing the timeout is not a bad idea (if it is currently set pretty low) and may resolve the problem in and of itself.