Technote

(troubleshooting)
CMN1011E: Unable to retrieve the price for catEntry
Problem(Abstract)
You are unable to retrieve the price for an item where the price is defined and receive the following message:

CMN1011E: Unable to retrieve the price for catEntry 40704, quantity: 1.0, UOM: C62, currency: USD.
Cause There is no offer defined for the catalog entry, given the specified quantity and unit of measure. Diagnosing the problem Ensure that a price exists for the catalog entry in the database. You can find the price of the catalog entry by entering the following SQL statement:

select OFFERPRICE.PRICE from OFFERPRICE, OFFER where OFFER.CATENTRY_ID=40704 and OFFERPRICE.OFFER_ID=OFFER.OFFER_ID

The error indicates a specific currency, ensure that there is an offer for the catentry_id and the currency.

If this entry exists, ensure that the catalog entry exists for the specified unit of measure (UOM). You can find the unit of measure for the catalog entry by entering the following SQL statement:
select QUANTITYMEASURE from CATENTSHIP where CATENTRY_ID=40704 Resolving the problem If required, add the price using WebSphere Commerce Accelerator:
http://publib.boulder.ibm.com/infocenter/wc56help/index.jsp?topic=/com.ibm.commerce.user.doc/tasks/tpnsadpr.htm
If required, ensure that the unit of measure is set up correctly for shipping:
http://publib.boulder.ibm.com/infocenter/wc56help/index.jsp?topic=/com.ibm.commerce.user.doc/tasks/tpnchunit.htm
Cross Reference information
Segment Product Component Platform Version Edition
Commerce WebSphere Commerce Enterprise Configuration AIX, i5/OS, Linux, Solaris, Windows 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4 Enterprise
Commerce WebSphere Commerce Business Edition Configuration AIX, i5/OS, Linux, Solaris, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4 Business Edition
Commerce WebSphere Commerce - Express Configuration i5/OS, Linux, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4 Express
Commerce WebSphere Commerce Developer Enterprise Configuration Windows 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4 Enterprise
Commerce WebSphere Commerce Developer Business Edition Configuration Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4 Developer Business Edition
Commerce WebSphere Commerce Developer Professional Edition Configuration Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4, 5.6.1.4 Developer Professional Edition
Commerce WebSphere Commerce Developer Express Configuration Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4 Developer Express
   

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21229187