A SQL Exception error is logged in the Microsoft SQL log when you try to import a customization XML file into Microsoft Dynamics CRM 3.0 (918437)

The information in this article applies to:

Microsoft CRM 3.0

SYMPTOMS

When you try to import a customization XML file into Microsoft Dynamics CRM 3.0, a SQL Exception error is logged in the Microsoft SQL log. Additionally, the import process fails. This problem occurs when the customization XML file that you try to import has the same attribute name as the same entity of another customization. However, both customizations have a different case sensitivity property.

CAUSE

This problem occurs because Microsoft Dynamics CRM considers these attributes that have a different case sensitivity property to be different attributes. Therefore, Microsoft Dynamics CRM creates a new attribute instead of updating an attribute.

RESOLUTION

To resolve this problem, contact Technical Support for Microsoft Dynamics. For information about technical support for Microsoft Dynamics CRM, visit the following Microsoft Web site:

http://www.microsoft.com/dynamics/support/default.mspx

The support professional will correct the customization XML file.

MORE INFORMATION

When you create an attribute in the Customization area in Microsoft Dynamics CRM, you can type the attribute name in the Name box. Then, the Schema Name box populates the name that you typed in the Name box. The physical name of the attribute is based on the name in the Schema Name box. However, the case sensitivity property of the physical name is based on the name in the Name box, unless you change the name in the Schema Name box. After you click Save, the case sensitivity property of the physical name is based on the name in the Schema Name box. Therefore, the physical name is not available for Microsoft Dynamics CRM to update.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Modification Type:	Major	Last Reviewed:	6/20/2006
Keywords:	kbtshoot kbMBScustomization kbMBSMigrate kbprb KB918437 kbAudEndUser kbAudKnowledgeWorker