Direct links to fixes
APAR status
Closed as program error.
Error description
When there are a large number of records in the MEMBER database table, the SQL query used by the ListUsersInMemberGroupCmd command may have poor performance. The ListUsersInMemberGroupCmd is used in several scenarios including: - setting up order approval when an order is submitted - retrieving the list of users for an e-mail activity - retrieving the list of users for an dialog activity using the Customer is in Segment trigger
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce users on V7 PROBLEM ABSTRACT: The ListUsersInMemberGroupCmd command exhibits slow performance when there are a large number of records in the MEMBER database table. BUSINESS IMPACT: Slow site performance RECOMMENDATION:
Problem conclusion
The SQL query used by the ListUsersInMemberGroupCmd command has been rewritten to provide better performance. ------------------------------------------------------------- The latest available maintenance information can be obtained from the Recommended Fixes for WebSphere Commerce technote: http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
Temporary fix
Comments
APAR Information
APAR number
JR42281
Reported component name
WC BUS DEV ED W
Reported component ID
5724I3900
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-03-19
Closed date
2012-07-19
Last modified date
2012-07-19
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
WC BUS DEV ED W
Fixed component ID
5724I3900
Applicable component levels
R700 PSY
UP
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSYT2H","label":"WebSphere Commerce Developer Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
07 December 2021