Collecting MustGather data for DOM inventory, pick up in store, or store locator issues

Prepare the following MustGather information before you call HCL Support to help with DOM inventory, BOPIS, or store locator issues.

Procedure

  1. Configure the following trace strings.
    • In the Transaction server Docker container:
      com.ibm.websphere.commerce.WC_SERVER=all:com.ibm.websphere.commerce.WC_INVENTORY=all:com.ibm.websphere.commerce.WC_ORDER=all:com.ibm.commerce.foundation.*=all:com.ibm.commerce.inventory.facade.server.commands.*=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.inventory/
      • /opt/WebSphere/AppServer/profiles/default/installedApps/localhost/ts.ear/xml/config/com.ibm.commerce.inventory.external/
  4. Run the following database queries to collect the necessary information from your database (output results in CSV format).
    SELECT * FROM STLOC 	
    SELECT * FROM INVAVL 	
    SELECT * FROM INVCNF 	
    SELECT * FROM CATENTRY WHERE CATENTRY_ID = {YOUR_CATENTRY_ID} 
    SELECT * FROM FFMCENTER 	
    SELECT * FROM STORE 	
    SELECT INVENTORYSYSTEM FROM STORE WHERE STORE_ID = {YOUR_STORE_ID} 	
    SELECT * FROM INVCNFREL 	
    SELECT * FROM STLFFMREL 	
    SELECT * FROM RECEIPT 	
    SELECT * FROM INVENTORY 	
    SELECT * FROM GEONODE 	
    SELECT * FROM GEOTREE