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

Configure the following trace strings.
- In the Transaction server Docker container:
  For information about how to set trace strings, see Configure logging for the Transaction Server.
Reproduce the problem.
Record the specific steps that we used to reproduce the problem and any details that might be relevant.
Collect the following files.
- From the Transaction server Docker container:
  - /opt/WebSphere/AppServer/profiles/default/installedApps/localhost/ts.ear/xml/config/payments/*.*

Run the following database queries to collect the necessary information from the 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