Home
Documentation
HCL Commerce is a high-availability, highly scalable and customizable e-commerce platform. Able to support hundreds of thousands of transactions per day, HCL Commerce allows you to do business with consumers (B2C) or directly with businesses (B2B). HCL Commerce uses cloud friendly technology to make deployment and operation both easy and efficient. It provides easy-to-use tools for business users to centrally manage a cross-channel strategy. Business users can create and manage precision marketing campaigns, promotions, catalog, and merchandising across all sales channels. Business users can also use AI enabled content management capabilities.
Troubleshooting
Topics in the Troubleshooting section highlight common issues that are encountered with HCL Commerce, and how they can be addressed or mitigated.
Migration issues
Migrating HCL Commerce involves a wide range of steps across your different environments. If you encounter problems, refer to the following resources for assistance.
Database migration fails due to database user mismatch
During the migration of your HCL Commerce database, a permissions error (SQLCODE=-551) is encountered when running the database migration.

Documentation
HCL Commerce is a high-availability, highly scalable and customizable e-commerce platform. Able to support hundreds of thousands of transactions per day, HCL Commerce allows you to do business with consumers (B2C) or directly with businesses (B2B). HCL Commerce uses cloud friendly technology to make deployment and operation both easy and efficient. It provides easy-to-use tools for business users to centrally manage a cross-channel strategy. Business users can create and manage precision marketing campaigns, promotions, catalog, and merchandising across all sales channels. Business users can also use AI enabled content management capabilities.
- Getting started
  HCL Commerce has different advantages for business users, administrators and developers. HCL Commerce targets each of these roles with a tailored set of offerings so that each of your users can get maximum benefit.
- Installing and deploying
  Learn how to install and deploy HCL Commerce development environments and HCL Commerce production environments.
- Migrating
  Before you migrate to HCL Commerce Version 9, review this information to help plan and execute your migration.
- Operating
  Topics in the Operating category highlight tasks that are typically performed by business users, customer support representatives, to complete their day-to-day tasks in the operation of the HCL Commerce site.
- Integrating
  Topics in the Integrating category highlight the tasks that are commonly performed for using HCL Commerce in combination with other products.
- Administering
  Topics in the Administering category highlight tasks that are typically performed by the Site Administrator, to support daily operations of the HCL Commerce site.
- Customizing
  The topics in the Customizing section describe tasks performed by an application developer to customize HCL Commerce.
- Tutorials
  HCL Commerce provides many tutorials to help you customize and understand your HCL Commerce instance and stores.
- Samples
  Topics in the Samples category highlight the various samples that are provided with HCL Commerce.
- Compliance
  The following section describes how you can leverage HCL Commerce features and functionality to help your site be compliant with different privacy and security standards.
- Securing
  These topics describe the security features of HCL Commerce and how to configure these features.
- Performance
  Topics in the Performance section describe the means by which to plan, implement, test, and re-visit the optimization of HCL Commerce site performance.
- Troubleshooting
  Topics in the Troubleshooting section highlight common issues that are encountered with HCL Commerce, and how they can be addressed or mitigated.
  - Contacting HCL Customer Support
    HCL Customer Support provides assistance with product defects. Contact HCL if you require assistance with an HCL Commerce problem.
  - MustGather requirements for HCL Support
    Use the following topics to gather the required information that you need to troubleshoot issues that you are facing with HCL Commerce with HCL Support.
  - Installation issues
    Installing and uninstalling HCL Commerce encompass a wide range of procedures. If you encounter problems, refer to the following resources for assistance.
  - Integration issues
    Integrating HCL Commerce encompass a wide range of procedures. If you encounter problems, refer to the following resources for assistance.
  - General issues
    Review the following information when you encounter any general problems with HCL Commerce.
  - Migration issues
    Migrating HCL Commerce involves a wide range of steps across your different environments. If you encounter problems, refer to the following resources for assistance.
    - Missing Store configuration properties in Management Center
      After you migrate your Madison store or Elite store to HCL Commerce Version 9.0, Store configuration features in Management Center for HCL Commerce go missing.
    - Transaction server error after struts 2 migration
      After you migrate your local store to Struts 2 you might see an error in the Transaction server log similar to StrutsViewExecUnit StrutsViewExecUnit CMN0203E: Command not found. You can resolve this error using one of the default Struts actions.
    - Resetting passwords not working after local store migration
      After migrating a store from an earlier version of WebSphere Commerce to HCL Commerce Version 9.0, otherwise known as a migrated local store, password resets no longer function in Management Center for HCL Commerce or on the Aurora-based storefront.
    - Adding a product to a wishlist as a guest shopper
      After migrating from WebSphere Commerce Version 7 to HCL Commerce Version 9.0 or HCL Commerce Version 9.1, wishlist functionality does not function as expected.
    - Database migration check fails
      During the migration of your HCL Commerce database, an error is encountered when running the pre-migration check due to missing records suggesting an association between a catalog group and a store in the STORECGRP table.
    - Database migration fails due to database user mismatch
      During the migration of your HCL Commerce database, a permissions error (SQLCODE=-551) is encountered when running the database migration.
    - 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.
    - Unintended question mark included in migrated environment e-mail notification
      After migrating from IBM Websphere Commerce Version 7 or IBM Websphere Commerce Version 8 to HCL Commerce Version 9.0, an unintended question mark character ('?') is included in Shipping and Order confirmation and cancellation email notifications.
    - Bundle cross-sell merchandising functionality does not work after migration
      After migrating from IBM Websphere Commerce Version 7 or IBM Websphere Commerce Version 8 to HCL Commerce Version 9.0, cross-sell merchandising bundle functionality does not work as expected.
  - Logging issues
    If you encounter problems while you use HCL Commerce logging, refer to the following troubleshooting information to help determine the problem and find possible solutions.
  - Access control issues
    Access control problems are often indicated by generic application errors with error message keys such as _ERR_USER_AUTHORITY. The first step in problem determination is to enable tracing for the access control component.
  - Aurora starter store
    If you encounter problems when you use the Aurora starter store, refer to the troubleshooting information to help determine the problem and find possible solutions.
  - Member group issues
- Reference
  Topics in the Reference section contain all of the HCL Commerce reference documentation.

Troubleshooting: Database migration fails due to database user mismatch

During the migration of your HCL Commerce database, a permissions error (SQLCODE=-551) is encountered when running the database migration.

Problem

During the migration of your HCL Commerce database, a permissions error (SQLCODE=-551) is encountered when running the database migration.

For example, running the wcim_ant command in a manner similar to the following:

./wcim_ant.sh -tier db -action migrate -from 80 -instanceName demo -isStaging true -defaultTablespace yes

Produces an error similar to the following:

com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=WCS;REPLACE TRIGGER;WCS.PERF_PX8, DRIVER=4.19.66

Solution

In this case, triggers that are present in the database were created and are owned by a database user other than the schema owner. This mismatch of ownership of the triggers causes the failure, and must be changed to successfully complete the migration.

For example, use the following SQL to transfer the ownership of the trigger PERF_PX8 to the WCS user.

TRANSFER OWNERSHIP OF TRIGGER PERF_PX8 TO USER WCS;

Once all problematic triggers are re-assigned to the appropriate user, re-run the database migration.