IBM Support

JR44456: PERFORMANCE DEGRADATION IN PROCESS PORTAL RESULTING FROM MULTIPLE EXECUTIONS OF SAME SQL STATEMENT

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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