Hi 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:
Hi Darragh,
For such questions, it's more effective to create and submit an incident from your tenant, so that support team can look into actions, exceptions and logs and advise you on the solution
Br
Elena
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156