IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR47496

  • Reported component name

    BPM ADV PAT AIX

  • Reported component ID

    5725I1300

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-13

  • Closed date

    2013-10-31

  • Last modified date

    2015-07-21

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
21 July 2015