Troubleshoot: Exception when running database migration

When migrating from WebSphere Commerce V5.6 to v6, an error is logged during database migration.

 

Problem

You are migrating your Oracle database from WebSphere Commerce V5.6 to WebSphere Commerce v6. When the migration attempts to run MigrateEPromotionFromCEP2STARCmd you receive the following exception:

java.lang.reflect.InvocationTargetException:
java.lang.NullPointerException
at com.ibm.commerce.migration.util.XmlHelper.
getXMLDocument(XmlHelper.java(Compiled Code))

Solution

To resolve this issue, complete the following steps:

1. Back up the Utilities.jar file under the WC_installdir/lib directory.

2. Replace the following two classes under com/ibm/commerce/migration/tool in the Utilities.jar file with updated files:

   • MigrateEPromotionFromCEP2STARCmd.class

   • MigrateEPromotionFromCEP2STARCmd$Rldiscount.class

   Contact WebSphere Commerce Support to get the correct version of these files. Run the database tier migration again.

Related Concepts

Migrate from a previous version of WebSphere Commerce

Related tasks

Migrate the WebSphere Commerce database

Migrate the development environment database

Migrate the WebSphere Commerce database using the migration script