IBM WebSphere Commerce - Payment related debugging - AEDPPIEditCtrlCmdImpl getOrderIdByEDPPIID

By Mirsa Mohammed -
Here I am going to share my recent experience in debugging a payment related issue. This issue started occurring all of a sudden without any recent changes to the code. All the orders were failing after entering the payment information. Error log for the issue was as below.

 [9/27/17 0:31:23:137 EST] 0000002e CommerceSrvr A AEDPPIEditCtrlCmdImpl getOrderIdByEDPPIID Object of type payment instruction with primary key 79,172 could not be found in the database.   
 [9/27/17 0:31:23:139 EST] 0000002e ExtendedInfo I  CWXFR9010I: Extended information : [URL=http://localhost/webapp/wcs/stores/servlet/webapp/wcs/stores/servlet/XPaymentProcessCmd] [parameters=signature=+Yuun7p7fwRo6hgHvdf4CBz2lNvrKUN/BtKbQZgFsue= encryptedparameters=2SDSwUkztXgotmmLbKuB+P2ZoiX1Rd65ai3932yezsdHLI2wb1deUvHoNKzaP9KvXsedZd0SgLBWjv+COHyZXTLyFEDXBcfCcYBFzkgTc2JdTl3XAjKai4KbGp0sJ8haesjbeZKIavF6AK7LjdsF05guWvsEkQ6ymn7OvK9UvLrIQDTT1/UNW4i9G/qXJ3WIYp3H8E1BCHS+HfFj/1wS/ORpartRTNxwYCloHwT4qjPVr/toH2LWtzNTICMEdgJ4We+SzSSSNBUHfoK1MAsIfMrJHDS30oinKS2cB3wEky4OWMDR671sQ+KkwRSj3CVwvjO6GOBvJz4lcA9FOADqfOKW6Abes8VvR4GfRKYXM72HECWlePqqNKIjsYvwiOlz2ASf ] [userId=-1002]


There was no clue what is causing the issue. But we proceeded with our investigation by going through and understanding out-of-the-box code for AEDPPIEditCtrlCmdImpl.getOrderIdByEDPPIID because from the errors we can see the error is thrown from that command and method.

From the out-of-the-box command we could see the logic is trying to find orderId from EDPORDER DB table. And for that they are first trying to find the EDPPAYINST using the piId received and it was failing at this step.

The reason for the failure was out-of-the-box logic is expecting both PPCPAYINST_ID and EDPPAYINST_ID are equal, but in our case for the failed orders both of these values were different. The reason for this could be a manual insert in any of PPCPAYINST or EDPPAYINST tables which caused both these payment instruction IDs to be out of sync. And the fix for the issue was a server restart, because after a server restart new values will be fetched from KEYS table for these tables and that brought back both PPCPAYINST_ID and EDPPAYINST_ID values in sync.

Hope this helps someone. If you find this helpful please share with your friends and colleagues.

Thanks!

Comments

Post a Comment

Popular posts from this blog

Applied promotions of an order - IBM WebSphere Commerce

By Mirsa Mohammed -
In this post we will see how we can get the name and other details of promotions already applied to an order from a controller command. These details are stored in the PX_PROMOARG table in XML format. So for this task we need to fetch the PromotionArgument object for the order from the PX_PROMOARG table. This is achieved using PromotionArgumentSessionBeanPersistenceManager, this class provides a load() method which accepts OrderKey using which we can load the PromotionArgument for the order. From the PromotionArgument we can get the list of PromotionExecutionRecords. Below is sample code to get all the promotions applied to an order and print the name and description of the promotions. OrderKey ordKey = new OrderKey(new Long(orderId)); PromotionArgumentSessionBeanPersistenceManager promoManager = new PromotionArgumentSessionBeanPersistenceManager(); PromotionArgument promArg = promoManager.load(ordKey); Iterator prmoExeRecds = promArg.getPromotionExecutionRecords(); ...
Read more

Creating and adding elements to a list in JSTL

By Mirsa Mohammed -
There are plenty of places in WebSphere Commerce out-of-the-box code where we can see code to iterate over a list in JSTL. But I feel that code to create and add items to list in JSTL are rare and hence lot of developers (atleast beginners) do not know how to do that. I recently came across and used this code to create and add items to an arraylist in JSP using JSTL. And I thought I need to note it down somewhere so I can refer in future. Sample code below: <wcf:useBean var="sampleList" classname="java.util.ArrayList"/> ... <c:set var="sampleVar" value="val"/> <wcf:set target="${sampleList}" value="${sampleVar}"/> Once you created the list, you can iterate through and process it as required. <c:forEach items="${sampleList}" var="eachVal"> <c:out value="${eachVal}" /> </c:forEach> Hope this help someone. Feel free to share t...
Read more