Collecting MustGather data for shipping and tax issues

Prepare the following MustGather information before you call IBM Support to help with shipping and tax issues.

Procedure

  1. Configure the following trace strings.
    • In the Transaction server Docker container:
      com.ibm.websphere.commerce.WC_ORDER=all: com.ibm.websphere.commerce.WC_CALCULATION=all: com.ibm.websphere.commerce.WC_MARKETING=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/installedApps/localhost/ts.ear/xml/config/payments/*.*
  4. Run the following database queries to collect the necessary information from your database (output results in CSV format).
    SELECT * FROM SITE 
    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 ORDERITEMS_ID IN (SELECT ORDERITEMS_ID FROM ORDERITEMS WHERE ORDERS_ID=YOUR_ORDER_ID)
    SELECT * FROM JURST WHERE SUBCLASS IN (1,2) ORDER BY STOREENT_ID 
    SELECT * FROM JURSTGROUP WHERE SUBCLASS IN (1,2) ORDER BY STOREENT_ID
    SELECT * FROM JURSTGPREL WHERE JURSTGROUP_ID IN (SELECT JURSTGROUP_ID FROM JURSTGROUP WHERE SUBCLASS IN (1,2)) 
    SELECT * FROM TAXCGRY WHERE TAXTYPE_ID IN (-3, -4) ORDER BY STOREENT_ID
    SELECT * FROM TAXCGRYDS WHERE TAXCGRY_ID IN (SELECT TAXCGRY_ID FROM TAXCGRY WHERE TAXTYPE_ID IN(-3, -4))
    SELECT * FROM CALCODE WHERE CALUSAGE_ID IN (-2,-3,-4) ORDER BY STOREENT_ID
    SELECT * FROM CALCODEDSC WHERE CALCODE_ID IN (SELECT CALCODE_ID FROM CALCODE WHERE CALUSAGE_ID IN (-2, -3, -4)) ORDER BY CALCODE_ID 
    SELECT * FROM CALCODEMGP WHERE CALCODE_ID IN (SELECT CALCODE_ID FROM CALCODE WHERE CALUSAGE_ID IN (-2, -3, -4))
    SELECT * FROM CALRULE WHERE CALCODE_ID IN (SELECT CALCODE_ID FROM CALCODE WHERE CALUSAGE_ID IN (-2, -3, -4)) ORDER BY CALCODE_ID
    SELECT * FROM CALRULEMGP WHERE CALRULE_ID IN (SELECT T1.CALRULE_ID FROM CALRULE T1, CALCODE T2 WHERE T1.CALCODE_ID=T2.CALCODE_ID AND T2.CALUSAGE_ID IN (-2, -3, -4)) ORDER BY CALRULE_ID
    SELECT * FROM TAXJCRULE WHERE CALRULE_ID IN (SELECT T1.CALRULE_ID FROM CALRULE T1, CALCODE T2 WHERE T1.CALCODE_ID=T2.CALCODE_ID AND T2.CALUSAGE_ID IN (-3, -4))
    SELECT * FROM CALSCALE WHERE CALUSAGE_ID IN (-2, -3, -4) ORDER BY STOREENT_ID
    SELECT * FROM CALSCALEDS WHERE CALSCALE_ID IN (SELECT CALSCALE_ID FROM CALSCALE WHERE CALUSAGE_ID IN (-2, -3, -4)) ORDER BY CALSCALE_ID
    SELECT * FROM CALRANGE WHERE CALSCALE_ID IN (SELECT CALSCALE_ID FROM CALSCALE WHERE CALUSAGE_ID IN (-2, -3, -4)) ORDER BY CALSCALE_ID
    SELECT * FROM CALRLOOKUP WHERE CALRANGE_ID IN (SELECT T1.CALRANGE_ID FROM CALRANGE T1, CALSCALE T2 WHERE T1.CALSCALE_ID=T2.CALSCALE_ID AND T2.CALUSAGE_ID IN (-2, -3, -4)) ORDER BY CALRANGE_ID
    SELECT * FROM CRULESCALE WHERE CALRULE_ID IN (SELECT T1.CALRULE_ID FROM CALRULE T1, CALCODE T2 WHERE T1.CALCODE_ID=T2.CALCODE_ID AND T2.CALUSAGE_ID IN (-2, -3, -4)) ORDER BY CALRULE_ID
    SELECT * FROM CATENCALCD WHERE CALCODE_ID IN (SELECT CALCODE_ID FROM CALCODE WHERE CALUSAGE_ID IN (-2, -3, -4)) ORDER BY STORE_ID
    SELECT * FROM CATGPCALCD WHERE CALCODE_ID IN (SELECT CALCODE_ID FROM CALCODE WHERE CALUSAGE_ID IN (-2, -3, -4)) ORDER BY STORE_ID
    SELECT * FROM STENCALUSG WHERE CALUSAGE_ID IN (-2, -3, -4) ORDER BY STOREENT_ID
    SELECT * FROM CALUSAGE WHERE CALUSAGE_ID=-2
    SELECT * FROM CALMETHOD WHERE CALUSAGE_ID=-2 ORDER BY STOREENT_ID
    SELECT * FROM ORDCALCD WHERE CALCODE_ID IN (SELECT CALCODE_ID FROM CALCODE WHERE CALUSAGE_ID=-2) ORDER BY ORDERS_ID
    SELECT * FROM ORDICALCD WHERE CALCODE_ID IN (SELECT CALCODE_ID FROM CALCODE WHERE CALUSAGE_ID=-2) ORDER BY ORDERITEMS_ID
    SELECT * FROM SHPJCRULE WHERE CALRULE_ID IN (SELECT T1.CALRULE_ID FROM CALRULE T1, CALCODE T2 WHERE T1.CALCODE_ID=T2.CALCODE_ID AND T2.CALUSAGE_ID=-2) ORDER BY CALRULE_ID 
    SELECT * FROM SHIPMODE ORDER BY STOREENT_ID
    SELECT * FROM SHPMODEDSC ORDER BY SHIPMODE_ID
    SELECT * FROM FFMCENTER ORDER BY MEMBER_ID
    SELECT * FROM SHPARRANGE ORDER BY STORE_ID
    SELECT * FROM SHPARJURGP