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 upgrade fails due to pre-existing msgtype_ID
After migrating or upgrading to a version of HCL Commerce 9.1.11.0 or greater, the updatedb process can fail due to a pre-existing msgtype_ID of 10002.

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.1, 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.
  - The Must-Gather application
    The Must-Gather application helps collect troubleshooting information required to resolve HCL Commerce issues.
  - Store issues
    Review the following information when you encounter with any problems related to HCL Commerce stores.
  - 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.1, 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.1, 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.
    - Catalog filter exception in migrated or upgraded environment
      After you migrate or update your environment to a later version of HCL Commerce, an error is encountered when opening or creating a catalog filter within the Catalog Filter and Pricing tool within Management Center for HCL Commerce.
    - 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.
    - 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.1, 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.1, cross-sell merchandising bundle functionality does not work as expected.
    - Database upgrade fails due to pre-existing msgtype_ID
      After migrating or upgrading to a version of HCL Commerce 9.1.11.0 or greater, the updatedb process can fail due to a pre-existing msgtype_ID of 10002.
  - Search issues
    If you encounter problems while you use HCL Commerce Search, refer to the troubleshooting information to help determine the problem and find possible solutions.
  - 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.

HCL Commerce Version 9.1.11.0 or later

Troubleshooting: Database upgrade fails due to pre-existing `msgtype_ID`

After migrating or upgrading to a version of HCL Commerce 9.1.11.0 or greater, the updatedb process can fail due to a pre-existing msgtype_ID of 10002.

This msgtype_ID is intended to be used by SellerOrderNotify within the marketplace functionality in HCL Commerce releases 9.1.11.0 and greater.

Problem

After migrating or upgrading to a version of HCL Commerce 9.1.11.0 or greater, the updatedb process can fail due to a pre-existing msgtype_ID of 10002.

Solution

Update the bootstrap database schema file to use a different msgtype_ID value.

Open schema/data/xml/9.1.11/wcs.9.1.11.0.bootstrap.xml for editing.

Replace the following msgtype_ID value:

<msgtypes msgtype_id="10002" msgtdir="1" name="SellerOrderNotify" viewname="SellerOrderNotifyView" description="Seller Order Notification Message" />
<profile profile_id="-10001" store_id="0" devicefmt_id="-3" transport_id="1" msgtype_id="10002" usersview="N" lowpriority="0" highpriority="0" />
<profnvstrg profnvstrg_id="13" profile_id="-10001" profileattname="subject_key" profileattvalue="_TXT_SELLER_ORDER_RECEIVED" />

With:

<msgtypes msgtype_id="-628" msgtdir="1" name="SellerOrderNotify" viewname="SellerOrderNotifyView" description="Seller Order Notification Message" />
<profile profile_id="-10001" store_id="0" devicefmt_id="-3" transport_id="1" msgtype_id="-628" usersview="N" lowpriority="0" highpriority="0" />
<profnvstrg profnvstrg_id="13" profile_id="-10001" profileattname="subject_key" profileattvalue="_TXT_SELLER_ORDER_RECEIVED" />

Save and close the file.

Apply this patch to the Order-OrderCaptureLogic module. This patch specifically modifies the OrderNotifyCmdImpl and OrderPaymentSynchronizeCmdImpl classes.

The updatedb process will now complete as expected.