Direct links to fixes
APAR status
Closed as program error.
Error description
One of these errors shows up in the IBM WebSphere Commerce logs when publishing a workspace task when using the Workspace Administration Console: CommerceSrvr E com.ibm.commerce.context.content.resources.ResourceContentEventL istener processActivityEvent(WCSEvent ae) CMN0409E: The following error occurred during processing: "{0}".com.ibm.commerce.context.content.resources.exception.Resou rceException: com.ibm.websphere.ce.cm.DuplicateKeyException: DB2 SQL Error:SQLCODE=-803, SQLSTATE=23505, SQLCODE=-803, SQLSTATE=23505, SQLERRMC=2;DB2INST1.PX_PROMOCD,DRIVER=4.3.111 at com.ibm.commerce.context.content.resources.AbstractResourceManag erImpl.commit(AbstractResourceManagerImpl.java:1173) at com.ibm.commerce.context.content.resources.AbstractResourceConta inerImpl.commit(AbstractResourceContainerImpl.java:164) at com.ibm.commerce.context.content.resources.ResourceContainerMana ger.commit(ResourceContainerManager.java:531) at com.ibm.commerce.context.content.resources.ResourceContentEventL istener.processActivityEvent(ResourceContentEventListener.java:9 3) or CommerceSrvr E com.ibm.commerce.context.content.resources.ResourceContentEventL istener processActivityEvent(WCSEvent ae) CMN0409E: The following error occurred during processing: "{0}".com.ibm.commerce.context.content.resources.exception.Resou rceException: com.ibm.websphere.ce.cm.DuplicateKeyException: DB2 SQL Error:SQLCODE=-803, SQLSTATE=23505, SQLCODE=-803, SQLSTATE=23505, SQLERRMC=2;DB2INST1.PX_CDPROMO,DRIVER=4.3.111 at com.ibm.commerce.context.content.resources.AbstractResourceManag erImpl.commit(AbstractResourceManagerImpl.java:1173) at com.ibm.commerce.context.content.resources.AbstractResourceConta inerImpl.commit(AbstractResourceContainerImpl.java:164) at com.ibm.commerce.context.content.resources.ResourceContainerMana ger.commit(ResourceContainerManager.java:531) at com.ibm.commerce.context.content.resources.ResourceContentEventL istener.processActivityEvent(ResourceContentEventListener.java:9 3) The error occurs because there already is an existing entry in the tables PX_PROMOCD or PX_CDPROMO in the staging database base schema with same values, causing the DuplicateKeyException.
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce users on v7.0 who use the Workspace Administration Console PROBLEM ABSTRACT: DuplicateKeyException is encountered when publishing a WebSphere Commerce workspace task for the table PX_PROMOCD or PX_CDPROMO. BUSINESS IMPACT: Unable to publish workspace task to the staging database. RECOMMENDATION:
Problem conclusion
Installing APAR JR39732 can resolve the DuplicateKeyException issue by replacing the duplicated entry in the staging base schema so that the new entry published will be committed. ------------------------------------------------------------- The latest available maintenance information can be obtained from the Recommended Fixes for WebSphere Commerce technote: http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
Temporary fix
Comments
APAR Information
APAR number
JR39732
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / Installability
Submitted date
2011-06-01
Closed date
2011-08-31
Last modified date
2011-08-31
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:
31 August 2011