APAR status
Closed as program error.
Error description
When using the account activation feature in the MayUJoy sample store, guest shoppers to the store see the following exception when clicking on the activation link: com.ibm.commerce.webcontroller.WebControllerHelper commitRequestProcess(RequestHandle,boolean,boolean,boolean CMN0409E: The following error occurred during processing: "com.ibm.commerce.context.exception.BusinessContextServiceExcept ion: The following create operation exception has occurred during processing: "javax.ejb.DuplicateKeyException: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;DB2ADMIN.CTXMGMT, DRIVER=4.11.77DSRA0010E: SQL State = 23505, Error Code = -803".". com.ibm.commerce.context.exception.BusinessContextServiceExcepti on at com.ibm.commerce.component.contextserviceimpl.ActivityTokenProce ssor.per sistActivityToken(ActivityTokenProcessor.java:164) at com.ibm.commerce.component.contextserviceimpl.BusinessContextSer viceImpl .persistActivityToken(BusinessContextServiceImpl.java:1564) at com.ibm.commerce.component.contextserviceimpl.BusinessContextSer viceImpl .endRequest(BusinessContextServiceImpl.java:744)
Local fix
Guest shoppers can close their browser or clear their cookies and then activate the account using the link.
Problem summary
USERS AFFECTED: WebSphere Commerce V7 users that are using the user registration account activation feature introduced in V7 FEP1. PROBLEM ABSTRACT: Under the MayUJoy sample store, there is a new feature called 'account activation' where new registered users must click a link received in an email to confirm registration to the site. When guest shoppers first adds an item to their shopping cart, then registers, and then clicks on the e-mail link to activate their account (all in the same browser session), a 'BusinessContextServiceException'/'DuplicateKeyException' is seen. BUSINESS IMPACT: Guest shoppers with a shopping cart will be unable to complete registration on their first attempt RECOMMENDATION:
Problem conclusion
This APAR changes the registration flow, to prevent the business context exception from occurring. APAR JR41299 and JR41270 both need to be installed for this fix to work. ------------------------------------------------------------- The latest available maintenance information can be obtained from the Recommended Fixes for WebSphere Commerce technote:
Temporary fix
Comments
APAR Information
APAR number
JR41299
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-11-25
Closed date
2011-12-22
Last modified date
2011-12-22
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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
22 December 2011