Collecting MustGather data for Store Management issues

Prepare the following MustGather information before you call HCL Support to help with Store Management issues.

Procedure

  1. Configure the following trace strings.
    • In the Transaction server Docker container:
      *=info:com.ibm.commerce.foundation.logging.ServiceLogger=finest:com.ibm.commerce.infrastructure.*=all: com.ibm.commerce.marketing.*=all com.ibm.commerce.tools.devtools.flexflow.*=all: com.ibm.commerce.marketing.*=all
      For information about how to set trace strings, see Configuring logging for the Transaction server.
    • In the Store server Docker container:
      *=info:com.ibm.commerce.foundation.logging.ServiceLogger=finest:com.ibm.commerce.seo.*=all:com.ibm.commerce.component.rest.*=all:com.ibm.commerce.store.*=all
      For information about how to set trace strings, see Configuring logging for the Store server.
  2. Reproduce the problem.

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

  3. Run the following database queries to collect the necessary information from your database (output results in CSV format).
    SELECT * FROM EMSPOT WHERE USAGETYPE='STOREFEATURE'
    SELECT * FROM DMEMSPOTDEF WHERE EMSPOT_ID in (SELECT EMSPOT_ID FROM EMSPOT WHERE USAGETYPE='STOREFEATURE')
    SELECT * FROM STORE
    SELECT * FROM STOREENT