APAR status
Closed as program error.
Error description
In the Process Portal, when working with a process or task, retrieval of actions which the user can perform for a process or task can trigger multiple executions of an SQL statement used to determine the groups to which the user belongs, for action authorization purposes. This can result in unnecessary performance degradation in the Process Portal.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of BPM Express, BPM Standard and BPM * * Advanced. * **************************************************************** * PROBLEM DESCRIPTION: In the Process Portal, when working * * with a process or task, retrieval of * * actions which the user can perform * * for a process instance or task can * * trigger multiple executions of an SQL * * statement used to determine the groups * * to which the user belongs, for action * * authorization purposes. This can * * result in unnecessary performance * * degradation in the Process Portal. * **************************************************************** * RECOMMENDATION: * **************************************************************** Every call of a function that checks the groups or users to which the user belongs retrieves the same result set (executes same SQL statement), until either a new snapshot is created or the user's membership changes. This function gets called for every possible action for a task or process instance, in a loop.
Problem conclusion
The redundant function calls are eliminated by calling the function only once, before the loop begins. An interim fix for Business Process Manager Version 8.0.0.0 has been published to Fix Central. Please refer to the separate file that is automatically downloaded with the interim fix for prerequisite information and installation/uninstallation instructions.
Temporary fix
Comments
APAR Information
APAR number
JR44456
Reported component name
BPM STANDARD
Reported component ID
5725C9500
Reported release
800
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-10-19
Closed date
2013-02-15
Last modified date
2013-02-15
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
R800 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
15 February 2013