BizDesk Cannot Save Changes to Product Category Information (823481)


The information in this article applies to:

  • Microsoft Commerce Server 2002 SP1

SYMPTOMS

If you use Microsoft Commerce Server Business Desk (BizDesk) to modify a catalog, the property changes are not saved.

CAUSE

This problem occurs because the PropertyName value is case sensitive and this value has been set to something other than ProdID. If the PropertyName value is not set correctly, BizDesk cannot save property changes.

RESOLUTION

To resolve this problem, follow these steps:
  1. Open Commerce Server Manager.
  2. Expand Microsoft SQL Servers. Continue to expand nodes until you locate your server and your database.
  3. In the node for your Commerce database, right-click the CatalogDefinitionsProperties table, point to Open Table, and then click Query.
  4. Modify the query to match the following, and then click the query (!) button:

    SELECT * FROM CatalogDefinitionProperties WHERE (PropertyName = 'prodid')

  5. If any results are returned, the PropertyName value is incorrectly set to Prodid.
  6. Modify the each row in the query results by clicking directly in the PropertyName cell and typing ProdID.
  7. Run the query that you ran in step 4 to verify that the values were changed. If the values were changed, the query does not return any rows.
  8. Start BizDesk, and then try to modify the assignments on any of the Optioned Products.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:10/30/2003
Keywords:kbBug kbfix KB823481 kbAudDeveloper kbAudITPRO
©2003 Microsoft Corporation. All rights reserved.