Collecting MustGather data for catalog tool issues

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

Procedure

  1. Configure the following trace strings in the Transaction server Docker container.
    com.ibm.websphere.commerce.WC_CATALOG=all:com.ibm.commerce.foundation.*=all:com.ibm.websphere.commerce.WC_SERVER=all:com.ibm.commerce.foundation.client.lobtools.*=all:com.ibm.commerce.catalog.*=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/SystemOut*.log
      • /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 CATALOG > CATALOG.csv
    select * from CATENTRY > CATENTRY.csv
    select * from CATGPENREL > CATGPENREL.csv
    select * from CATENTREL > CATENTREL.csv
    select * from CATGROUP > CATGROUP.csv
    select * from CATENTDESC > CATENTDESC.csv
    select * from STOREENT > STOREENT.csv
    select * from STORECENT > STORECENT.csv
    select * from STORECGRP > STORECGRP.csv
    select * from CATGRPREL > CATGRPREL.csv
    select * from DISPCGPREL > DISPCGPREL.csv
    select * from DISPENTREL > DISPENTREL.csv
    select * from CATTOGRP > CATTOGRP.csv
    select * from STORECAT > STORECAT.csv
    select * from STORE > STORE.csv