Collecting MustGather data for general order issues
Prepare the following MustGather information before you call HCL Support to help with general order issues.
Procedure
-
Configure the following trace strings.
- In the Transaction server Docker container:
For information about how to set trace strings, see Configuring logging for the Transaction server.com.ibm.websphere.commerce.WC_ORDER=all:com.ibm.websphere.commerce.WC_CALCULATION=all:com.ibm.websphere.commerce.WC_INVENTORY=all:com.ibm.websphere.commerce.WC_USER=all
- In the Transaction server Docker container:
-
Reproduce the problem.
Record the specific steps that you used to reproduce the problem and any details that might be relevant.
-
Collect the following files.
- From the Transaction server Docker container:
- /opt/ol/wlp/usr/servers/transactionServer/logs/container/ts_"$HOSTNAME/messages.log
- /opt/ol/wlp/usr/servers/transactionServer/logs/container/ts_"$HOSTNAME/trace.log
- From the Transaction server Docker container:
-
Run the following database queries to collect the necessary information from your database
(output results in CSV format).
SELECT * FROM SITE SELECT * FROM STORE WHERE STORE_ID = {YOUR_STORE_ID} SELECT * FROM ORDERS WHERE ORDERS_ID = {YOUR_STORE_ID} SELECT * FROM ORDERITEMS WHERE ORDERS_ID = {YOUR_STORE_ID}