Last updated March 28, 2008.

This Readme contains important updates and information about Microsoft® Commerce Server 2007 Service Pack 1 (SP1). Because Commerce Server 2007 SP1 is an update to Commerce Server 2007 and not a stand-alone release, the information that is contained in the Readme for Commerce Server 2007 (http://go.microsoft.com/fwlink/?LinkID=57013) is not duplicated in this document and still applies unless stated otherwise here.

This Readme contains instructions for installing and removing Commerce Server 2007 SP1, the known issues with Commerce Server 2007 SP1, and a list of the issues in Commerce Server 2007 that are fixed in Commerce Server 2007 SP1.

In This Document

Installation Instructions

Use the appropriate procedure for the operating system to install SP1 for Commerce Server 2007.

Important
Commerce Server 2007 SP1 includes updated binaries in English only. Each business user application that Commerce Server 2007 provides is available in English only. This does not affect your ability to develop a multilingual Commerce Server Web site.

Installing SP1 on non-English versions of Commerce Server 2007 is not supported.

After the installation of SP1 is complete, the account that was used to start the Commerce Server Staging service will be reset to NT Network Service. Follow the instructions in step 23 in the following section to set it back to its original value.

Note
If you install SP1 on a computer that is a member of a domain, the computer must be connected to the domain during the installation process.

To install SP1 for Commerce Server 2007 on Microsoft Windows Server 2003 and Microsoft Windows XP

  1. Download SP1 and extract the files.

  2. Back up the catalog, marketing, and marketing lists databases for all Commerce Server sites. This includes the CSharpSite.

  3. If Commerce Server Staging is installed, make a copy of all registry keys under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\CSS to use if you uninstall SP1. For instructions about how to back up the registry keys, see http://go.microsoft.com/fwlink/?LinkID=93198.

  4. Double-click SP1setup.exe in the folder to which you extracted the files.

    Note
    The installation wizard will install the pieces of SP1 for the pieces of Commerce Server 2007 that are installed on the computer. If you have not installed the Business User applications, for example, the Business User application pieces of SP1 will not be installed. Install all pieces of Commerce Server 2007 that you will use before you install SP1 for Commerce Server 2007.

  5. On the Welcome page, click Next.

  6. Accept the license agreement, and then click Next.

  7. Click Next to continue the installation.

  8. A dialog box that lists the services that will be stopped might appear. Click OK to accept the services being stopped.

    Important
    Installing SP1 for Commerce Server 2007 will stop any Web applications that are running on the computer. If this is unacceptable, click Cancel and schedule another time to install SP1 for Commerce Server 2007.

  9. If a message that Commerce Server was unable to create a registration marker in Active Directory appears, click OK. The absence of a registration marker does not affect Commerce Server.

  10. If you are installing SP1 on a computer that has only the Commerce Server business user applications or the BizTalk adapters, click Finish and skip steps 11 through 23.

  11. If you are installing SP1 on a computer that already has Commerce Server sites, make sure that Launch Commerce Server Upgrade Wizard is selected, and then click Finish. The Commerce Server upgrade wizard starts. The upgrade wizard migrates catalog and marketing data to the new database format.

  12. On the Welcome page of the Commerce Server 2007 upgrade wizard, click Next.

  13. On the Select Options page, either accept the default location for the log file or enter a new location, and then click Next.

  14. Select the Commerce Server site whose data you want to migrate.

    Note
    You can only migrate the data for one site at a time. To migrate data for more than one site, rerun the upgrade wizard.

  15. On the Upgrade Site Resources page, select the Product Catalog resource, and then select the Migrate action.

  16. Select the Marketing resource, and then select the Migrate action.

  17. Click Next.

  18. On the Upgrade Summary page, click Next.

  19. When the upgrade is complete, click Next.

  20. On the Summary page, click Next.

  21. Click Finish.

  22. To migrate another site, click Start, point to All Programs, point to Microsoft Commerce Server 2007, point to Tools, and then click Upgrade Wizard. Repeat steps 11 through 20 to run the upgrade wizard.

  23. If you installed Commerce Server Staging, the account that was used to start the service will be reset to NT Network Service after SP1 installation is complete. You will have to change it to its previous value by rerunning the Commerce Server Configuration Wizard. Rerunning the Commerce Server Configuration Wizard will also set the default authentication account to the service account. If the previous default authentication account was different from the service account, change it to its previous value by using the MMC snap-in. Rerun the Commerce Server Configuration Wizard by typing the following line in a Command Prompt window and following the instructions in the wizard:

    "%commerce_server_root%\CSConfig.exe" /r Feature.MS.CS.CsStaging
To install SP1 for Commerce Server 2007 on Windows Vista

  1. Follow the instructions to install Commerce Server 2007. You can download the installation instructions from http://go.microsoft.com/fwlink/?LinkID=57268. If you install the Developer Edition of Commerce Server 2007, you can follow the simpler installation instructions that you can download from http://go.microsoft.com/fwlink/?LinkID=79888. If you are installing the full Commerce Server 2007 product and not only the business user applications, do not configure Commerce Server 2007 or install the CSharpSite at this point.

  2. Download SP1 and extract the files.

  3. Double-click SP1setup.exe in the folder to which you extracted the files.

    Note
    The installation wizard will install the pieces of SP1 for the pieces of Commerce Server 2007 that are installed on the computer. If you have not installed the Business User applications, for example, the Business User applications pieces of SP1 will not be installed. Install all pieces of Commerce Server 2007 that you will use before you install SP1 for Commerce Server 2007.

  4. Click Allow in the User Account Control dialog box.

  5. On the Welcome page, click Next.

  6. Accept the license agreement, and then click Next.

  7. Click Next to continue the installation.

  8. A dialog box that lists the services that will be stopped might appear. Click OK to accept the services being stopped.

    Important
    Installing SP1 for Commerce Server 2007 will stop any Web applications that are running on the computer. If this is unacceptable, click Cancel and schedule another time to install SP1 for Commerce Server 2007.

  9. If a message that Commerce Server was unable to create a registration marker in Active Directory appears, click OK. The absence of a registration marker does not affect Commerce Server.

  10. If an option to start the Commerce Server Configuration Wizard is displayed when the installation wizard finishes, make sure that the option is selected, and then click Finish.

  11. If you will not use Commerce Server 2007 to develop a site, skip the rest of this procedure.

  12. If you want to develop a Commerce Server site, follow the installation instructions for Commerce Server 2007 to configure Commerce Server 2007 and install the CSharpSite.

Removing SP1 for Commerce Server 2007

Use the appropriate procedure for the operating system to remove SP1 for Commerce Server 2007.

To remove SP1 for Commerce Server 2007 from Microsoft Windows Server 2003 or Microsoft Windows XP

  1. Click Start, point to Settings, and then click Control Panel. (On Microsoft Windows XP, click Start, and then click Control Panel.)

  2. In Control Panel, double-click Add or Remove Programs.

  3. In the Add or Remove Programs window, select Microsoft Commerce Server 2007 SP1, and then click Change/Remove.

  4. Click OK to confirm that you want to uninstall SP1 for Commerce Server 2007.

  5. Restore the backups of the catalog and marketing databases that you created when you installed SP1 for Commerce Server 2007.

  6. When you remove SP1 for Commerce Server 2007, the value of the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Commerce Server 2007\UnsafeAuthenticatedConnectionSharing registry key is set to 0 (zero). If you changed the value of this registry key, reset it to its previous value.

  7. If you installed Commerce Server Staging, the values of all registry keys under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\CSS are set to their default values. Reset these registry keys to their previous values by following the instructions at http://go.microsoft.com/fwlink/?LinkID=93198. After resetting these keys, rerun the Commerce Server Configuration Wizard by typing the following line in a Command Prompt window and following the instructions in the wizard:

    "%commerce_server_root%\CSConfig.exe" /r Feature.MS.CS.CsStaging
To remove SP1 for Commerce Server 2007 from Windows Vista

  1. Click Start, and then click Control Panel.

  2. In Control Panel, click Uninstall a Program. (Double-click Programs and Features if you are using the classic view.)

  3. In the Programs and Features window, right-click Microsoft Commerce Server 2007 SP1, and then click Uninstall/Change.

  4. Click Continue in the User Account Control dialog box.

  5. Click OK to confirm that you want to uninstall SP1 for Commerce Server 2007.

Fixed Issues

The following issues have been fixed in this release:

Fixed: Unpacking a site might not populate the AllowedStatus table

The following error message might occur in the site packager log file:

"8004E024:COM+ activation failed because the activation could not be completed in the specified amount of time. (Exception from HRESULT: 0x8004E024)"

This error message indicates that Commerce Server could not populate the AllowedStatus table in the transactionconfig database. To populate the AllowedStatus table, open SQL Server Management Studio (open SQL Query Analyzer if you are using SQL Server 2000), and run the regiondata SQL script against the transactionconfig database. The regiondata script is located at %COMMERCE_SERVER_ROOT%\SDK\Samples\SiteCreate\.

This issue has been fixed in SP1 for Commerce Server 2007.

Fixed: Marketing Manager fails with an error when you copy and paste a campaign item that contains an apostrophe in the name

When you copy and paste a campaign item that contains an apostrophe in the name, during the paste operation you receive the following error message:

"System.Data.SyntaxErrorException: Syntax error: Missing operand after 's' operator."

Note
The character reported in the error may vary.

To resolve this issue, remove the apostrophe or add an additional apostrophe. For example, if your campaign item was originally named John's Ad, change the name to Johns Ad.

This issue has been fixed in SP1 for Commerce Server 2007.

Fixed: Cannot view catalog expression migrated from Commerce Server 2002 Service Pack 3 in the Marketing Manager user interface

When you try to view catalog expressions in the Marketing Manager user interface that you migrated from Commerce Server 2002 Service Pack 3, you receive the following error message:

"The expression cannot be opened because its format is not supported by this application."

To resolve this problem, manually change the SQL Server data and use the following example to change your data. For example, change this line:

<IMMED-VAL TYPE="string">shoes</IMMED-VAL>

To this:

<IMMED-VAL TYPE="string"><VALUE>shoes</VALUE></IMMED-VAL>

This issue has been fixed in SP1 for Commerce Server 2007.

Known Issues

The following are known issues in SP1 for Commerce Server 2007:

Upgrade Wizard Fails with Exception 0x8004E024

The upgrade wizard might fail and display the error "COM+ Activation failed because the activation could not be completed in the specified amount of time." Follow the instructions at http://go.microsoft.com/fwlink/?LinkID=90691 to work around this issue.

Specifying the Possible Values of a Preferred Profile Property

The Customer and Orders Manager can now display the values of one profile property as options for the value of another profile property.

To display the name of each credit card as an option for the preferred credit card property, add memberOfList=”credit_card_list” to the preferred credit card property in the <language>_PresentationInfo.xml file. The entry might resemble this: 

<property name="preferred_credit_card" 
    displayName="Preferred Credit Card" 
    description="Name of preferred credit card from this user's credit card list" 
    memberOfList="credit_card_list" />

By default, the name of each address is displayed as an option for the preferred address property. To block this functionality, add a setting element for the TreatPreferredAddressAsMemberOfAddressList setting to the CustomerAndOrdersManager.exe.config file. The following sample indicates where to add the setting element:

<configuration>
  <applicationSettings>
    < Microsoft.CommerceServer.UI.CustomerAndOrdersManager.Properties.Settings >
      <setting name=”TreatPreferredAddressAsMemberOfAddressList”
        serializeAs=”String”>
        <value>False</value>
      </setting>
      </ Microsoft.CommerceServer.UI.CustomerAndOrdersManager.Properties.Settings >
  </applicationSettings>
</configuration>

Cannot Modify Multivalued Site Terms

You cannot modify a profile property that is a multivalued site term by using the Customer and Orders Manager unless you add the property to the <language_code>PresentationInfo.xml files. If the property is in the <language_code>PresentationInfo.xml file for the Profiles Web service, you can modify the property on the Properties pane in the Customer and Orders Manager.

Cannot Modify Multivalued String Profile Properties

You cannot modify a profile property that is a multivalued string by using the Customer and Orders Manager unless you add the property to the <language_code>PresentationInfo.xml files. If the property is in the <language_code>PresentationInfo.xml file for the Profiles Web service, you can modify the property on the Properties pane in the Customer and Orders Manager.

Refreshing the Profiles Cache

You must grant the ProfilesWebService account permission to refresh the site cache. For information about how to do this, see the topic “How to Help Secure the Refresh Cache Methods” in the Commerce Server 2007 documentation.

Data Warehouse Daylight Saving Time Update

We recommend that you update your Data Warehouse databases to reflect the new rules for daylight saving time. For more information about doing this, see http://go.microsoft.com/fwlink/?LinkID=92641.

Remove Limits from Data Warehouse Dimensions

If you have an existing Data Warehouse database that uses Analysis Server within SQL Server 2005, you must update the database to remove limits on the dimensions. Follow these steps to update each Data Warehouse database.

Important
This procedure will delete and re-create the Data Warehouse database in Analysis Server.

Important
This process could take a while, and might affect the performance of the Data Warehouse while it is running.

To remove Data Warehouse dimension limits

  1. Start SQL Server Management Studio and select the Analysis Services server type.

  2. In SQL Server Management Studio, open the CommerceOlap.xmla file. This file is located in the %COMMERCE_SERVER_ROOT%\tools directory.

  3. Click Connect.

  4. Expand the data warehouse database, expand Data Sources, and then double-click COMMERCE_DataWarehouse.

  5. Copy the connection string, and then click Cancel.

  6. In the script pane, replace the value of three elements:

    1. Search for <ConnectionString> and replace the value of the ConnectionString element with the connection string you copied in step 4.

    2. Replace IDCS2006Validate with the name of the Data Warehouse database.

    3. Replace NameCS2006Validate with the name of the Data Warehouse database.

  7. Delete the Data Warehouse database.

  8. Execute the script.

  9. Right-click the database, and then click Process.

  10. In the Process database dialog box, select ProcessFull in the Process Options column, and then click OK.

ImpersonateClient Error in Event Log

When you import a catalog, manipulate lists, or generate coupons on Windows Vista, an error that resembles the following might appear in the event log:

System.Runtime.InteropServices.COMException (0x80004005): Impersonation Failed for the long running operation. The COM API 'CoImpersonateClient' failed with error code '0x80070005'. Please check the COM security settings of the process.

This error occurs when you configure Commerce Server 2007 before you install SP1 for Commerce Server 2007.

Follow these steps to fix this error.

To reconfigure Commerce Server 2007

  1. Open a Command Prompt window and type the following command to remove the current configuration of Commerce Server 2007:

    %COMMERCE_SERVER_ROOT%\csconfig.exe /u

  2. Make sure that SP1 for Commerce Server 2007 is installed.

  3. Type the following command to reconfigure Commerce Server 2007:

    %COMMERCE_SERVER_ROOT%\csconfig.exe

Visual Studio Express Does Not Support Access to Commerce Server Tools

Visual Studio 2005 Express does not support access to Commerce Server Manager, Commerce Server Pipeline Editor, and Commerce Server Resources within Visual Studio. For other ways to access Commerce Server tools, see http://go.microsoft.com/fwlink/?LinkID=93645.

Windows Server 2008 Logo Certification Issues

Commerce Server 2007 is now certified for and supported on Microsoft Windows Server 2008. The release version of Commerce Server 2007 and Commerce Server 2007 Service Pack 1 (SP1) can be run on Windows Server 2008, with Internet Information Service (IIS) 7 configured to Classic mode.

The following Microsoft Knowledge Base articles identify Windows Server 2008 Logo Certification issues with Commerce Server 2007 and Commerce Server 2007 SP1. None of the Windows Server 2008 Certification issues cause operational problems or failures in Commerce Server 2007:

-----------------------------------------------------------------------------------------------

Information in this document, including URL and other Internet Web site references, is subject to change without notice. Unless otherwise noted, the companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted in examples herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

© 2008 Microsoft Corporation. All rights reserved.

Microsoft, Commerce Server, BizTalk, Visual Studio, Windows, Windows Vista, and Windows Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

All other trademarks are property of their respective owners.