SQL Connection Errors in Microsoft Azure

Question

We have entity framework implemented in our Web API 2.0 code. To call database entities, we are using store procedure calls. Our entire application is hosted in Microsoft Azure cloud. Here are the two exception which we are facing.

Message : An error occurred while executing the command definition. See the inner exception for details.

InnerException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. This failure occured while attempting to connect to the Principle server.

One more exception we are facing is like:

Message : The underlying provider failed on Open.

InnerException: The connection was not closed. The connection's current state is connecting.

Note: Code is in C# Web API 2.0. We are using Entity Framework to call Store Procedure. Database is in SQL Server 2012. In web.config, the connection string looks like below:

  <add name="*****Entities" connectionString="metadata=res://*/Models.Database.*****.csdl|res://*/Models.Database.*****.ssdl|res://*/Models.Database.*****.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=*****;Failover Partner=*****;initial catalog=*****;user id=*****;password=********;MultipleActiveResultSets=True;Pooling=false;Connection Lifetime=2;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

Also, this errors are not continuous, we guess this might be happening either network issues or while heavy traffic. But we are still not having any firm cause about this.

Please guide us with a solution for the same.

Sascha Dittmann · Accepted Answer · 2016-01-20 10:43:52Z

3

This looks like Transient Fault error to me. You should use EF6 (or later) and setup the Execution Strategies.

answered Jan 20, 2016 at 10:43

Sascha Dittmann

6364 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Mrunal Over a year ago

What does it mean by Transient Fault error? Btw am using EF version 5.0.0.0 in my project.

Sascha Dittmann Over a year ago

When cloud-based applications use other cloud-based services, errors can occur because of temporary conditions such as intermittent service, infrastructure-level faults, or network issues. Very often, if you retry the operation a short time later (maybe only a few milliseconds later) the operation may succeed. These types of error conditions are referred to as transient faults.

Mrunal Over a year ago

Thanks for the information @Sascha. So how to handle or deal with this type of errors? Is there any documentation or coding/architectural guidelines available? Everyone who has setup Azure - are facing such errors ?

Sascha Dittmann Over a year ago

Have a look here: msdn.microsoft.com/en-us/library/hh680901(v=pandp.50).aspx

Collectives™ on Stack Overflow

SQL Connection Errors in Microsoft Azure

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related