Collecting MustGather data for attribute dictionary issues

Prepare the following MustGather information before you call IBM 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 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/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 the 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