Collecting MustGather data for payment plugin issues

Prepare the following MustGather information before you call HCL Support to help with payment plug-in issues.

Procedure

  1. Configure the following trace strings.
    • In the Transaction server Docker container: 
      com.ibm.websphere.commerce.payments.*=all:com.ibm.websphere.commerce.WC_ORDER=all:com.ibm.websphere.commerce.WC_EDP=all:com.ibm.websphere.commerce.WC_PPC=all:com.ibm.websphere.commerce.WC_PPC_WCPPLUGIN=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/logs/server1/SystemOut*.log
      • /opt/WebSphere/AppServer/profiles/default/logs/server1/trace*.log
      • /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 POLICY WHERE STOREENT_ID IN ({YOUR_STORE_ID}, -1) AND POLICYTYPE_ID ='PAYMENT' 
SELECT * FROM POLICYCMD WHERE POLICY_ID IN (SELECT * FROM POLICY WHERE STOREENT_ID IN ({YOUR_STORE_ID}, -1) AND POLICYTYPE_ID ='PAYMENT') 
SELECT * FROM ORDERS WHERE ORDERS_ID = {YOUR_ORDER_ID} 
SELECT * FROM ORDERITEMS WHERE ORDERS_ID = {YOUR_ORDER_ID} 	
SELECT * FROM EDPORDER WHERE ORDER_ID = {YOUR_ORDER_ID} 	
SELECT * FROM EDPPAYINST WHERE EDPORDER _ID IN ( SELECT EDPORDER_ID FROM EDPORDER WHERE ORDER_ID = {YOUR_ORDER_ID}) 	
SELECT * FROM EDPATMPAY WHERE EDPPAYINST_ID IN ( SELECT EDPPAYINST_ID FROM EDPPAYINST WHERE EDPORDER _ID IN ( SELECT EDPORDER_ID FROM EDPORDER WHERE ORDER_ID = {YOUR_ORDER_ID})) 	
SELECT * FROM PPCPAYINST WHERE ORDER_ID = {YOUR_ORDER_ID} 	
SELECT * FROM PPCPAYMENT WHERE PPCPAYINST_ID IN (SELECT PPCPAYINST_ID FROM PPCPAYINST WHERE ORDER_ID = {YOUR_ORDER_ID}) 	
SELECT * FROM PPCPAYTRAN WHERE PPCPAYMENT_ID IN (SELECT PPCPAYMENT_ID FROM PPCPAYMENT WHERE PPCPAYINST_ID IN (SELECT PPCPAYINST_ID FROM PPCPAYINST WHERE ORDER_ID = {YOUR_ORDER_ID})) 	
SELECT * FROM PPCEXTDATA WHERE PPCPAYINST_ID IN (SELECT PPCPAYINST_ID FROM PPCPAYINST WHERE ORDER_ID = {YOUR_ORDER_ID})