IBM Support

JR49359: DUPLICATE EXECUTION OF EVENT MANAGER TASKS WITH ORACLE UNDER HIGH LOAD.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Duplicate Execution of Event Manager Tasks with Oracle under
    high load.
    .
    Beginning with BPM Version 8.0.1.1, Event Manaager queries were
    restructured. The new Oracle version of <loader-find-task-query>
    can under high load in a cluster topology lead to a situation
    where multiple Event Manager Instances load and executy the same
    Event Manager task.
    

Local fix

Problem summary

  • Beginning with BPM Version 8.0.1.1, Event Manager queries were
    restructured. The new Oracle version of
    <loader-find-tasks-query> under high load in a cluster topology
    can lead to a situation where multiple Event Manager Instances
    load and execute the same Event Manager task.
    
    PROBLEM DETAILED DESCRIPTION:
    The problem is caused by subtle details of Oracle's processing
    of the <loader-find-tasks-query>.
    If the LSW_EM_TASK table contains thousands of records, the load
    on the system is high, and multiple Event Manager instances
    are running concurrently, it can happen that the same
    LSW_EM_TASK record is returned to more than one Event Manager
    instance.
    

Problem conclusion

  • Modify the query so that Oracle returns only unique LSW_EM_TASK
    records to each Event Manager instance.
    
    FIX AVAILABILITY:
    iFix for 8.0.1.1 is/will be available on Fix Central; search for
    APAR JR49359 at http://www.ibm.com/support/fixcentral/
    iFix for 8.0.1.2 is/will be available on Fix Central; search for
    APAR JR49359 at http://www.ibm.com/support/fixcentral/
    iFix for 8.5.0.1 is/will be available on Fix Central; search for
    APAR JR49359 at http://www.ibm.com/support/fixcentral/
    Fix is also targetted for inclusion in next fixpack for
    BPM 8.0.1
    
    When obtaining any of the above fixes, be sure to download the
    accompanying readme, for itself, and any prerequisite fixes, and
    review them thoroughly.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR49359

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-02-13

  • Closed date

    2014-03-04

  • Last modified date

    2014-03-04

  • 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

    BPM STANDARD

  • Fixed component ID

    5725C9500

Applicable component levels

  • R801 PSY

       UP

  • R850 PSY

       UP



Document information

More support for: IBM Business Process Manager Standard

Software version: 8.0.1

Reference #: JR49359

Modified date: 04 March 2014


Translate this page: