Collecting MustGather data for promotion issues

Prepare the following MustGather information before you call IBM Support to help with promotion issues.

Procedure

1. Configure the following trace string Transaction server Docker container.

   com.ibm.websphere.commerce.WC_ORDER=all: com.ibm.websphere.commerce.WC_CALCULATION=all: com.ibm.commerce.marketing.promotion.*=all: com.ibm.commerce.promotion.*=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/installedApps/localhost/ts.ear/xml/PromotionEngineConfiguration/WCSPromotionEngineConfig.xml

4. Run the following database queries to collect the necessary information from the database (output results in CSV format).

   SELECT * FROM PX_PROMOTION where NAME like '%name of the promotion%' and STATUS =1
   SELECT * from PX_PROMOARG where ORDERS_ID = {YOUR_ORDER_ID}
   SELECT * FROM PX_POLICY
   select * from PX_CDPOOL where PX_CDPOOL_ID in (select PX_CDPOOL_ID from PX_CDPROMO where PX_PROMOTION_ID in (select PX_PROMOTION_ID from PX_PROMOTION where name like '%TEST_PROMO%'))
   SELECT * FROM ORDPROMOCD WHERE ORDERS_ID = {YOUR_ORDER_ID}
   select * from ORDERS where ORDERS_ID = {YOUR_ORDER_ID}
   select * from ORDERITEMS where ORDERS_ID = {YOUR_ORDER_ID}
   SELECT * FROM ORDADJUST WHERE ORDERS_ID = {YOUR_ORDER_ID}
   SELECT * FROM ORDIADJUST WHERE ordadjust_id = (SELECT ordadjust_id FROM ordadjust WHERE ORDERS_ID = {YOUR_ORDER_ID})