JR53646: LOGGING IN TO PROCESS CENTER IS VERY SLOW IF YOU BELONG TO MULTIPLE GROUPS

8.5.5.0-WS-BPM-IFJR53646
8.5.6.0-WS-BPM-IFJR53646
bpm.8560.cf1.delta.repository.1
bpm.8560.cf1.delta.repository.2
Version 8.5 Refresh Pack 7 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• It takes long time for the Process Center Console to open after
  you log in if you  belong to many groups.
  .
  - upon log-in for the user the groups are established the user
  is member of
  
  - for each of these groups the above check is performaed on the
  repository possibly with repsect to every project in the
  repository
  
  For large num numbers of groups for a user and/projects this
  results in a long series of DB calls of
  select t0.ACL_ENTRY_ID,t0.PO_TYPE,t0.PO_ID,t0.MASK,cast(null as
  DECIMAL(12,0)) as USER_ID,t0.GROUP_ID
                  from LSW_ACL_ENTRY t0
                  where GROUP_ID = ? and PO_ID = ? and PO_TYPE = ?
  
  PRODUCTS AFFECTED
  IBM Business Process Manager (BPM) Advanced
  IBM BPM Standard
  IBM BPM Express
  

Local fix

Problem summary

• For each process application, IBM Process Center queries the
  database for each group to verify that the user is permitted
  access. As a result, when you belong to multiple groups, it
  takes longer to log in to the Process Center Console.
  

Problem conclusion

• A fix is available that reduces the number of database queries
  when verifying access permission, thereby improving performance
  and making logging in faster.
  
  On Fix Central (http://www.ibm.com/support/fixcentral), search
  for JR53646:
  
  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 JR53646, and click Continue.
  
  When you download fix packages, ensure that you also download
  the readme file for each fix. Review each readme file for
  additional installation instructions and information about the
  fix.
  

Temporary fix

Comments

APAR Information

• 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 ADVANCED

• Fixed component ID

  5725C9400

Applicable component levels