Collecting MustGather data for store catalog filter issues

Prepare the following MustGather information before you call IBM Support to help with store catalog filter issues.

Procedure

1. Configure the following trace string in the Search server Docker container.

   *=info:com.ibm.commerce.rest.*=all:com.ibm.commerce.foundation.*=all:

   For information about how to set trace strings, see Configure logging for the Search Server.

2. Reproduce the problem.

   Record the specific steps that we used to reproduce the problem and any details that might be relevant.

3. 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 displayed incorrectly.

4. Run the following database queries to collect the necessary information from the 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