Fixes are available
APAR status
Closed as program error.
Error description
When fetching members of a group from a DB, virtual member manager (VMM) fails with: 10/19/12 19:41:55:502 EDT] 00000073 exception 1 com.ibm.ws.wim.dao.AbstractDAO getDBEntityInformation(String query, DataObject entity, String DOPropName, String reposId) com.ibm.websphere.wim.exception.WIMSystemException: CWWIM4521E The 'ORA-01795: maximum number of expressions in a list is 1000 ' SQL Exception occurred during processing. at com.ibm.ws.wim.dao.AbstractDAO.getDBEntityInformation(AbstractDA O.java:2 537) at com.ibm.ws.wim.adapter.db.DBAdapter.getEntityInformationByEntity Ids(DBAd apter.java:1110) at com.ibm.ws.wim.adapter.db.DBAdapter.get(DBAdapter.java:713) at com.ibm.ws.wim.ProfileManager.getImpl(ProfileManager.java:1744) at com.ibm.ws.wim.ProfileManager.genericProfileManagerMethod(Profil eManager .java:362) at com.ibm.ws.wim.ProfileManager.get(ProfileManager.java:415)
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM WebSphere Application * * Server * **************************************************************** * PROBLEM DESCRIPTION: VMM throws an exception while * * retrieving Group members, if a group * * contains more than 1000 members in a * * DB repository. * **************************************************************** * RECOMMENDATION: * **************************************************************** While retrieving members of a Group present in a DB, if it contains more than 1000 members then VMM throws the following exception. com.ibm.websphere.wim.exception.WIMSystemException: CWWIM4521E The 'ORA-01795: maximum number of expressions in a list is 1000 ' SQL Exception occurred during processing.
Problem conclusion
To resolve this issue we corrected code to handle more than 1000 members present in a group in a DB repository. The fix for this APAR is currently targeted for inclusion in fix pack 8.0.0.7 and the fix pack following 8.5.0.2. Please refer to the Recommended Updates page for delivery information: http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
Temporary fix
Comments
APAR Information
APAR number
PM75956
Reported component name
WEBS APP SERV N
Reported component ID
5724H8800
Reported release
800
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-10-26
Closed date
2013-02-12
Last modified date
2016-10-31
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
WEBS APP SERV N
Fixed component ID
5724H8800
Applicable component levels
R800 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
29 October 2021