Dynamics Community Forum Thread Details

Dynamics 365 Online Customer Engagement : SQL Timeout while changing Business unit of a User, owning around 4 million records.

I am getting SQL Timeout when I am trying to change the business unit of a user from BU1 (parent BU) to BU 2 (child BU) in Dynamics 365 CRM 9.0.2. This user is owning around 4 million account records. As this is an online instance, how we can handle this scenario and move a user from one BU to another.

Can Microsoft help here, let's say increase SQL Timeout setting or can increase OLEDBTimeout registry setting in Online servers? Have anyone tried this in past?

Error Exception:

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: #02F75AF3Detail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ActivityId>d43526bd-61da-4d8f-aeb0-5967a88bd0c2</ActivityId>
<ErrorCode>-2147220970</ErrorCode>
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #02F75AF3</Message>
<Timestamp>2018-08-24T17:08:10.0203512Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil="true" />
<InnerFault>
<ActivityId>d43526bd-61da-4d8f-aeb0-5967a88bd0c2</ActivityId>
<ErrorCode>-2147204783</ErrorCode>
<ErrorDetails xmlns:d3p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>SQL timeout expired.</Message>
<Timestamp>2018-08-24T17:08:10.0203512Z</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>