Recently i could see the below error in Event viewer by CRMAsync service,
Host : error while processing organization ca066e43-8b23-e911-8102-005056a94d0d. Exception: 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
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.ChangeDatabaseInternal(String database)
at System.Data.SqlClient.SqlInternalConnection.ChangeDatabase(String database)
at System.Data.SqlClient.SqlConnection.ChangeDatabase(String database)
at Microsoft.Crm.MultiOrgConnectionSupportBehavior.HandleOpen(IDbConnection connection, Guid organizationId)
at Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection()
at Microsoft.Crm.CrmDbConnection.Open()
at Microsoft.Crm.Asynchronous.DataAccessSharedBase.ExecuteNonQuery(IDbCommand command)
at Microsoft.Crm.Asynchronous.DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
at Microsoft.Crm.Asynchronous.AsyncOperationQueueDataAccess.<>c__DisplayClassd.<MoveSuspendedToReady>b__b(IServiceOperation operation)
at Microsoft.Crm.Asynchronous.Operations.OrganizationOperation.<get_EventAction>b__0(IServiceOperation operation)
ClientConnectionId:e227c7ca-eag3-48d9-a4e2-038271b870gd
Error Number:121,State:0,Class:20
My CRM gets time out after 15-20 mins.
After reading few articles i got to know its a timeout error .
kindly suggest me to fix this issue and increase the timeout for minimum 8 hours.
Note:im working on Dynamics crm 2016 onpremise
*This post is locked for comments
Hi DivyaShankar ,
You may try below steps
1) Log on to the CRM Server
Open IIS
Navigate to Sites
Select Microsoft Dynamics CRM Site
Right Click , Manage websites ,Advance Settings, Limits
Connection Time-out (seconds) generally it is 120
change the value as per your requirement.
if possible Reset CRM App Pool.
incase above not help to resolve the problem , plese try below MS URL
hope this will help you.
Thank you.
Abarao Bhople
Hi, It is a SQL timeout issue where particular query takes more (more than allocated) time to execute.
Did you try to isolate the issue, which specific scenarios it occurs?
You can check DBCC commands which will help you check the health of your SQL server DB.
docs.microsoft.com/.../dbcc-transact-sql
Additionally you can check how to increase the timeout. (warning its a very old post)
eastoceantechnical.blogspot.com/.../timeout-during-heavy-loaded-tasks-on.html
Regards,
Pranav
If found useful, please mark the answer as verified
Mohamed Amine Mahmoudi
83
Super User 2025 Season 1
Community Member
54
Victor Onyebuchi
6