Fixes are available
APAR status
Closed as program error.
Error description
Template cache issue with people substitution. . With people substitution enabled, information in the template cache can grow over time and lead to redundant data in staff resolution SQL querys The following message may be logged as a result [3/10/17 1:26:59:384 EST] 0000006b TraceHTM 3 com.ibm.bpe.staff.VMMAccessControl.getResultAttributeValues(VMMA ccessControl.java:1479) HTM_PA_VMM Reached staff query threshold, stopping retrieval of further results [3/10/17 1:26:59:384 EST] 0000006b StaffPluginUt W CWWBS0469W: The specified threshold for the people (staff) query has been reached, no further results will be included. And a trace of the issue would show duplicate entries in the data returned on the query. Those systems using Oracle for the DB server may also see CWWIM4521E The 'ORA-01795 maximum number of expressions in a list is 1000' SQL Exception occurred during processing. at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManager Impl.jav:4656) at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextM anagerImpl.java:4698) at com.ibm.bpe.staff.VMMAccessControl.doVMMGet(VMMAccessControl.jav a:547) at com.ibm.bpe.staff.VMMAccessControl.doPluginGetGroupMembers(VMMAc cessControl.java:740) at com.ibm.bpe.staff.VMMStaffResolutionPlugin.resolveStaff1(VMMStaf fResolutionPlugin.java:1473)
Local fix
Problem summary
Problem fixed
Problem conclusion
Fix will be included in V7511
Temporary fix
Comments
APAR Information
APAR number
JR41687
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-01-16
Closed date
2012-03-12
Last modified date
2017-03-10
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
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1"}]
Document Information
Modified date:
06 October 2021