Share
ReportHi all,
One of our customers has a Dynamics 365 CRM instance and are experiencing an issue when trying to add contacts to a Marketing List, the details are as follows:
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #1702D4B3Detail:
<OrganizationServiceFault xmlns:i=http://www.w3.org/2001/XMLSchema-instance xmlns=http://schemas.microsoft.com/xrm/2011/Contracts>
<ActivityId>2c4c81bd-f60a-45f3-b32d-523ecfddb1c7</ActivityId>
<ErrorCode>-2147220970</ErrorCode>
<ErrorDetails xmlns:d2p1=http://schemas.datacontract.org/2004/07/System.Collections.Generic />
<Message>System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #</Message>
<Timestamp>2021-03-17T17:07:45.1516523Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil="true" />
<InnerFault>
<ActivityId>2c4c81bd-f60a-45f3-b32d-523ecfddb1c7</ActivityId>
<ErrorCode>-2147204783</ErrorCode>
<ErrorDetails xmlns:d3p1=http://schemas.datacontract.org/2004/07/System.Collections.Generic />
<Message>SQL timeout expired.</Message>
<Timestamp>2021-03-17T17:07:45.1516523Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil="true" />
<InnerFault i:nil="true" />
<OriginalException i:nil="true" />
<TraceText i:nil="true" />
</InnerFault>
<OriginalException i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>
We have enabled CRM trace facility on the server and reproduced the error and we believe that the underlying fault is a SQL timeout
A search of the internet threw up a registry key to modify to increase the SQL timeout in the same place as the trace facility – OLEDBTimeout
It is noted that this change might have a detrimental effect on the user experience else where in the system and that the maximum value can be 86,400 the equivalent of 1 day
We set the timeout to 600 (seconds we understand) and this allows us to add ~7,700 contacts to a marketing list
Then trying to increase the number of contacts to add to 50,000 results in the error again, something that they were able to do with CRM 2011
Further increase in this registry value does not appear to have any effect on the timeout duration,
e.g. Setting the value to 900 the error still occurs after ~10 minutes
The questions we are wondering so we can report back to our customer are:
- Is this the correct registry setting?
- If not what is the correct setting/configuration
- Is there a limit imposed by Dynamics CRM for that operation
- Do we need to increase the hardware specification of the SQL server and/or CRM server to get the higher numbers
All responses (
Answers (
129
