SqlException - A transport-level error has occurred when receiving results from the server

asp.net-mvc-5 c# entity-framework-6 hangfire sqlexception

Question

I am coding a MVC 5 internet application and I have a recurring task that executes every hour. This task updates some model objects using a DbContext class. The application is deployed as an Azure website.

I am getting the following error every few hours:

System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) ---> System.ComponentModel.Win32Exception (0x80004005): The semaphore timeout period has expired

Why is this? Also, how can I prevent this from happening?

Thanks in advance.

1
4
3/26/2015 6:41:53 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Basically the error is being thrown by the network layer and SQL server is just reporting it.

0
2/1/2016 8:52:11 AM

Related Questions

SQL Server Compact does not allow keys and values produced by the server.

When I hit this limitation, I changed the type to uniqueidentifier
compact-framework entity-framework
asked by mostlytech

WCF - An error occurred while receiving the HTTP response to http://xxxxx/Service/

Found the root cause after a lot of swearing and thinking of how nice the weather is outside. I remove the virtual keyword from the UserDetails object that is inside the User object....Now it works!...As far as why this caused an issue, my assumptions are serialization or DbContext issues, but I will have to look more into it, not sure....I'm going...
c# ef-code-first entity-framework wcf
asked by ledgeJumper

A network-releated or instance-specific error occurred while establishing a connection to SQL Server

Add a ...<clear/>... element as the first element under the connectionstrings element to ensure no strings are being inherited. Also, I assume your Azure SQL DB is set up with proper firewall settings allowing your IP where the ASP.net code is deployed?
asp.net-mvc azure-sql-database azure-web-roles connection-string entity-framework
asked by Bart Czernicki

Entity Framework with SQLite Error: An error occurred while reading from the store provider's data reader

The problem was caused by multiple thread that query the db using the same DBContext....Using a different DBContext for each thread solve the problem....In my case I was using Castle Windsor to inject the DBContext into the class that perform the query. Configuring the lifestyle of the DBContext to one per thread the problem has gone.
.net-4.5 c# entity-framework sqlite wpf
asked by abrfra

Running update-database results in the error: "A file activation error occurred"

This is the problem:...AttachDbFilename=|DataDirectory|\Pbn.mdf ...That's being interpreted as \Pbn.mdf, and it doesn't exist. This is because you aren't setting the |DataDirectory| value, so it's blank. See ...here... on how to set it.
database entity-framework entity-framework-6 visual-studio
asked by simon at rcl

System.Data.SqlClient.SqlException' occurred in EntityFramework.dll but was not handled in user code

I download SqlLocalDb and installed it, this solve my problem. This link ...connection to local db failed 52... helped me.
asp.net-mvc c# entity-framework sql-server
asked by Ales

A transport-level error has occurred (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)

Make sure the user/login you use on your connection string has access to the master database on your Azure SQL Database server also, not only to the user database. That will provide faster connections and timeouts may disappear....Using SQL Azure Execution Estrategy may help you with this issue....public class MyConfiguration : DbConfiguration { ...
azure-sql-database c# enterprise-library entity-framework-6
asked by Alberto Morillo

Connection String Issue: System.Data.SqlClient.SqlException (0x80131904) - Unable to connect to SQL Server Management Studio

Pretty sure by default EF looks for ...DefaultConnection... connection name on your web.config. Someone can correct me if I'm wrong....You need to override the connection name via ...:base()... on your ...DbContext... class....public class BolgDbContext : DbContext { public BolgDbContext() : base("name=BlogDbContext") { } public DbSet<Post>...
c# entity-framework-6
asked by penleychan

Receiving 500 internal server error even though I receive data from LINQ

In the action ...GetFood... you specified that the return type is ...Food.... By default the EntityFramework generate proxy objects around your entities for lazy-loading. ...Meaning that the line:... Food food = db.Foods.Find(id); ...Will not return a ...Food... object, but a dynamic subclass of food. This can also be seen in the error you posted i...
asp.net-web-api c# entity-framework-6 https
asked by RMH

Entity Framework 6 BulkInsert receiving an invalid column length from the client SQL SERVER 2012 Express

The ...SaveChanges... use a SqlCommand. If the name is longer than the database limit, it will silently be truncated, so no error will be thrown....The ...BulkInsert... use a ...SqlBulkCopy..., if the name is longer than the database limit, an error will be thrown....That explain why you get an error in one case and none in the other case....SqlBul...
c# entity-framework-6 sql-server-2012-express
asked by Jonathan Magnan

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow