Troubleshoot
November 29, 2010 | 
Author 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.
Posted in 
Tags: 
I created commerce server 2009 site using SharePoint commerce services configuration wizard. The installation went fine without any errors (nothing is written in the logs). When I tried to open the website, I got a wired exception. The exception says – “Exception Details: System.Runtime.InteropServices.COMException: Table does not exist”.
After troubleshooting further, I figured out that the wizard is able to create profile entries in global profile resources (like user profile, address, etc. – you can able to see them in commerce server manager) but the corresponding tables in the database are not created.
Solution:
- Try to create a new commerce server website using commerce server OOB pup files (MicrosoftCommerceDefaultSiteNoData.PUP or MicrosoftCommerceDefaultSiteWithSampleData.PUP).
- (In my case, I have another CS website running.) Extract scripts from website profile database (created in above step) and executed them in your website profile database.
That’s the fix. Now; your application started working fine without any issues.
If you like this post, please click on our sponsor advertisement.
This is simple tip to my blog viewers. I am developing a page to show the list of address of a given user. I am able to retrieve User profile but I am not able retrieve Address profile. When executing, the below code, the expectation is that it returns address information for the GUID provided (id.ToString()).
| addressProfile = CommerceContext.Current.ProfileSystem.GetProfile("GeneralInfo.address_id",id.ToString(), AddressProfileName); |
The above code doesn’t return any data from commerce server. I checked the data is correctly passed to the API; I have verified the data exist in database; verified data is coming through web service call (through customer and order manager) and strange thing I didn’t see any exceptions in event log.
Can you guess what might be the problem with the code?
I am extracting address Id value from User profile object, converting it to GUID and once again converting to string in API call (id.ToString()). I removed these conversions (string – GUID – string) and directly passed Id to API call and I am able to retrieve the object.
If you like this post, please click on our sponsor advertisement.
Some times when you try to refresh the cache in business tools you may get “HTTP status code 401 (unauthorized)” exception. I have published the article which will fix this error.
Irrespective of following all the steps, sometimes you may still get the unauthorized exception. If yes, open OrderWebSerivce folder, create a new file and name it as SiteCacheRefresh.axd. Then in the IIS Manager, go to content view, right click the file and select "Feature View" and then change the Authentication to Anonymous. This will create an entry in the IIS Metabase for the URL to SiteCacheRefresh.axd. Now you can delete the file from Explorer (not from the IIS Manager). Since the access to the file is anonymous you will have to modify the web.config in OrderWebService folder to grant everyone access.
Locate the following lines of code
<location path="SiteCacheRefresh.axd">
<system.web>
<authorization>
and change <deny user="*"> to <allow user="*">
If you like this post, please click on our sponsor advertisement.
I have created three host names for my web application (one for extranet, intranet & business applications) and the host name is “ApplicationName.MyCompanyName.com”. When you open any one of the Commerce Server 2009 business Applications (Catalog Manager, Catalog Schema Manager, Customer & Orders Manager, Marketing Manager) with the host name url, you will be prompted for logon credentials. The logon process prompting will occur three times (irrespective of providing correct credentials) before finally denying you access to the Business Applications. This process works fine when you specify localhost or the server name within the URL.
If you view the web server logs, you will notice that your credential (logon name) are not
being received by the web site. I fixed the issue with the following configuration changes.
- Ensure that you modified Internet Explorer such that the FQDN is
listed in the trusted sites for your Intranet Zone and “Automatically logon only in
Intranet zone”.- Steps to make the site as trusted site: Internet Explorer –> Tools –> Internet Options –> Security Tab –> Local
Intranet –> click the “Sites” button –> click the “Advanced” button –> add your
FQDN into the Edit box and click the “Add” button –> Click the “Close” button –> Click the “OK” button - Enable Automatic logon : Internet Explorer –> Tools –> Internet Options –> Security Tab –> “Custom Level…” button (near the bottom) –>
Go down to the last option (User Authentication) –> verify that “Automatic logon
only in Intranet zone” is enabled –> click the “OK” button twice –> close out
Internet Explorer.
If this didn’t work, go to step 2.
- Steps to make the site as trusted site: Internet Explorer –> Tools –> Internet Options –> Security Tab –> Local
- Disable the loopback check. This behavior will occur if the Web site uses Integrated Authentication and has a name that is mapped to the local loopback address. To disable the loopback check:
1. Open a CMD.EXE window.
2. Type the following command and press Enter:
REG ADD HKLM\SYSTEM\CurrentControlSet\Control\Lsa /V DisableLoopbackCheck /T REG_DWORD /F /D 1
3. Shutdown and restart the computer.
or (if the step 2 section didn’t work)
To specify the host names:
1. Open a CMD.EXE window.
2. Type the following command and press Enter:
REG ADD HKLM\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0 /V BackConnectionHostNames / T REG_MULTI_SZ /F /D “<HostNames>”
Where “<HostNames>” contains the host names (for example, ApplicationName.MyCompanyName.com) for the sites that are on the local computer, each separated by \0.
3. Shutdown and restart the computer.
After server restarts, if you try to access CS2009 Business Application, you will not be asked with credentials popup. If you still gets popup then you might not have proper privileges in authorization store.
If you like this post, please click on our sponsor advertisement.
