
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:
- 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.
- Run the following SQL against your
database.
The error is no longer encountered.