PRB: Property Definition for Product Unique ID Cannot Exceed 900 Characters (292440)


The information in this article applies to:

  • Microsoft Commerce Server 2000
This article was previously published under Q292440

SYMPTOMS

When you try to set a Product Unique ID or Product Variant Unique ID field for a new catalog in the BizDesk Editor, property definitions may be missing from the drop-down list box.

CAUSE

This problem can occur when property definitions are defined as a text value with a maximum length that is greater than or equal to 900 characters.

RESOLUTION

To resolve this problem, make sure that any property definitions that are used for Product Unique IDs or Product Variant Unique IDs do not exceed 900 characters.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

The 900-character limit on a Product Unique ID or Product Variant Unique ID is due to a limitation in Microsoft SQL Server in which strings with a length that is greater than or equal to 900 characters cannot be indexed. Because the Product Unique ID and Product Variant Unique ID fields are indexed fields in the database, they cannot exceed 900 characters.

Steps to Reproduce Behavior

  1. In the BizDesk Editor, from the Catalogs module, click Catalog Designer. On the toolbar, click to view Property Definitions.
  2. Create a new property definition of Text type named Test900.
  3. In the Maximum value box, type 900. Save the property definition.
  4. Create another new property definition of Text type named Test899.
  5. In the Maximum value box, type 899. Save the property.
  6. In the Catalogs module, click Catalog Editor.
  7. Create and name a new catalog.
  8. View the drop-down list box for Product Unique ID or Product Variant Unique ID. Notice that the property definition for Test899 is available, but the property definition for Test900 does not appear.
Modification Type:MajorLast Reviewed:10/21/2002
Keywords:kbDSupport kbprb KB292440
©2002 Microsoft Corporation. All rights reserved.