Collecting MustGather data for store catalog filter issues
Prepare the following MustGather information before you call HCL Support to help with store catalog filter issues.
Procedure
-
Configure the following trace string in the Search server Docker container.
For information about how to set trace strings, see Configuring logging for the Search server.*=info:com.ibm.commerce.rest.*=all:com.ibm.commerce.foundation.*=all:
-
Reproduce the problem.
Record the specific steps that you used to reproduce the problem and any details that might be relevant.
-
Collect the following files from the Search server Docker container.
- /opt/WebSphere/Liberty/usr/servers/default/logs/trace*.log
Also collect the following information.- Name or ID's of the catalog filter, catalog, and store.
- Screen-shot of the catalog filter in Management Center.
- Name of product or category that is displayed incorrectly.
-
Run the following database queries to collect the necessary information from your database
(output results in CSV format).
select * from EXPRESSION where catfilter_id =<catfilter_id in question> select * from CATFILTER where catfilter_id=<catfilter_id in question> select * from CFCONDVAL select * from CFCONDGRP select * from CFCOND select * from CFPRODUCTSET select * from CATFLTDSC select * from CFCATGROUP select * from STOREEENT select * fom PRODUCTSET select * fom CATALOG select * from STORECNTR select * from PSETADJMNT