APAR status
Closed as program error.
Error description
Order submit can fail when using migrated, unique promotion codes after installing JR54507. This will impact promotion codes that have been migrated from WebSphere Commerce version 7 Feature Pack 5, when submitting an order with a promotion code that has already been claimed by another user. An exception similar to the following will be seen in the logs: [7/21/16 7:45:31:469 EDT] 0000004e RedeemPromoti 3 com.ibm.commerce.marketing.commands.RedeemPromotionCodeToOrderCO TaskCmdImpl redeemUniquePromotionCodeToOrder Exception occured while updating PX_CDUSAGE entry com.ibm.commerce.foundation.server.services.dataaccess.exception .QueryServiceSystemException: CWXFD2004E: Invaid parameter key: WORKSPACE.1 in the input SQL query string. at com.ibm.commerce.foundation.internal.server.services.dataaccess. queryservice.SubstitutionHelper.substituteParameters(Substitutio nHelper.java:513) at com.ibm.commerce.foundation.internal.server.services.dataaccess. queryservice.XPathSQLProcessor.prepare(XPathSQLProcessor.java:49 8) at com.ibm.commerce.foundation.internal.server.services.dataaccess. queryservice.QueryComposer.composeQueryInfo(QueryComposer.java:1 24) at com.ibm.commerce.foundation.internal.server.services.dataaccess. queryservice.QueryService.getQueryInfo(QueryService.java:129) at com.ibm.commerce.foundation.internal.server.services.dataaccess. datamediator.jdbc.JDBCDataMediator.getEntityObjects(JDBCDataMedi ator.java:236) at com.ibm.commerce.foundation.server.services.dataaccess.AbstractD ataServiceFacade.getEntityObjects(AbstractDataServiceFacade.java :158) at com.ibm.commerce.foundation.server.services.dataaccess.AbstractD ataServiceFacade.getPhysicalDataContainer(AbstractDataServiceFac ade.java:85) at com.ibm.commerce.marketing.commands.RedeemPromotionCodeToOrderCO TaskCmdImpl.redeemUniquePromotionCodeToOrder(RedeemPromotionCode ToOrderCOTaskCmdImpl.java:199) at com.ibm.commerce.marketing.commands.RedeemPromotionCodeToOrderCO TaskCmdImpl.performExecute(RedeemPromotionCodeToOrderCOTaskCmdIm pl.java:290) at com.ibm.commerce.command.ECCommandTarget.executeCommand(ECComman dTarget.java:157) at com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCach e.java:332) at com.ibm.websphere.command.CacheableCommandImpl.execute(Cacheable CommandImpl.java:166) at com.ibm.commerce.command.MeasuredCacheableCommandImpl.execute(Me asuredCacheableCommandImpl.java:63) at com.ibm.commerce.command.AbstractECTargetableCommand.execute(Abs tractECTargetableCommand.java:199) at com.ibm.commerce.marketing.promotion.runtime.PromotionArgument.r edeemCode(PromotionArgument.java:1086) at com.ibm.commerce.marketing.promotion.runtime.PromotionArgument.f inalizePromotionArgument(PromotionArgument.java:859) at com.ibm.commerce.order.calculation.FinalizeDiscountCalculationUs ageCmdImpl.performExecute(FinalizeDiscountCalculationUsageCmdImp l.java:114) at com.ibm.commerce.command.ECCommandTarget.executeCommand(ECComman dTarget.java:157) at com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCach e.java:332) at com.ibm.websphere.command.CacheableCommandImpl.execute(Cacheable CommandImpl.java:166) at com.ibm.commerce.command.MeasuredCacheableCommandImpl.execute(Me asuredCacheableCommandImpl.java:63) at com.ibm.commerce.command.AbstractECTargetableCommand.execute(Abs tractECTargetableCommand.java:199) at com.ibm.commerce.order.calculation.CalculationHelper.finalizeCal culationUsages(CalculationHelper.java:1631)
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce version 7 and WebSphere Commerce version 8 users who have migrated codes from version 7 Feature Pack 5 or earlier with JR54507 installed. This will only affect codes on orders that use migrated promotion codes from Feature Pack 5 or below that have been claimed by another user. PROBLEM ABSTRACT: Order submit will fail with migrated, unique promotion codes after installation of JR54507 BUSINESS IMPACT: Shoppers might not be able to submit their orders with unique promotion codes at storefront. RECOMMENDATION:
Problem conclusion
PX_CDPOOL.WORKSPACE condition check in the query /PX_CDUSAGE[UNIQUE_CODE=] was removed. This will impact promotion codes that have been migrated from WebSphere Commerce version 7 Feature Pack 5, when submitting an order with a promotion code that has been claimed by another user.
Temporary fix
Comments
APAR Information
APAR number
JR56367
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-07-21
Closed date
2018-05-10
Last modified date
2018-05-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WC BUS EDITION
Fixed component ID
5724I3800
Applicable component levels
R700 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
11 December 2021