Microsoft KB Archive/292440

= PRB: Property Definition for Product Unique ID Cannot Exceed 900 Characters =

Article ID: 292440

Article Last Modified on 10/21/2002

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



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.

Additional query words: unavailable

Keywords: kbprb KB292440

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.