Dynamics Community Forum Thread Details

SQL time out exceptions seen during the Data import. (CRM 2016 On-Premise)

Hi Experts,

What are the best practices to prevent the SQL time out exceptions seen during the Data import ?

In CRM 2016 data import file limit extended to 32MB, in my case sometime data import stuck for a long time even keeping file size under the limit. So how can we handle this while working on a large project, where we cann't ask another user to keep there activity (i.e. data import/export/console app run etc) on hold.

Is any monitor tool or SQL Script available to monitor this. How you people deal with the same situations while working on nay Large Project, please share your experience.

Following is the exception details :

Message : Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Exception :

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: SQL timeout expired.Detail: 
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
  <ErrorCode>-2147204783</ErrorCode>
  <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
  <Message>SQL timeout expired.</Message>
  <Timestamp>2017-09-30T03:59:56.2170386Z</Timestamp>
  <InnerFault>
    <ErrorCode>-2147220970</ErrorCode>
    <ErrorDetails xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
    <Message>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #EAF7F7D2</Message>
    <Timestamp>2017-09-30T03:59:56.2170386Z</Timestamp>
    <InnerFault>
      <ErrorCode>-2147220970</ErrorCode>
      <ErrorDetails xmlns:d4p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
      <Message>System.ComponentModel.Win32Exception: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #E660CAFB</Message>
      <Timestamp>2017-09-30T03:59:56.2170386Z</Timestamp>
      <InnerFault i:nil="true" />
      <TraceText i:nil="true" />
    </InnerFault>
    <TraceText i:nil="true" />
  </InnerFault>
  <TraceText i:nil="true" />
</OrganizationServiceFault>

Thanks

Quick Links

Leaderboard