Fixes are available
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
12 October 2021