IBM Support

JR54462: PERFORMANCE REGRESSED IN IBM PROCESS DESIGNER WITH LARGE NUMBER OF FAVORITES IN LSW_FAVORITES TABLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In IBM Process Designer, it takes between 15 and 30 seconds to
    load the page when you try to debug a process or project or run
    a graphic user interface (coach view or human task) because IBM
    Business Process Manager (BPM) is retrieving all the favorites
    in the lsw_favorite table. IBM BPM searches all favorites that
    this user is eligible for.  For each favorite, IBM BPM must
    expand the objects stored in the favorite table.
    
    
    The Java stack of this processing is
       The java stack of this processing is this.
    
    4XESTACKTRACE
     at com/lombardisoftware/server/ejb/persistence/dao/
      FavoriteDAO.findFavoritesExposedToUser(FavoriteDAO.
      java:201)
    4XESTACKTRACE
     at com/lombardisoftware/server/ejb/runtime/
      RuntimeServicesCore.getActiveFavoritesWithFilter
      (RuntimeServicesCore.java:355)
    4XESTACKTRACE
     at com/lombardisoftware/server/ejb/runtime/
      RuntimeServicesCore.getActiveFavoritesWithFilter
      (RuntimeServicesCore.java:349)
    
    The following parameter introduced in interim fix JR52126
    triggers the processing that causes the slow performance. The
    setting is "true" for this configuration parameter:
    
    <enforce-correct-service-type-for-execute-service-by-name>
    

Local fix

Problem summary

  • Interim fix JR52126 uses a database query that is functionally
    correct but rather inefficient and, so, causes the performance
    issue.
    

Problem conclusion

  • A fix will be included in IBM BPM V8.5.5 and in a IBM BPM V8.5.6
    cumulative fix.
    
    For V8.5.5, go to Fix Central
    (http://www.ibm.com/support/fixcentral) and search for JR54462:
    
    1. Select IBM Business Process Manager with your edition from
      the product selector, the installed version to the fix pack
      level, and your platform, and then click Continue.
    
    2. Select APAR or SPR, enter JR54462, and click Continue.
    
    For V8.5.6, determine whether the cumulative fix is available
    and download it if it is by completing the following steps on
    Fix Central:
    
    1. Select IBM Business Process Manager with your edition
      from the product selector, the installed version to the fix
      pack level, and your platform, and then click Continue.
    
    2. Select Text, enter ?cumulative fix?, and click Continue.
    

Temporary fix

  • Not applicable
    

Comments

APAR Information

  • APAR number

    JR54462

  • Reported component name

    BPM EXPRESS

  • Reported component ID

    5725C9600

  • Reported release

    855

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-10-09

  • Closed date

    2015-12-09

  • Last modified date

    2015-12-09

  • 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

  • R855 PSY

       UP

  • R856 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":"855","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
09 December 2015