Commerce Server and the MSCS_CatalogScratch Database and Maintenance.

Thanks to Charles Teague for providing some of the technical detail for this article. (Cross posted from http://blogs.msdn.com/b/finbar_ryan/archive/2012/05/02/commerce-server-and-the-mscs-catalogscratch-database-and-maintenance.aspx ) We’ll cover what the MSCS_CatalogScratch does in Commerce Server and how to maintain it either via VBScript or SQL Server Maintenance plans.   1) What’s the Catalog Scratch Database? The Catalog Scratch Database is a database…

0

Errors when trying to use Site Packager on IIS 7.0

When attempting to pack a site or unpack a site you may received errors or failures during the packing or unpacking process. This may be caused by various factors but I wanted to point out one cause that is new when using IIS 7.0. In IIS 7.0 you have the ability to configure a web…


Commerce Server 2009 Documentation in .Chm format.

As you know the Commerce Server 2007 and Commerce Server 2009 help use the new Visual Studio Document Explorer format which means that it’s not as portable as the HTML Help format. I generally don’t have Commerce Server installed on my laptop (I know I should but I’ve got some VM’s I use instead!) ,…

0

How do you create a Commerce Server 2007 BizTalk Orchestration using your customized product catalog

Listed below are the steps you need to perform to successfully export your catalog to a directory. 1. You will need to export your catalog schema using the Commerce Server Export Catalog tool a. Open a command prompt b. Go to the Program Files\Microsoft Commerce Server 2007\Tools directory c. Enter the command “exportcatalog.exe /s:<site name>…

0

Commerce Server Version Numbers

I was asked recently by a customer what was the easiest way to determine what version of Commerce Server they have installed. There are many ways to check such as Control Panel…Add/Remove Programs with updates being shown, registry setting and in the Help / About in Commerce Server Manager. Probably the easiest way to check…


Adjusting polling interval to the StagingLog.mdb

By default, in Commerce Server 2007 and Commerce Server 2009 the Commerce Staging System (CSS) will poll the StagingLog.mdb every 5 seconds.  Under normal circumstances this polling interval is not an issue but under an highly used CSS system the frequent polling may cause the service to crash. If you are running into the issue,…


Configuring number of results in Catalog Manager search

In Catalog Manager, when you perform a search for a product, category, etc. by default the maximum number of results that will be returned is 500. You can alter the maximum number or results returned by making changes in the Catalog Web Service web.config file. In the web.config file you will find the notations on…


Installing Commerce Server on Windows Server 2008 R2

Both Commerce Server 2007 and Commerce Server 2009 have been tested on Windows Server 2008 R2 and both are fully supported on this platform. However there are a few items that I wanted to review regarding either upgrading or installing either version of Commerce Server on this platform.   For Commerce Server 2007, there are…


Upgrading Commerce Server 2009 deployment on WSS to MOSS

If you have deployed any of the Commerce Server 2009 sample sites or your own custom site on a Windows SharePoint Services 3.0 based deployment, and then decide to upgrade that deployment to Office SharePoint Server 2007, your Commerce sites already deployed will cease to function correctly.   This is because when you use the…


Cookie Sharing with Internet Explorer 8 and the Starter Site

With Commerce Server 2007 and 2009, if you are using a site based on the Core API such as the Starter Site, you can set the site to share cookie domain level at 2. If you have the web application non-secure hostname (for example: NonSecName.testsite.com) set to a different name than secure host name (for…