Microsoft KB Archive/931177

= Apply hotfix 923269 before you upgrade Commerce Server 2002 to Commerce Server 2007 =

Article ID: 931177

Article Last Modified on 2/21/2007

-

APPLIES TO


 * Microsoft Commerce Server 2007 Enterprise Edition
 * Microsoft Commerce Server 2007 Developer Edition
 * Microsoft Commerce Server 2007 Standard Edition
 * Microsoft Commerce Server 2002 Standard Edition

-



INTRODUCTION
Certain issues may occur when you migrate transaction-related data after you upgrade Microsoft Commerce Server 2002 to Microsoft Commerce Server 2007. To avoid these issues, apply hotfix 923269 before you upgrade Commerce Server 2002 to Commerce Server 2007. Before you run the Commerce Server 2007 upgrade wizard, apply the hotfix package that is mentioned in the following Microsoft Knowledge Base article:

923269 FIX: You receive a System.FormatException exception error message when you use the Upgrade Wizard in Commerce Server 2007 to upgrade from Commerce Server 2002 to Commerce Server 2007

The &quot;More Information&quot; section contains information about two issues that you may experience. It also contains ways to resolve these issues.



MORE INFORMATION
When you upgrade Commerce Server 2002 to Commerce Server 2007, you may experience the following migration issues.

Issue 1
When you try to migrate transaction-related data to Commerce Server 2007, you may receive a System.FormatException exception error message. To resolve this issue, apply hotfix 923269, and then run the upgrade wizard again.

Issue 2
When you try to upgrade to Commerce Server 2007, and the transactions database has been extended, you may receive the following warning message:

Transactions Warning: Please read following information carefully. This migration tool does not migrate this version of transaction resource completely. After running migration tool Compare the OrderObjectMappings.Xml from the site VROOT and the one installed under %COMMERCE_SERVER_ROOT%\SDK\Samples\SiteCreate\OrderObjectMappings.Xml and merge the changes. Then regenerate the PurchaseOrder related stored procedure definitions using the OrderMapping.exe tool with orders configuration section in web.config pointing to updated OrderObjectMappings.xml Run the generated sql script file on the transaction database

To resolve this issue, apply hotfix 923269, and then run the upgrade wizard again. Additionally, if the transaction database has been extended, follow these steps:  Locate the root folder of an upgraded Commerce Server Web site. In the root folder that you located in step 1, open the OrderObjectMappings.xml file. Locate the following folder:

%COMMERCE_SERVER_ROOT%\SDK\Samples\SiteCreate

 In the %COMMERCE_SERVER_ROOT%\SDK\Samples\SiteCreate folder, open the OrderObjectMappings.xml file. Merge the contents of the file that you opened in step 2 with the contents of the file that you opened in step 4. The merged file will contain all the entries from both files. Replace the file that you opened in step 2 with the merged file that you created in step 5. Click Start, click Run, type cmd, and then click OK.</li> Type cd %COMMERCE_SERVER_ROOT%/Tools, and then press ENTER.</li> Type OrderMapping.exe /w, and then press ENTER. This step generates an SQL script.

Note  is a placeholder for the complete path of the Web.config file.</li> Run the SQL script that was generated in step 9 against the transaction database for the upgraded Commerce Server Web site.</li></ol>

<div class="references_section">