Timeout expired. The timeout period elapsed prior to comple

Posted by Community Admin on 04-Aug-2018 12:05

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

All Replies

Posted by Community Admin on 06-Apr-2011 00:00

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              

Posted by Community Admin on 06-Apr-2011 00:00

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


Posted by Community Admin on 06-Apr-2011 00:00

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!
 

Posted by Community Admin on 08-Apr-2011 00:00

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.

Posted by Community Admin on 08-Apr-2011 00:00

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.

Posted by Community Admin on 08-Apr-2011 00:00

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


Posted by Community Admin on 10-Apr-2011 00:00

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?
 

Posted by Community Admin on 18-Apr-2011 00:00

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


Posted by Community Admin on 08-Jun-2011 00:00

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.

Posted by Community Admin on 08-Jun-2011 00:00

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
 

This thread is closed