I am using the WCF Restfull service Application contains Entity Data Model Framework. when i perform any CRUD operations am getting the below error
" Even i increase the ConnectTimeout in web.config, not resolve the issue How to increase the CommandTime out value in SQL server DB instance"
Timestamp: 1/31/2013 3:39:02 AM
Message: HandlingInstanceID: f6f018b5-b1fd-4961-8d13-8f0ad2ad9534 An exception of type 'System.Data.UpdateException' occurred and was caught. --------------------------------------------------------------------------- 01/30/2013 19:39:02 Type : System.Data.UpdateException,
System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : An error occurred while updating the entries. See the inner exception for details. Source : System.Data.Entity Help link : StateEntries : System.Collections.ObjectModel.ReadOnlyCollection`1[System.Data.Objects.ObjectStateEntry]
Data : System.Collections.ListDictionaryInternal TargetSite : Int32 Update(System.Data.IEntityStateManager, System.Data.IEntityAdapter) Stack Trace : at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter
adapter) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Services.Providers.ObjectContextServiceProvider.SaveChanges() at System.Data.Services.DataService`1.HandleNonBatchRequest(RequestDescription description)
at System.Data.Services.DataService`1.HandleRequest()
Additional Info:
MachineName : CO1CSMIIS04 TimeStamp : 1/31/2013 3:39:02 AM FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=5.0.414.0, Culture=neutral, PublicKeyToken=dd1af7c40ea4b84a AppDomainName : /LM/W3SVC/1/ROOT/SalesManagement-1-130039752339138017
ThreadIdentity : REDMOND\gmowwlm WindowsIdentity : NT AUTHORITY\NETWORK SERVICE Inner Exception --------------- Type : System.Data.SqlClient.SqlException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : Timeout
expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Source : .Net SqlClient Data Provider Help link : Errors : System.Data.SqlClient.SqlErrorCollection ClientConnectionId : b6ef5b36-f2b8-4fff-b148-624ae0748f66
Class : 11 LineNumber : 0 Number : -2 Procedure : Server : EDMSQL.partners.extranet.microsoft.com State : 0 ErrorCode : -2146232060 Data : System.Collections.ListDictionaryInternal TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)
Stack Trace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Data.Mapping.Update.Internal.FunctionUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues,
List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
None
0 Points
31 Posts
Getting Timeout Exception
Jan 31, 2013 06:00 AM|RavishankarReddy|LINK
Hi All,
I am using the WCF Restfull service Application contains Entity Data Model Framework. when i perform any CRUD operations am getting the below error
" Even i increase the ConnectTimeout in web.config, not resolve the issue How to increase the CommandTime out value in SQL server DB instance"
Timestamp: 1/31/2013 3:39:02 AM
Message: HandlingInstanceID: f6f018b5-b1fd-4961-8d13-8f0ad2ad9534 An exception of type 'System.Data.UpdateException' occurred and was caught. --------------------------------------------------------------------------- 01/30/2013 19:39:02 Type : System.Data.UpdateException, System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : An error occurred while updating the entries. See the inner exception for details. Source : System.Data.Entity Help link : StateEntries : System.Collections.ObjectModel.ReadOnlyCollection`1[System.Data.Objects.ObjectStateEntry] Data : System.Collections.ListDictionaryInternal TargetSite : Int32 Update(System.Data.IEntityStateManager, System.Data.IEntityAdapter) Stack Trace : at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Services.Providers.ObjectContextServiceProvider.SaveChanges() at System.Data.Services.DataService`1.HandleNonBatchRequest(RequestDescription description) at System.Data.Services.DataService`1.HandleRequest()
Additional Info:
MachineName : CO1CSMIIS04 TimeStamp : 1/31/2013 3:39:02 AM FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=5.0.414.0, Culture=neutral, PublicKeyToken=dd1af7c40ea4b84a AppDomainName : /LM/W3SVC/1/ROOT/SalesManagement-1-130039752339138017 ThreadIdentity : REDMOND\gmowwlm WindowsIdentity : NT AUTHORITY\NETWORK SERVICE Inner Exception --------------- Type : System.Data.SqlClient.SqlException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Source : .Net SqlClient Data Provider Help link : Errors : System.Data.SqlClient.SqlErrorCollection ClientConnectionId : b6ef5b36-f2b8-4fff-b148-624ae0748f66 Class : 11 LineNumber : 0 Number : -2 Procedure : Server : EDMSQL.partners.extranet.microsoft.com State : 0 ErrorCode : -2146232060 Data : System.Collections.ListDictionaryInternal TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean) Stack Trace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Data.Mapping.Update.Internal.FunctionUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
Category: General
Priority: 0
EventId: 9000
Severity: Error
Title:Enterprise Library Exception Handling
Machine: CO1CSMIIS04
App Domain: /LM/W3SVC/1/ROOT/SalesManagement-1-130039752339138017
ProcessId: 1620
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Thread Name:
Win32 ThreadId:6972
Extended Properties:
All-Star
94130 Points
18111 Posts
Re: Getting Timeout Exception
Feb 01, 2013 09:35 PM|Decker Dong - MSFT|LINK
Hi,
Just please do setting for the property of SqlCommand.ConnectionTimeOut = a larger value.
For more you can see this demo:
http://msdn.microsoft.com/en-US/library/vstudio/system.data.sqlclient.sqlcommand.commandtimeout.aspx