Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Issue with when trying to add contacts to a Marketing List,

(0) ShareShare
ReportReport
Posted on by

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:

  1. Is this the correct registry setting?
    1. If not what is the correct setting/configuration
  2. Is there a limit imposed by Dynamics CRM for that operation
  3. Do we need to increase the hardware specification of the SQL server and/or CRM server to get the higher numbers
  • Suggested answer
    Petit Hibou Profile Picture
    Petit Hibou on at
    RE: Issue with when trying to add contacts to a Marketing List,

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans