JR56367: Order submit will fail with migrated, unique promotion codes after installation of JR54507

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 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