JR47496: MY PERFORMANCE DASHBOARD LOADS SLOWLY WITH LARGE NUMBER OF TASKS ASSOCIATED WITH USER'S TEAMS

Download Version 8.0.1 Fix Pack 2 for the IBM Business Process Manager products
Version 8.5.0 Fix Pack 1 for the IBM Business Process Manager products
Version 7.5.1 Fix Pack 2 for the IBM Business Process Manager products
Version 8.5 Refresh Pack 5 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• In Process Portal, if the set of tasks assigned to all of the
  teams to which the user belongs is large, the My Performance
  dashboard may load slowly.
  .
     One scenario in which this may be seen is
  My Performance Dashboard hang after retreiving results for Task
  Status pie chart.
     In one case, the number of task records returned from the
  Query were 131,768 while the Total number of tasks to be
  displayed in the next Tasks table is set to 1000.
  .
     There may be hung thread messages logged
  .
  [6/3/14 1:39:23:427 EST] 00000024 ThreadMonitor W   WSVR0605W:
  Thread "WebContainer : 6" (00000331) has been active for 693340
  milliseconds and may be hung.  There is/are 5 thread(s) in
  total in the server that may be hung.
          at
  org.jdom.ContentList$FilterList.getAdjustedIndex(ContentList.jav
  a:689)
          at
  org.jdom.ContentList$FilterList.get(ContentList.java:581)
          at
  teamworks.PortalIntegrations.modifyElement(PortalIntegrations.ja
  va:1299)
          at
  teamworks.PortalIntegrations.replaceAllKeys(PortalIntegrations.j
  ava:1292)
          at
  teamworks.PortalIntegrations.taskSummaryForUser(PortalIntegratio
  ns.java:935)
  
     The queries that are being run
  SELECT t3.task_id, 'chart.DBKeys.onTrack'
  UNION ALL
  
  SELECT t3.task_id, 'chart.DBKeys.atRisk'
  UNION ALL
  
  SELECT t3.task_id, 'chart.DBKeys.overdue'
  
     For example,
  SELECT t3.task_id, 'chart.DBKeys.onTrack' FROM lsw_task t3 left
  outer join
  lsw_bpd_instance bpdi on bpdi.bpd_instance_id =
  t3.bpd_instance_id
                     left outer join lsw_bpd bpd on
  bpdi.cached_bpd_version_id = bpd.version_id
     WHERE t3.status in ('11','12','13','14')
              AND   bpd.bpd_id in (bpd.id1, bpd.id2...)
     AND (t3.user_id in (2802) or abs(t3.group_id) in (select
  group_id from lsw_usr_grp_xref where group_id in (select
  group_id from lsw_usr_grp_mem_xref where user_id in (2802))
              or group_id in (select container_group_id from
  lsw_usr_grp_mem_xref inner join lsw_grp_grp_mem_exploded_xref on
  lsw_usr_grp_mem_xref.group_id=lsw_grp_g
  rp_mem_exploded_xref.group_id where user_id in (2802))
              )
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  Users of BPM Advanced, BPM Standard, and    *
  *                  BPM Advanced.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: In Process Portal, if the set of        *
  *                      tasks assigned to all of the teams to   *
  *                      which the user belongs is large, the    *
  *                      My Performance dashboard may load       *
  *                      slowly.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  By default, the Team Filter selected for My Performance is
  "All the Teams I belong to".  This causes tasks for all of the
  teams to which the user belongs to be loaded.
  

Problem conclusion

• Changing the default Team Filter to "Me Only" limits the set
  of tasks retrieved in loading the dashboard to those assigned
  to the user, improving the performance.  (The "All the Teams I
  belong to" option can still be selected, if needed.)
  
  An interim fix for Business Process Manager Version 8.0.1.1 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 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

• R800 PSY

     UP