A time-out occurs when you import large customization files into Microsoft Dynamics CRM 3.0 (918609)


The information in this article applies to:

  • Microsoft CRM 3.0
Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry

SYMPTOMS

When you import large customization files into Microsoft Dynamics CRM 3.0, a time-out occurs. Additionally, you receive one of the following error messages.

Error message 1
Import timeout error.
Error message 2
Maximum request length exceeded.
If the DevErrors value is set to "On" in the Web.config file, you receive the following error message:
Microsoft CRM Platform Error Report:
Error Description:
Timeout expired
Error Details:
Details on this error have not been provided by the platform.
Error Number: 0x80040E31

CAUSE

This problem occurs because one of the following conditions is true:
  • The time that is used for importing the customization files exceeds the default Microsoft Dynamics CRM OLEDBTimeout value for the Microsoft SQL server.
  • The time that is used for importing the customization files exceeds the ExtendedTimeout value that is used for long-running operations.

    Note Importing customization files can be a long-running operation.
  • The size of the Customization.xml file is larger than 7.5 megabytes (MB).

    Notes
    • The Customization.xml file is created when you export custom entities.
    • By default, Microsoft ASP.NET limits the HTTP request size to 8 MB.

RESOLUTION

To resolve this problem, use one of the following methods.

Method 1: Add the OLEDBTimeout and the ExtendedTimeout registry subkeys to increase the time-out values

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
  1. Click Start, click Run, type regedit, and then click OK.
  2. Locate the following registry subkey:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM

  3. Right-click MSCRM, point to New, and then click DWORD Value to create a new DWORD value.
  4. Rename the DWORD value to the following value:

    OLEDBTimeout

  5. Right-click the DWORD value, and then click Modify.
  6. In the Edit DWORD Value dialog box, type 300 in the Value data box, and then click OK.

    Note According to the requirement of the SQL server and the number of customization files, the value can be larger than 300.
  7. Right-click MSCRM, point to New, and then click DWORD Value to create a new DWORD value.
  8. Rename the DWORD value to the following value:

    ExtendedTimeout

  9. Right-click the DWORD value, and then click Modify.
  10. In the Edit DWORD Value dialog box, type 1000000 in the Value data box, and then click OK.

    Note In the Value data box, you can type a value that is larger than 1000000.

Method 2: Modify a parameter in two different Web.config files

  1. Click Start, click All Programs, click Administrative Tools, and then click Internet Information Services (IIS) Manager.
  2. Expand the server name, and then expand Web Sites.
  3. Right-click the Microsoft CRM v3.0 Web site, and then click Open.
  4. Right-click the Web.config file, click Open With, and then click Notepad.
  5. In Notepad, locate the following line.
    <httpRuntime executionTimeout="300" maxRequestLength="8192"/>
  6. Increase the "8192" value to a value that is large enough to handle the Customization.xml file.
  7. Save and then close the Web.config file.
  8. In the directory in which you opened the Web.config file, open the MSCRMServices folder.
  9. Right-click the Web.config file, click Open With, and then click Notepad.
  10. In Notepad, locate the following line.
    <httpRuntime maxRequestLength="8192"/>
  11. Change the "8192" value to the value that you specified in step 6.
  12. Save and then close the Web.config file.

MORE INFORMATION

The OLEDBTimeout value

The unit of the OLEDBTimeout value is seconds. By default, the OLEDBTimeout value is 30 seconds. The OLEDBTimeout value controls the SQL time-out value that is used for a single SQL query. The increased OLEDBTimeout value is useful when the SQL server is overloaded. Additionally, the query takes a longer time to process.

The ExtendedTimeout value

The unit of the ExtendedTimeout value is milliseconds. By default, the ExtendedTimeout value is 1000000 milliseconds. The ExtendedTimeout value controls the ASP.NET time-out value that is used for import requests. The time-out value must be larger than the time for finishing the whole import process. The increased ExtendedTimeout value is useful when the import process takes a long time.

Note When the performance of the SQL server is slow or when there are many customization files to import, the import process takes a long time.
Modification Type:MajorLast Reviewed:6/26/2006
Keywords:kbMBScustomization kberrmsg kbtshoot kbMBSMigrate kbprb KB918609 kbAudEndUser kbAudKnowledgeWorker
©2004 Microsoft Corporation. All rights reserved.