Collecte de données MustGather pour les problèmes d'expédition et d'imposition

• Dans l'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, voir Configuration de la journalisation pour le Transaction server.

Enregistrez les étapes spécifiques que vous avez suivies pour reproduire le problème et les détails qui pourraient être pertinents.

• Depuis Transaction server Docker container :
  • /opt/WebSphere/AppServer/profiles/default/installedApps/localhost/ts.ear/xml/config/payments/*.*

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