6 Antworten zu diesem Thema

[venkatesh.r]

Hi,

 

           My site is frequently showing this exception. Kindly give any solution to this problem.

 

Exception Message:  

 

System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out

 

 

 

 

[Marcus Gesing]

1. to find the exact cause... does it accur when executing "System > Maintenance > Deleting guest customers > Delete"?

2. to fix it... try to increase command timeout in web.config (app setting "sm:EfCommandTimeout").

[venkatesh.r]

Thank for your quick response admin.This exception occured every page loading.if i go to category page it will take long time and exception throws like 

 

System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out

[venkatesh.r]

I got this type of errors in my site.

 

Controller: Product, Action: ProductDetails

An error occurred while updating the entries. See the inner exception for details.

An error occurred while updating the entries. See the inner exception for details.

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

The wait operation timed out

[Marcus Gesing]

This sounds as if your SQL server does not respond to database queries at all or does not do so in the intended time (timeout).

[venkatesh.r]

Thank you admin.Now what we do to fix this error.

[Parameswari]

On analysing the activity monitor in SQL, Network I/O has huge wait time and there are deadlocks as well on sp_who2 in the database, 
Kindly help to resolve the same ASAP.

Festive season on and site getting closed abnormally often