Direct links to fixes
APAR status
Closed as program error.
Error description
When the EventProcessor scheduler job runs, for those events that do not require processing for analytics, the status (checked column in the BUSEVENT table) is updated from -10 to -20 so the CleanECEvent scheduled job can remove them. The EventProcessor job should update up to 500,000 rows per execution, committing every 5000. Due to an issue in the code, if there are events which use multiple sequences in the table, the EventProcessor will update 5000 rows and then stop. It will not continue until reaching 500,000 The fix associated with this APAR corrects that error. This APAR supersedes JR40515. Refer to the documentation included with JR40515 for details of how the Event Processing framework works JR40515: CMVC 211264 - DELIVER PERFORMANCE IMPROVEMENTS FOR THE ECEVENT PROCESSING FRAMEWORK (BUSEVENT TABLE) http://www-01.ibm.com/support/docview.wss?uid=swg1JR40515
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce 7.0 users PROBLEM ABSTRACT: Correct the EventProcessor command to allow processing of more than 5000 rows at a time BUSINESS IMPACT: BUSEVENT table might grow unbounded affecting the stability of the site RECOMMENDATION:
Problem conclusion
The EventProcessor scheduled job was corrected so that for those events that do not required processing for analytics, up to 500,000 rows from the BUSEVENT table are processed instead of 5,000. The EventProcessor was further optimized to process events as follows: * CleanECEvent deletes up to 500,000 events which have checked value of -20 and are 30 minutes old, in each scheduled job run. Deletes are done in batches of 5000. * When Analytics feature is disabled for the store, EventProcessor deletes up to 500,000 events that have checked value of -10 and are 30 minutes old, in each scheduled job run. Deletes are done in batches of 5000. * When Analytics feature is enabled for the store, EventProcessor will handle up to 200 sales center events to be processed for Coremetrics cross channel analytics in each scheduled job run and mark it to be purged (checked = -20). If it finds any non-Sales Center event data (i.e. coming from web channel), it marks up to 500,000 such events to be purged (checked = -20). ------------------------------------------------------------- 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
JR42537
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / Pervasive
Submitted date
2012-04-13
Closed date
2012-06-29
Last modified date
2012-06-29
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:
29 June 2012