IBM WebSphere Commerce - PriceRule related debugging - ResolveOrderItemPriceCmdImpl handleNullPriceException

By Mirsa Mohammed -
Couple of months back in my work I was assigned with an issue of Add to cart not working in our toolkit environment. The error logs was like below.

 [8/1/17 16:43:34:296 CEST] 0000015c CommerceSrvr A com.ibm.commerce.orderitems.commands.ResolveOrderItemPriceCmdImpl handleNullPriceException CMN1011E: Unable to retrieve the price for catEntry 420472, quantity: 1.0, unit of measure: C62, and currency: null.  
 [8/1/17 16:43:34:297 CEST] 0000015c ExtendedInfo I  CWXFR9010I: Extended information : [URL=http://localhost/webapp/wcs/stores/servlet/AjaxOrderChangeServiceItemAdd] [parameters=calculationUsage=-1,-2,-3,-4,-5,-6,-7 orderId=. quantity=1 catalogId=15451 langId=-1 catEntryId=420472 storeId=11352 ] [userId=-1002]   
 [8/1/17 16:43:34:298 CEST] 0000015c MessageMappin C com.ibm.commerce.foundation.server.command.soi.MessageMappingCmdImpl createBusinessObjectDocumentResponse(CommandProperty, ControllerCommand) No customized message mapping error or response cmd found for errorCommand: com.ibm.commerce.exception.ECApplicationException: Unable to retrieve the price for catEntry 420472, quantity: 1.0, unit of measure: C62, and currency: null.  
 [8/1/17 16:43:34:307 CEST] 0000015c BusinessObjec E  Unable to retrieve the price for catEntry 420472, quantity: 1.0, unit of measure: C62, and currency: null.  
                  com.ibm.commerce.foundation.internal.common.exception.FoundationApplicationException: Unable to retrieve the price for catEntry 420472, quantity: 1.0, unit of measure: C62, and currency: null.  
      at com.ibm.commerce.foundation.server.command.soi.MessageMappingCmdImpl.constructFoundationApplicationException(MessageMappingCmdImpl.java:674)  
      at com.ibm.commerce.foundation.server.command.soi.MessageMappingCmdImpl.invokeCommand(MessageMappingCmdImpl.java:317)  
      at com.ibm.commerce.order.facade.server.commands.soi.OrderMessageMappingCmdImpl.invokeCommand(OrderMessageMappingCmdImpl.java:338)  
      at com.ibm.commerce.foundation.server.command.soi.MessageMappingCmdImpl.performAction(MessageMappingCmdImpl.java:176)  
      at com.ibm.commerce.foundation.server.command.soi.MessageMappingCmdImpl.performExecute(MessageMappingCmdImpl.java:136)  
      at com.ibm.commerce.foundation.server.command.bod.BusinessObjectCommandTargetImpl.executeCommand(BusinessObjectCommandTargetImpl.java:112)  
      at com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCache.java:332)  
      at com.ibm.websphere.command.CacheableCommandImpl.execute(CacheableCommandImpl.java:166)  
      at com.ibm.commerce.foundation.server.command.bod.BusinessObjectDocumentProcessor.processBusinessObjectDocument(BusinessObjectDocumentProcessor.java:276)  
      at com.ibm.commerce.order.facade.server.OrderFacadeImpl.changeOrder(OrderFacadeImpl.java:79)  
      at com.ibm.commerce.order.facade.server.EJSLocalStatelessOrder_a357eec5.changeOrder(EJSLocalStatelessOrder_a357eec5.java:165)  
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)  
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)  
      at java.lang.reflect.Method.invoke(Method.java:611)  
      at com.ibm.commerce.foundation.internal.client.services.invocation.impl.LocalEJBInvocationBindingImpl.invoke(LocalEJBInvocationBindingImpl.java:211)  
      at com.ibm.commerce.foundation.internal.client.services.invocation.InvocationService.invoke(InvocationService.java:113)  
      at com.ibm.commerce.foundation.client.facade.bod.AbstractBusinessObjectDocumentFacadeClient.internalSendBusinessObjectDocument(AbstractBusinessObjectDocumentFacadeClient.java:813)  
      at com.ibm.commerce.foundation.client.facade.bod.AbstractBusinessObjectDocumentFacadeClient.sendBusinessObjectDocument(AbstractBusinessObjectDocumentFacadeClient.java:529)  
      at com.ibm.commerce.order.facade.client.AbstractOrderFacadeClient.changeOrder(AbstractOrderFacadeClient.java:210)  
      at com.ibm.commerce.order.facade.client.CommonOrderFacadeClient.changeOrder(CommonOrderFacadeClient.java:3496)  
      at com.ibm.commerce.order.facade.client.CommonOrderFacadeClient.addOrderItem(CommonOrderFacadeClient.java:3010)  
      at com.ibm.commerce.order.facade.client.CommonOrderFacadeClient.addOrderItem(CommonOrderFacadeClient.java:1340)  
      at com.ibm.commerce.order.facade.client.OrderFacadeClient.addOrderItem(OrderFacadeClient.java:288)

Looking at the error logs I was thinking may be somehow currency is becoming null somewhere in the flow and that is causing this issue. For debugging that I enabled logs for different pricerule related classes.

com.ibm.commerce.price.commands.PriceRuleGetContractUnitPriceCmdImpl
com.ibm.commerce.price.rule.commands.InternalRuleEngineExecutePriceRuleCmdImpl
com.ibm.commerce.price.rule.runtime.engine.PriceRuleEngine
com.ibm.commerce.price.rule.runtime.util.PriceRuleHelper

But after enabling the logs for PriceRuleEngine and PriceRuleHelper I came to know that it is not the currency which is causing the issue but an invalid price rule. Then I verified the price rule configuration from Management center and found that for the price rule defined for this particular store there is no contracts assigned.



Then I followed below knowledge center URL to assign the store contract to the price rule from Commerce Accelerator which resolved the issue.

https://www.ibm.com/support/knowledgecenter/en/SSZLC2_7.0.0/com.ibm.commerce.management-center.doc/tasks/tpictassignb2c.htm

Hope this help someone. Let me know your thoughts through the comment section. Feel free to share this page 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

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+SzSS...
Read more