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:
The "More Information" section contains information about two issues that you may experience. It also contains ways to resolve these issues.
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:
| 1. | Locate the root folder of an upgraded Commerce Server Web site. |
| 2. | In the root folder that you located in step 1, open the OrderObjectMappings.xml file.
|
| 3. | Locate the following folder:
%COMMERCE_SERVER_ROOT%\SDK\Samples\SiteCreate |
| 4. | In the %COMMERCE_SERVER_ROOT%\SDK\Samples\SiteCreate folder, open the OrderObjectMappings.xml file. |
| 5. | 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. |
| 6. | Replace the file that you opened in step 2 with the merged file that you created in step 5. |
| 7. | Click Start, click Run, type cmd, and then click OK.
|
| 8. | Type cd %COMMERCE_SERVER_ROOT%/Tools, and then press ENTER.
|
| 9. | Type OrderMapping.exe /w WebConfigCompletePath, and then press ENTER.
This step generates an SQL script.
Note WebConfigCompletePath is a placeholder for the complete path of the Web.config file. |
| 10. | Run the SQL script that was generated in step 9 against the transaction database for the upgraded Commerce Server Web site. |
For more information about how to use the Order Mapping tool, visit the following Microsoft Developer Network (MSDN) Web site:
