Commerce Server Blog

It’s good practice for a developer to refer to product hotfixes whenever they face any rare/new exception. For past two years, commerce server team has released many hot fixes for routine/rare exceptions but there is no single page to list all of them. In this article, I consolidated and listed many of commerce server 2009 and commerce server SP2 hot fixes. Hope this page will become one stop hotfix shop for the developers. If you find any other KB article missing from this list, feel free to drop an email to me (kanthATkanthDOTnet). For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base.

976815 FIX: You intermittently receive an error when you visit a Microsoft Commerce Server Web site that runs the Basket pipeline.

2448145 Pup.exe does not add Web services when you run the tool at a command prompt in Commerce Server 2009

932395 How to update Commerce Server 2007 and Commerce Server 2009 for the changes to daylight saving time

2396957 FIX: A deadlock error may occur when you use Commerce Server Staging or BizTalk Adapter for Commerce Server Catalog to try to import catalog data in Commerce Server 2007 or in Commerce Server 2009

2421688 FIX: Error message when you use Microsoft SharePoint Commerce Services Configuration Wizard to create a site: "The job creating the profile encryption key has timed out"

2380266 FIX: Catalog caching is not used when you use the CategoryConfiguration class together with the CategoryConfiguration.ChildProducts.SqlWhereClause property in Commerce Server 2009

2280532 FIX: Virtual catalog search issues occur when you use the CatalogSearch class in Commerce Server 2009

2319603 FIX: Error message when you run a website that executes the Advertising pipeline on a server that is running Commerce Server 2007 or Commerce Server 2009: "HttpContext.Current is null"

970717 FIX: Error message when you try to import a virtual catalog in Commerce Server 2007 and in Commerce Server 2009: "You should create the category before using it as a parent category"

968757 FIX: A hotfix is available that enables the Commerce Server Data Warehouse analysis reporting feature to support SQL Server 2008 Reporting Services

2300477 Commerce Server 2009 Site Profile Cache coherency implementation

975086 FIX: You cannot retrieve the latest inventory data by using Commerce Server APIs for the Inventory System in Commerce Server 2007.

975859 FIX: Error message when you access a Commerce Server site that is hosted on a computer that has hyper-threading enabled on two quad-core processors: "There are too many processors on this computer"

2161566 FIX: You cannot remove line items from the basket on a Commerce Server 2009 website

982912 Commerce Sample Code/Prototype Development

982887 Commerce Installation: Configuration, Deployment, and Migration

971377 FIX: The Commerce Server 2009 Product Provider Web Part does not include all product relationships

977980 FIX: You receive a System.AccessViolationException exception in the Commerce Server Profile Service when you visit a Commerce Server 2007 SP2 or Commerce Server 2009 Web site

980075 Marketing searches that use the CampaignItemManager.Search method take a long time when the Contains member is specified for the ExplicitComparisionOperator enumeration in Commerce Server 2009

980074 FIX: A Commerce Server 2009 site responds slowly when you use the PrimaryParentCategory parameter in a product query

979172 FIX: Site terms are imported incorrectly into the Commerce Server Data Warehouse

979528 FIX: You receive a System.Configuration.ConfigurationErrorsException exception when you browse a Commerce Server SharePoint Web site.

971188 FIX: You cannot use the Foundation API to manipulate data in a database column that has a weakly typed property in Orders System of Microsoft Commerce Server 2009.

975603 Error message when you open a Commerce Server 2009 Web site that is integrated into SharePoint when the SQL Server and the Commerce Server are installed on different computers: "Server Error in ‘/’ Application"

973050 How to use the CSWebTool.exe to add or to remove Web Servers from a SharePoint Web Farm that hosts Commerce Server 2009 Web sites.

977779 FIX: You cannot create products by using a product definition that contains many multilingual product properties in Commerce Server 2007 or in Commerce Server 2009

976523 FIX: An update is available that updates the user-agent reference data to generate accurate site user reporting in Commerce Server 2007 and in Commerce Server 2009

976753 Results take a long time to be returned when you query a category for a product list by using the Foundation API in Commerce Server 2009

975567 FIX: When you try to install Commerce Server 2009 on a computer that is running Windows Server 2008 R2, the installation fails.

975553 FIX: You cannot import product catalog data into a data warehouse in Commerce Server 2007 SP2 or in Commerce Server 2009.

975996 FIX: In Commerce Server 2007 SP2 or in Commerce Server 2009, the Web Server Log Import DTS task shows all log files that you import and does not exclude log files that you have imported already

975116 FIX: You obtain unexpected rows when you run a query against a virtual catalog in Commerce Server 2007

969768 FIX: In Commerce Server 2007 and in Commerce Server 2009, the decimal type value for a variant property is saved incorrectly in Catalog Manager if the decimal separator for the computer uses a period (.)

962913 Commerce Server 2007 product relationships may not be visible in Commerce Server Catalog Manager if the "Display Out of Stock Items" value is set to zero on the inventory resource

954487 FIX: In Commerce Server 2007, the discount may not be applied when you have a discount that is defined by using by a category that is defined in a virtual catalog

974321 FIX: You cannot disapprove a campaign or a campaign item in Marketing Manager in Commerce Server 2007 or Commerce Server 2009

973970 FIX: Error message when you export a virtual catalog in Commerce Server 2007: "Line 0: Violation of PRIMARY KEY constraint ‘PK__#Relationships____<string>’. Cannot insert duplicate key in object ‘dbo.#Relationships’"

968758 FIX: You cannot target advertisements or discounts to specified page groups by using the Discount Ad Web Part in Commerce Server 2009.

953394 List of the bugs that are fixed in Commerce Server 2007 Service Pack 2

969372 FIX: The Commerce Server 2009 SharePoint Commerce Services Configuration Wizard cannot create Web application when both the IIS Web site and the Extended IIS Web site are configured to use host headers and port 80

931186 FIX: The Commerce Server cache cannot refresh successfully when you invoke the SiteCacheRefresh method to refresh the cache in Commerce Server 2007

958771 FIX: The cache is not updated when you use the SiteCacheRefresh method if you specify host headers for a Commerce Server 2007 application that is hosted by a Web farm

968534 Catalog import operations into Commerce Server 2007 Product Catalog by using an XML file fail when you transact the import process

969877 Commerce Server 2007 Staging Services does not replicate modifications or deletions of multiple choice catalog property definitions.

957596 The sequencing information is not exported when you export a virtual catalog from Commerce Server 2007 Catalog Manager.

955173 You may encounter a NotAuthorizedException exception when you set up the Commerce Server 2007 Health Monitor service according to the product documentation

954726 FIX: Error message when you try to perform an incremental catalog import operation by using an XML file that contains empty attributes for a product: "Line x: Object reference not set to an instance of an object."

957575 FIX: The Staging service stops responding to remote servers after you restart the Staging service in Commerce Server 2007.

954266 Fix: A catalog XML file that contains only the product relationships takes a long time to import into a Commerce Server 2007 site.

962353 Package load failure error in Visual Studio after installing Commerce Server 2007 SP2.

If you like this post, please click on our sponsor advertisement.