A custom string field that contains over 999 characters truncates data after you modify that field in Microsoft CRM (904823)


The information in this article applies to:

  • Microsoft CRM 1.2

SYMPTOMS

Consider the following scenario:
  • You create a new schema string field by using the Microsoft Business Solutions CRM Deployment Manager tool.
  • The string field that you create has a maximum field length of over 999 characters.
  • You modify a form in Microsoft CRM to use this field.
  • You publish the customization of this form by using the Microsoft CRM Deployment Manager tool.
After you publish the customization of this form, the field that you created successfully contains the number of characters that you specified. However, after you view or modify this new field in Microsoft CRM and then click OK, the new field no longer contains the number of characters that you specified. Instead, this field contains only a few characters.

For example, after you view or modify a field that should have a maximum field length of 2,000 characters, the field contains only 2 characters. In this situation, data that is contained in this field is truncated to the new incorrect field length.

CAUSE

This problem occurs because Microsoft CRM truncates the field length after a comma. When you specify a field length that is over 999 characters, Microsoft CRM adds a comma to the integer that specifies this field length. For example, if you specify a field length of 2000, Microsoft CRM adds a comma so that the field length appears as 2,000. However, when you open the form that contains this field, view or modify the field, and then click OK, Microsoft CRM truncates the field length after the comma. Therefore, a field length of 2,000 is incorrectly changed to a field length of 2.

RESOLUTION

Microsoft CRM has a fix for this problem that is part of a cumulative update. The cumulative update information is described in the following Microsoft Knowledge Base article:

904435 Update Rollup 2 is available for Microsoft CRM 1.2

MORE INFORMATION

For more information about the terminology that is used to describe Microsoft product updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Modification Type:MinorLast Reviewed:7/25/2006
Keywords:kbMBSMigrate kbQFE kbHotfixServer kbpubtypekc KB904823 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.