Collecting MustGather data for Catalog filter tool issues

Prepare the following MustGather information before you call IBM 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 Configure logging for the Transaction 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 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 the 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