Recopilación de datos MustGather para problemas con el envío y los impuestos

• En la 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

  Para obtener información sobre las cadenas de rastreo, consulte Configuración del registro de Transaction server.

Registre los pasos específicos que ha utilizado para reproducir el problema y cualquier detalle que pueda ser relevante.

• Desde la 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