IBM Support

PM75956: VMM FAILS TO RETRIEVE MEMBERS OF A GROUP WHEN THE GROUP CONTAINS THOUSANDS OF MEMBERS

Subscribe

You can track all active APARs for this component.

 

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