JR56426: DuplicateKeyException occurs when a CSR attempts to access a locked order

7.0.0.9-WS-WCServer-IFJR56426
7.0.0.9-WS-WCDeveloper-IFJR56426

APAR status

• Closed as program error.

Error description

• A duplicated key exception on the CTXMGT table occurs when a
  customer service representative (CSR) tries to access an order
  that is currently locked by the shopper.
  
  The following error is expected:
  [7/11/16 2:51:04:886 CDT] 00000e5c AbstractBaseR E
  com.ibm.commerce.foundation.rest.resourcehandler.AbstractBaseRes
  ourceHandler handleException(String, Exception, String)
  CWXFR0200E: The following exception occurred in method
  updateOrderItem(String, String):
  com.ibm.commerce.foundation.rest.bodmapping.BODException: null:
  Order 784501 is not locked by you. Another user might have taken
   over the lock..
  
  But the following error is not expected:
  7/11/16 2:51:05:817 CDT] 00000e5c WC_BUSINESSCO <
  -43cd8983:155cbd441d9:-7e87
  com.ibm.commerce.component.contextserviceimpl.BusinessContextSer
  viceImpl.persistContextData(ActivityToken, ContextSPI) Exit
  [7/11/16 2:51:05:817 CDT] 00000e5c BusinessObjec E   The
  following create operation exception has occurred during
  processing: "javax.ejb.DuplicateKeyException
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce Version 7.
  
  PROBLEM ABSTRACT:
  DuplicateKeyException occurs when a CSR attempts to access a
  locked order
  
  BUSINESS IMPACT:
  There is unexpected exception in the trace.
  
  RECOMMENDATION:
  

Problem conclusion

• To avoid the DuplicateKeyException, when the same token is
  copied twice, the activity data is not persisted for the second
  copy.
  

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