IBM Support

JR42537: CMVC 221117 - CORRECT EVENTPROCESSOR TO ALLOW PROCESSING OF MORE THAN 5,000 ROWS AT THE TIME

Subscribe

You can track all active APARs for this component.

 

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