Microsoft KB Archive/823481

= BizDesk Cannot Save Changes to Product Category Information =

Article ID: 823481

Article Last Modified on 10/30/2003

-

APPLIES TO


 * Microsoft Commerce Server 2002 Service Pack 1

-



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:  Open Commerce Server Manager. Expand Microsoft SQL Servers. Continue to expand nodes until you locate your server and your database. In the node for your Commerce database, right-click the CatalogDefinitionsProperties table, point to Open Table, and then click Query. Modify the query to match the following, and then click the query (!) button:

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

 If any results are returned, the PropertyName value is incorrectly set to Prodid. Modify the each row in the query results by clicking directly in the PropertyName cell and typing ProdID . 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.</li> Start BizDesk, and then try to modify the assignments on any of the Optioned Products.</li></ol>

<div class="status_section">

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

Keywords: kbbug kbfix KB823481

-

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

© Microsoft Corporation. All rights reserved.