Microsoft KB Archive/931495

From BetaArchive Wiki

Article ID: 931495

Article Last Modified on 11/15/2007


  • Microsoft Commerce Server 2007 Enterprise Edition
  • Microsoft Commerce Server 2007 Developer Edition
  • Microsoft Commerce Server 2007 Standard Edition


When you provide a SqlWhereClause property in the CategoryConfiguration object in Microsoft Commerce Server 2007, the ChildCategories collection for a root category in a virtual catalog is empty. This problem occurs when the root categories are ranked in the base catalog or in the virtual catalog.


Hotfix information

A supported hotfix is now available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next service pack that contains this hotfix.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:


No prerequisites are required.

Restart requirement

You do not have to restart your computer after you apply this hotfix. However, you must restart Microsoft Internet Information Services (IIS) after you apply this hotfix. To do this, cick Start, click Run, type iisreset, and then click OK.

Hotfix replacement information

This hotfix does not replace any other hotfixes.

File information

The English version of this hotfix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.

File name File version File size Date Time Platform
931495.sql Not Applicable 7,214 29-Dec-2006 20:21 Not Applicable
Catalogcreate.sql Not Applicable 1,120,994 18-Jan-2007 22:48 Not Applicable


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


For example, you experience this problem when you execute the following code:

CategoryConfiguration cc;
cc.ChildCategories.SqlWhereClause = "1=1"
cc.LoadChildCategories = true;
vc.GetRootCategory(cc).ChildCategories;  // This collection is empty instead of the collection that contains all root categories of the virtual catalog

For existing Commerce Server 2007 catalog databases, you must run the 931495.sql file against your existing catalog databases. To do this, follow these steps:

  1. Start Microsoft SQL Server Management Studio.
  2. Select the instance of SQL Server where your catalog database resides, and then click Connect.
  3. Click New Query.
  4. Select your catalog database.
  5. Copy the SQL code from the 931495.sql file to the new query window, and then click Execute.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

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

Keywords: kbbug kbfix kbhotfixserver kbqfe kbpubtypekc KB931495