Troubleshooting Data Migration

This topic describes the upgrade log files, common messages that may appear in the upgrade log files, and provides solutions for issues that you might encounter.

Upgrade Wizard Log Files

The following log files are created every time that the Upgrade Wizard runs:

  • CSUpgrade(YYMMDD HHMMSS).log

  • ExceptionOrders.log

By default, both files are created in the %temp% folder (for example, <drive>:\Documents and Settings\<user>\Local Settings\Temp). You can specify an alternative location for the log files when you run the Upgrade Wizard.

Note

CSUpgrade.log is updated with new logging information every time that you run the Upgrade Wizard, whereas ExceptionOrders.log is overwritten. Therefore, you must review ExceptionOrders.log before you run the Upgrade Wizard again. The log file names contain a timestamp that displays the year, month, day, and time in 24-hour time. For example, "090801 160908" indicates August 1, 2009 at 16:09:08. The ExceptionOrders log file is only created if orders (Transaction resource) are migrated. The default name and location of the file can be changed on the "Orders Configuration Settings" page in the Upgrade Wizard.

Upgrade Error Messages

Most upgrade errors result from database column or type mismatches, or from duplicate files or databases in the target location. The following sections list frequently encountered messages:

  • System.TimeoutException

  • Column PurchaseOrders.Name referenced in orders storage mapping file has different precision than the corresponding entry in the SQL shema

  • Warning: Unable to load the Configuration Data for the site 'CSharpSite'. This site will be skipped for migration

System.TimeoutException

If you encounter a System.TimeoutException error when you upgrade the Transaction resource, do the following to set an environment variable to reduce the batch size used when you migrate:

  1. On the computer where you run the Upgrade Wizard, create a Windows environment variable named PurchaseOrderBatchSize.

  2. Set the value of the variable lower than the default value of 2000 (for example, set it to 1000 or 500).

  3. Run the Upgrade Wizard again and migrate the Transactions resource.

Column PurchaseOrders.Name referenced in orders storage mapping file has different precision than the corresponding entry in the SQL schema.

This error occurs when the mapping in the orders storage mapping file is incorrectly specified.

Warning: Unable to load the Configuration Data for the site 'CSharpSite'. This site will be skipped for migration.

This error occurs when there is a site that has more than one application in Microsoft Commerce Server 2002 Standard Edition.

If the applications are Web services from Commerce Server 2002 Feature Pack 1, remove them from the site and use the Pup package included with Commerce Server 2009 R2 to add the Web service applications to the site. If you have modified any of the Web services, you will have to re-apply the modifications to the updated Web service applications.

See Also

Other Resources

Commerce Server 2009 R2 Troubleshooting