+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

10 posts, 0 answered
  1. Waqar
    Waqar avatar
    16 posts
    Registered:
    23 Nov 2010
    06 Apr 2011
    Link to this post

    Hello!
    I am getting the following error from the server. Actually I hosted 12 sites on server and trying to hit them together but some of the the open and some of them gives the following error.

    I tried to search out the solution and I found that Command time of SqlCommand Set To Zero Or change accordingly. But I can not access OpenAccess ORM Code.


    Please help me........Is there any solution in sitefinity 4.0?


    Server Error in '/' Application.

    Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: Telerik.OpenAccess.RT.sql.SQLException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    [SQLException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps) +613
       OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createRealCon() +219
    
    [DataStoreException: Unable to connect to Backend=mssql;Driver=genericADO2;Server=P2388277;Instance=SQLEXPRESS;Database=Jeep_Dealer2;Integrated Security=true;:
    Telerik.OpenAccess.RT.sql.SQLException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
       at OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createRealCon()
    DBDriver: Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver
    LOCK_TIMEOUT=5000
    useUTCForReads=1 Telerik.OpenAccess.RT.sql.SQLException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
       at OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createRealCon()]
       Telerik.OpenAccess.RT.ExceptionWrapper.Throw() +7
       OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createRealCon() +787
       OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createRealConWithRetry(Int32 retryCountParam, Int32 millis) +244
       OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createPooledConnection(Int32 retryCountParam, Int32 retryIntervalMsParam) +42
       OpenAccessRuntime.Relational.conn.RelationalConnectionPool.getConnection(Boolean highPriority, Boolean autoCommit, String smId) +595
       OpenAccessRuntime.DataObjects.tools.ant.SchemaMigrationTask.migrateDatabase() +270
    
    [OpenAccessException: Telerik.OpenAccess.Exceptions.DataStoreException: Unable to connect to Backend=mssql;Driver=genericADO2;Server=P2388277;Instance=SQLEXPRESS;Database=Jeep_Dealer2;Integrated Security=true;:
    Telerik.OpenAccess.RT.sql.SQLException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
       at OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createRealCon()
    DBDriver: Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver
    LOCK_TIMEOUT=5000
    useUTCForReads=1 Telerik.OpenAccess.RT.sql.SQLException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
       at OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createRealCon()]
       DynamicModule.ns.Wrapped_OpenAccessPageProvider_fedfe403f13e4eea83cc9cf62c7827a2.Initialize(String providerName, NameValueCollection config, Type managerType) +197
       Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +1477
       Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +63
       Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +161
       Telerik.Sitefinity.Data.ManagerBase`1..ctor(String providerName, String transactionName) +131
       Telerik.Sitefinity.Modules.Pages.PageManager..ctor() +35
       Telerik.Sitefinity.Modules.Pages.PageManager..cctor() +35
    
    [TypeInitializationException: The type initializer for 'Telerik.Sitefinity.Modules.Pages.PageManager' threw an exception.]
       Telerik.Sitefinity.Modules.Pages.PageManager.GetManager() +0
       Telerik.Sitefinity.Services.SystemManager.Initialize() +1070
       Telerik.Sitefinity.Abstractions.Bootstrapper.RegisterRoutes(RouteCollection routes) +229
       Telerik.Sitefinity.Abstractions.Bootstrapper.Bootstrap() +99
       Telerik.Sitefinity.Web.SitefinityHttpModule.Init(HttpApplication context) +24
       System.Web.Routing.UrlRoutingModule.System.Web.IHttpModule.Init(HttpApplication application) +10
       System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +431
       System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +194
       System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +339
       System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +253
    
    [HttpException (0x80004005): The type initializer for 'Telerik.Sitefinity.Modules.Pages.PageManager' threw an exception.]
       System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +8950644
       System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +97
       System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +256
    


    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1              
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    06 Apr 2011
    Link to this post
    Hello waqar,

    If this website uses separate application pool and SQL server can you replicate the issue? This looks like as a problem that comes from the SQL server that cannot handle the request.

    All the best,
    Ivan Dimitrov
    the Telerik team

  3. Waqar
    Waqar avatar
    16 posts
    Registered:
    23 Nov 2010
    06 Apr 2011
    Link to this post
    HI!
    Yes, I am using SQL SERVER and a separate application pool (Garden - 2 Worker process for 12 sites) and I am still getting similar error in 5 sites out of 12 site  when I open all 12 sites together.
    Please let me know what can I do to resolve this issues.

    Also what your suggestions are?
    If I am hosting 38 sites of sitefinity 4.0 and my server configuration is.
    Windows Server 2008 Standard
    2 MB RAM
    Intel Xeon X3450 @ 2.76GHz (8Cpus)
    SQL SERVER 2008 (38 databases for each site)

    Right now I am using 4 Application pools with 2 worker process with each pool. Each App Pool has about 11 sites.
    When I open 12sites together physical memory uses become 1.9GB and 0 Free.

    So far I have told the entire Senior. Now I am looking for solution and the suggestions as well.
    Please reply me ASAP.

    Let me know if you want to ask any thing more

    Thanks!
     
  4. Waqar
    Waqar avatar
    16 posts
    Registered:
    23 Nov 2010
    08 Apr 2011
    Link to this post
    Can you given me answer please?

    I don't have enough time wait, I am about to buy license for sitefinity 4.0. I want answers of my questions.
  5. Waqar
    Waqar avatar
    16 posts
    Registered:
    23 Nov 2010
    08 Apr 2011
    Link to this post
    Any one there?
    I need answers as early as possible. because If the performance issue could not be resolved then I have to switch some other platform and will not purchase license of sitefnity 4.0.
  6. Vlad
    Vlad avatar
    498 posts
    Registered:
    15 Jul 2016
    08 Apr 2011
    Link to this post
    Hi waqar,

    We cannot say, that we don't have any performance issue, however we have addressed most of them in the upcoming Q1 release next week. Our testing results show, that we have improved the performance with more then 20 percentage. Some other performance improvements a planned for Q2.

    We want to help you to resolve the problem, but in order to do that, we need  to isolate it somehow. Are all of your web sites, which share the same application pool, are running on Sitefinity? Can you try to isolate the site that throws this exception in a separate application pool (only this site in the pool)?

    All the best,
    Vlad
    the Telerik team

  7. Waqar
    Waqar avatar
    16 posts
    Registered:
    23 Nov 2010
    10 Apr 2011
    Link to this post
    HI!
    Thanks for reply.

    Yes, All the sites in the application pool are on sitefinity. Now I have 40 sites on sitefinity with 6 different application pool and each pool is assigned 2 worker processes.
    Now you are saying to create a separate application pool for each site?
    As I have told you problem occurs only when I try to open more than 4 sites together even from same pool or different and of course in live version there will be a number of hits on the site at once So it should not gonna happen.
    Still my questions are same any solution?
     
  8. Vlad
    Vlad avatar
    498 posts
    Registered:
    15 Jul 2016
    18 Apr 2011
    Link to this post
    Hello waqar,

    We started doing some tests regarding your scenario. We plan to post the results of these tests when we collect enough information.
    However, we think that you have to upgrade your hardware in order to support so many web applications (even they are not in Sitefinity). Actually, the recommended RAM for a site is minimum 300 MB.

    We just released Sitefinity 4.1, you can try it, because it performs better.
    By the way, in Q3 2011 we plan to add multiple site management with a single administration. Maybe it will be the appropriate for you case.

    Greetings,
    Vlad
    the Telerik team

  9. Mark
    Mark avatar
    147 posts
    Registered:
    01 Jun 2010
    08 Jun 2011
    Link to this post
    Can someone from telerik post the results of your findings? I'm hosting 22 sites on 6 Application Pools with 2 workers per AppPool. The server has 6GB of memory and I'm running into timeouts as well.
  10. Stevo
    Stevo avatar
    20 posts
    Registered:
    09 Sep 2007
    08 Jun 2011
    Link to this post
    We had the same problem and here is how we fixed it.
    Note:  Both web server and sql server were on dedicated boxes. 

    Make sure all of your sites are in the same application pool. 
    set your sql time out in your connection string to a timeout of 200.
     add key="DBConnection" value="server=LocalHost;uid=sa;pwd=;database=DataBaseName;Connect Timeout=200; pooling='true'; Max Pool Size=200"/>

    Also, on heavy loaded sites, make sure your network / ethernet card is NOT set to autonigotiate.  If you are on a 100mb network, make sure to set the web server and sql server to 100mb full duplex.  If you have gig netowork, then set it to 1gb setting. Just make sure you know what speed your switch can handle.

    I would also look at rebuilding your sql db index.
    Not sure which one of these fixed it, but our sql server is running much faster with no timeouts. 
    Hope this helps.
    Steve
     
10 posts, 0 answered