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

  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 Configuring logging for the Search server.
  2. Reproduce the problem.

    Record the specific steps that you 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 that is displayed incorrectly.
  4. 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