JR54805: Exception occurs when generating unique promotion codes by using the Promotions Tool in Management Center on iSeries databases

APAR status

• Closed as program error.

Error description

• You might encounter an exception similar to the following in the
  log if you are using an iSeries database and you try to
  generate promotion codes by using the Promotions Tool in
  Management Center:
  
  0000000d CommerceSrvr  E TransactionManagerbegin(int) CMN0409E:
  The following error occurred during processing: "Cannot start a
  new UOW. A LocalTransactionContainment is already active with
  work.". java.lang.IllegalStateException: Cannot start a new UOW.
   A LocalTransactionContainment is already active with work.
      at
  com.ibm.ws.LocalTransaction.LTCUOWCallback.uowPreBegin(LTCUOWCal
  lback.java:252)
      at
  com.ibm.ws.LocalTransaction.LTCUOWCallback.contextChange(LTCUOWC
  allback.java:168)
      at
  com.ibm.ws.uow.UOWScopeCallbackManager.notifyCallbacks(UOWScopeC
  allbackManager.java:69)
      at
  com.ibm.ws.tx.jta.UserTransactionImpl.begin(UserTransactionImpl.
  java:160)
      at
  com.ibm.commerce.server.TransactionManager.begin(TransactionMana
  ger.java:124)
      at
  com.ibm.commerce.server.TransactionManager.begin(TransactionMana
  ger.java:67)
      at
  com.ibm.commerce.promotion.uniquecode.commands.UniquePromotionCo
  desCleanCmdImpl.executeStatement(UniquePromotionCodesCleanCmdImp
  l.java:308)
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce Version 7 or 8 users on iSeries databases who
  use Management Center to create promotions with unique promotion
  codes.
  
  PROBLEM ABSTRACT:
  Exception occurs when generating unique promotion codes by using
   the Promotions Tool in Management Center on iSeries databases
  
  BUSINESS IMPACT:
  Business users cannot create and activate promotions with unique
   promotion codes by using the Promotions Tool in Management
  Center when on an iSeries database.
  
  RECOMMENDATION:
  

Problem conclusion

• Code was modified to execute an iSeries specific database query
  for retrieving record numbers associated with code entries for
  batch deletion in a separate database transaction.
  

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