Collecting MustGather data for attribute dictionary issues

Prepare the following MustGather information before you call HCL Support to help with attribute dictionary issues.

Procedure

  1. Configure the following trace strings in the Transaction server Docker container.
    com.ibm.commerce.tools.*=all: com.ibm.commerce.catalog.*=all: com.ibm.commerce.foundation.*=all: com.ibm.websphere.commerce.WC_SERVER=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
      • /opt/WebSphere/AppServer/profiles/default/installedApps/localhost/ts.ear/xml/config/com.ibm.commerce.catalog/wc-component.xml
    • From the Store server Docker container.
      • /opt/WebSphere/Liberty/usr/servers/default/apps/crs.ear/crs-web.war/WEB-INF/xml/config/com.ibm.commerce.catalog/*
  4. Run the following database queries to collect the necessary information from your database (output results in CSV format).
    SELECT * FROM CATENTRY where CATENTRY_ID in (<catentry>) > CATENTRY.csv
    SELECT * FROM CATENTRYATTR where CATENTRY_ID in (<catentry>) > CATENTRYATTR.csv
    SELECT * FROM ATTR where ATTR_ID in (SELECT ATTR_ID FROM CATENTRYATTR where CATENTRY_ID in (<catentry>)) > ATTR.csv
    SELECT * FROM ATTRVAL where ATTR_ID in (SELECT ATTR_ID FROM CATENTRYATTR where CATENTRY_ID in (<catentry>))  > ATTRVAL.csv
    SELECT * FROM ATTRVALDESC where ATTR_ID in (SELECT ATTR_ID FROM CATENTRYATTR where CATENTRY_ID in (<catentry>)) > ATTRVALDESC.csv
    SELECT * FROM ATTRDESC where ATTR_ID in (SELECT ATTR_ID FROM CATENTRYATTR where CATENTRY_ID in (<catentry>)) > ATTRDESC.csv
    SELECT * FROM ATTRDICT > ATTRDICT.csv
    SELECT * FROM STOREENT > STOREENT.csv
    SELECT * FROM ATTRDICTGRP- >ATTRDICTGRP.csv
    SELECT * FROM ATTRDICTGRPATTRREL where ATTR_ID in (SELECT ATTR_ID FROM CATENTRYATTR where CATENTRY_ID in (<catentry>)) > ATTRDICTGRPATTRREL.csv
    SELECT * FROM ATTRDICTGRPDESC > ATTRDICTGRPDESC.csv
    SELECT * FROM ATTRDICTGRPREL > ATTRDICTGRPREL.csv