Troubleshooting: Catalog filter exception in migrated environment
After you migrate 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 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 is only observed on migrated environments originating on IBM Websphere Commerce Version 7.
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.
- 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);
- Restart the Transaction server.
The error is no longer encountered.