Collecting MustGather data for Catalog filter tool issues

Prepare the following MustGather information before you call HCL Support to help with Catalog filter tool issues.

Procedure

  1. Configure the following trace string in the Transaction server Docker container.
    com.ibm.commerce.catalog.*=all: com.ibm.commerce.catalogentry.*=all: com.ibm.commerce.contract.*=all: com.ibm.commerce.foundation.*=all: com.ibm.websphere.commerce.WC_CATALOG=all: com.ibm.websphere.commerce.WC_CONTRACT=all
    For information about how to set trace strings, see Configuring logging for the Transaction 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 Transaction server Docker container.
    • /opt/WebSphere/AppServer/profiles/default/logs/server1/trace*.log
  4. Run the following database queries to collect the necessary information from your database (output results in CSV format).
    select * from EXPRESSION 
    select * from CATFILTER
    select * from CFCONDVAL
    select * from CFCONDGRP
    select * from CFCOND
    select * from CFPRODUCTSET
    select * from CATFLTDSC
    select * from CFCATGROUP
    select * from STOREEENT
    select * from PRODUCTSET
    select * from CATALOG
    select * from STORECNTR
    select * from PSETADJMNT