Fixes are available
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
07 January 2022