Troubleshooting: wcim_ant utility fails

During the live database migration to HCL Commerce Version 9.0 from a previous version of WebSphere Commerce, the wcim_ant utility can fail.

Problem

During migration, the wcim_ant utility can present an error similar to the following.
/opt/WebSphere/CommerceServer90/migration/xml/features/BASE/db/70/configureDatabaseFixpack.xml:929: Unexpected value '${isStagingServer}' is set to isStaging. Options are [true] or [false]

Solution

To correct this error:
  • Upgrade to HCL Commerce 9.0.1.20 or greater.
  • Manually correct the issue for versions of HCL Commerce Version 9.0 prior to 9.0.1.20.
    1. Log in to the Utility server Docker container. To access the container, see Running utilities from the Utility server Docker container.
    2. Open the following file for editing.

      /opt/WebSphere/CommerceServer90/migration/xml/features/BASE/db/70/configureDatabaseFixpack.xml

    3. Locate and replace the following contents.
      • Locate and replace:
        <StagingCheck driver="${jdbcDriver}" url="${jdbcURL}" userid="${dbUserName}" password="${dbUserPassword}" action="insert" tablename="WCS_Fixpack" serverOrToolkit="${isServerOrToolkit}" stagingServer="${isStagingServer}" stagingDbChecked="${stagingDbChecked}" logLevel="0" />
        
        With:
        <StagingCheck driver="${jdbcDriver}" url="${jdbcURL}" userid="${dbUserName}" password="${dbUserPassword}" action="insert" tablename="WCS_Fixpack" serverOrToolkit="${isServerOrToolkit}" stagingServer="${isStaging}" stagingDbChecked="${stagingDbChecked}" logLevel="0" />
      • Locate and replace:
        <StagingCheck driver="${jdbcDriver}" url="${jdbcURL}" userid="${dbUserName}" password="${dbUserPassword}" action="delete" tablename="WCS_Fixpack" serverOrToolkit="${isServerOrToolkit}" stagingServer="${isStagingServer}" stagingDbChecked="${stagingDbChecked}" logLevel="0" />
        
        With:
        <StagingCheck driver="${jdbcDriver}" url="${jdbcURL}" userid="${dbUserName}" password="${dbUserPassword}" action="delete" tablename="WCS_Fixpack" serverOrToolkit="${isServerOrToolkit}" stagingServer="${isStaging}" stagingDbChecked="${stagingDbChecked}" logLevel="0" />
    4. Save and close the file.

Result

The wcim_ant utility runs as expected during the database migration.