Fixes are available
APAR status
Closed as program error.
Error description
When a business process instance is deleted, the associated service tasks are also deleted including dynamic ad hoc groups. The deletion of these ad hoc groups is a database intensive task. The deletion procedure can be performance optimized by avoiding repeated deletion of ad hoc groups. This can improve the performance of the LSW_BPD_INSTANCE_DELETE stored procedure which is used to remove BPD instances. . There may be hung threads with this java stack [1/27/15 13:47:52:752 CST] 0000001d ThreadMonitor W WSVR0605W: Thread "server.startup : 0" (00000011) has been active for 702995 milliseconds and may be hung. There is/are 1 thread(s) in total in the server that may be hung. at java.util.LinkedList.contains(LinkedList.java:485) at java.util.AbstractSet.removeAll(AbstractSet.java:106) at com.lombardisoftware.server.core.GroupCore.processDeletedUserGro ups(GroupCore.java:631) at com.lombardisoftware.server.core.GroupCore.getAllGroupsInternal( GroupCore.java:593) at com.lombardisoftware.server.core.GroupCore.getAllGroups(GroupCor e.java:572) at com.lombardisoftware.server.ejb.security.SecurityCore.listAllGro ups(SecurityCore.java:722) .-------------------------------------------- Or from the javacore, you may see a thread in this stack 4XESTACKTRACE at com/lombardisoftware/server/core/GroupCore.processDeletedUserGro ups(GroupCore.java:591(Compiled Code)) 4XESTACKTRACE at com/lombardisoftware/server/core/GroupCore.getAllGroupsInternal( GroupCore.java:553) 4XESTACKTRACE at com/lombardisoftware/server/core/GroupCore.getAllGroups(GroupCor e.java:532(Compiled Code))
Local fix
Problem summary
A performance issue exists when deleting BPD process instances. PROBLEM DETAILED DESCRIPTION: The performance issue is caused by the stored procedures in the database that are used to delete BPD process instances. When a BPD process instance is deleted, all task instances that belong to this process have to be deleted as well. In order to do so, it is first necessary to delete all dynamic ad-hoc groups that are associated with these task instances. Determining the groups and group memberships that have to be deleted is an expensive database query, and this query should therefore only be executed once. However, the query is repeated several times in the course of deleting all tasks and the process instance itself. This causes a severe performance impact on environments where many groups exist. VERIFY FIX IS INSTALLED The following SQL block will not be in the LSW_ERASE_TASK stored procedure. This is moved to a differt part of the deletion process. DELETE FROM LSW_USR_GRP_MEM_XREF WHERE GROUP_ID IN ( SELECT g.GROUP_ID FROM LSW_USR_GRP_XREF g WHERE NOT EXISTS (SELECT 1 FROM LSW_TASK t WHERE g.GROUP_ID = ABS(t.GROUP_ID)) AND g.GROUP_TYPE = 2); DELETE FROM LSW_USR_GRP_XREF WHERE GROUP_ID IN ( SELECT g.GROUP_ID FROM LSW_USR_GRP_XREF g WHERE NOT EXISTS (SELECT 1 FROM LSW_TASK t WHERE g.GROUP_ID = ABS(t.GROUP_ID)) AND g.GROUP_TYPE = 2);
Problem conclusion
The issue is resolved by replacing the relevant stored procedures with a new version. These new stored procedures do not repeatedly query the groups and group memberships to delete, but instead only query them once for the overall delete process. FIX AVAILABILITY: iFix for 7.5.1.0 is available on Fix Central, search for APAR JR46453 at http://www.ibm.com/support/fixcentral/ iFix for 7.5.1.1 is available on Fix Central, search for APAR JR46453 at http://www.ibm.com/support/fixcentral/ iFix for 8.0.0.0 is available on Fix Central, search for APAR JR46453 at http://www.ibm.com/support/fixcentral/ iFix for 8.0.1.0 is available on Fix Central, search for APAR JR46453 at http://www.ibm.com/support/fixcentral/ iFix for 8.0.1.1 is available on Fix Central, search for APAR JR46453 at http://www.ibm.com/support/fixcentral/ Fix is also targetted for inclusion in next fixpack for BPM V7.5.1, BPM 8.0.1
Temporary fix
Comments
APAR Information
APAR number
JR46453
Reported component name
BPM STANDARD
Reported component ID
5725C9500
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-04-24
Closed date
2013-12-20
Last modified date
2015-03-07
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
R751 PSY
UP
R800 PSY
UP
R801 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":"7.5.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
07 January 2022