Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

A SQL Server Timeout may occur when changing a name field for a Microsoft Dynamics CRM User


View products that this article applies to.

Symptom

An Administrator is unable to make changes to a user record in Microsoft Dynamics CRM 2011 and receives a generic SQL Server error message. 

↑ Back to the top


Cause

This can be caused by the user owning a high number of related records that need to be updated in the ActivityPartyBase table in the Microsoft Dynamics CRM organization database

↑ Back to the top


Resolution

Increase the HKLM\Software\Microsoft\MSCRM\OLEDBTimeout to a higher value either on a temporary basis or permanent basis on the Microsoft Dynamics CRM Server.

Create or change the OleDbTimeout value
  1. In Registry Editor, locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
  2. Double-click the OleDbTimeout value

    Note If the OleDbTimeout value does not exist, create an OleDbTimeout value. To do this, follow these steps:
    1. Right-click MSCRM, point to New, and then click DWORD value
    2. Type OleDbTimeout
  3. In the Edit DWORD Value dialog box, click Decimal, type 600 in the Value data field, and then click OK.

    Note The value of 600 represents 600 seconds. By default, the value is 30 seconds. Also note that if required on a temporary basis to allow this operation to complete, you may need to set this to 86400 which is equivalent to a value of 24 hours.

NOTE: It's recommended to run with the OLDDBTimeout setting set to a value between 30 to 600 decimal as a best practice to help minimize excessive SQL Blocking that a long running or expensive query may cause.

↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 2637855
Revision : 1
Created on : 1/7/2017
Published on : 7/20/2012
Exists online : False
Views : 207