HCL Commerce Version 9.1.11.0 or later

Troubleshooting: 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. The error observed in the Management Center Message Console is CWXFD3134E: Execution of get request failed.

Problem

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.

The error can be observed on migrated or upgraded environments originating on IBM Websphere Commerce Version 7, IBM Websphere Commerce Version 8, or HCL Commerce Version 9.1 post-9.1.11.0.

The error observed in the Management Center Message Console is CWXFD3134E: Execution of get request failed.

Solution

The error is caused by missing data within the CMDREG database table.
  • Upgrade to HCL Commerce 9.1.16.0 or greater.
  • If you are using a version of HCL Commerce lower than 9.1.16.0:
    1. Run the following SQL against your database.
      insert into cmdreg values(0, 'com.ibm.commerce.catalog.facade.server.commands.FetchCatalogFilterCmd+/CatalogFilter[CatalogFilterIdentifier[UniqueID=] and ProductSetSelection[@selection=]]', null, 'com.ibm.commerce.catalog.facade.server.commands.FetchCatalogFilterCatalogEntryCmdImpl', null, null, 'Local', 0);
    2. Restart the Transaction server.

The error is no longer encountered.