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.
- Log in to the Utility server Docker container. To access the container, see Running utilities from the Utility server Docker container.
- Open the following file for
editing.
/opt/WebSphere/CommerceServer90/migration/xml/features/BASE/db/70/configureDatabaseFixpack.xml
- 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" />
-
- Save and close the file.
Result
The wcim_ant utility runs as expected during the database migration.