IBM Support

PM88331: CONCURRENT UPDATE/CREATE FAILING ON SHARED LA/DB IN VMM

Fixes are available

8.5.5.1: WebSphere Application Server V8.5.5 Fix Pack 1
8.0.0.8: WebSphere Application Server V8.0 Fix Pack 8
7.0.0.31: WebSphere Application Server V7.0 Fix Pack 31
8.5.5.2: WebSphere Application Server V8.5.5 Fix Pack 2
7.0.0.33: WebSphere Application Server V7.0 Fix Pack 33
8.0.0.9: WebSphere Application Server V8.0 Fix Pack 9
8.5.5.3: WebSphere Application Server V8.5.5 Fix Pack 3
7.0.0.35: WebSphere Application Server V7.0 Fix Pack 35
8.5.5.4: WebSphere Application Server V8.5.5 Fix Pack 4
8.0.0.10: WebSphere Application Server V8.0 Fix Pack 10
7.0.0.37: WebSphere Application Server V7.0 Fix Pack 37
8.5.5.5: WebSphere Application Server V8.5.5 Fix Pack 5
8.5.5.6: WebSphere Application Server V8.5.5 Fix Pack 6
8.0.0.11: WebSphere Application Server V8.0 Fix Pack 11
8.5.5.7: WebSphere Application Server V8.5.5 Fix Pack 7
7.0.0.39: WebSphere Application Server V7.0 Fix Pack 39
8.5.5.8: WebSphere Application Server V8.5.5 Fix Pack 8
8.0.0.12: WebSphere Application Server V8.0 Fix Pack 12
8.5.5.9: WebSphere Application Server V8.5.5 Fix Pack 9
7.0.0.41: WebSphere Application Server V7.0 Fix Pack 41
8.5.5.10: WebSphere Application Server V8.5.5 Fix Pack 10
8.5.5.11: WebSphere Application Server V8.5.5 Fix Pack 11
8.0.0.13: WebSphere Application Server V8.0 Fix Pack 13
7.0.0.43: WebSphere Application Server V7.0 Fix Pack 43
8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
8.0.0.14: WebSphere Application Server V8.0 Fix Pack 14
8.5.5.13: WebSphere Application Server V8.5.5 Fix Pack 13
7.0.0.45: WebSphere Application Server V7.0 Fix Pack 45
8.0.0.15: WebSphere Application Server V8.0 Fix Pack 15
7.0.0.45: Java SDK 1.6 SR16 FP60 Cumulative Fix for WebSphere Application Server
7.0.0.31: Java SDK 1.6 SR15 Cumulative Fix for WebSphere Application Server
7.0.0.35: Java SDK 1.6 SR16 FP1 Cumulative Fix for WebSphere Application Server
7.0.0.37: Java SDK 1.6 SR16 FP3 Cumulative Fix for WebSphere Application Server
7.0.0.39: Java SDK 1.6 SR16 FP7 Cumulative Fix for WebSphere Application Server
7.0.0.41: Java SDK 1.6 SR16 FP20 Cumulative Fix for WebSphere Application Server
7.0.0.43: Java SDK 1.6 SR16 FP41 Cumulative Fix for WebSphere Application Server
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Virtual member manager (VMM) allows the same repository to be
    shared across different WebSphere Application Server instances.
    So VMM allows to share DB and LookSide/propertyExtension
    repository.
    
    When parallel create/update are being made from different server
    instances, VMM intermittently throws
    
    [timestamp] 00000098 exception     1
    com.ibm.ws.wim.dao.AbstractDAO createLAEntity(LAEntity newEnt)
    
    com.ibm.websphere.wim.exception.WIMSystemException: CWWIM4521E
    The
    'ORA-00001: unique constraint ([...]) violated
    ' SQL Exception occurred during processing.
    
    Caused by: com.ibm.websphere.ce.cm.DuplicateKeyException:
    ORA-00001:
    unique constraint ([...]) violated
    
    
    
    
    This APAR further enchances the functionality of existing APAR
    PM60212 by adding additional logic to retry the failed database
    transaction.  If the initial attempt to commit the changes to
    the database fails, rather than throwing a
    duplicatekeyexception the database transaction will be
    attempted a number of times until the commit is successful.
    If the changes cannot commited after multiple retry attempts, a
    duplicateKeyException will be thrown and the changes not
    committed.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: Creation of DB entity and LA entity     *
    *                      operation was failing and was not       *
    *                      retrying any attempts.                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    As part of APAR PM60212, concurrent updates on DB and LA was
    resolved.
    But creation of DB entity and LA entity operation was still
    failing and was not retrying any attempts.
    It tries one attempt and if that fails, it was getting a
    failure message and the operation was failing. This was mainly
    happening in performance testing.
    

Problem conclusion

  • To solve this issue we added 25 attempts for creation of DB
    and LA entity.
    
    The fix for this APAR is currently targeted for inclusion in
    fix pacsk 7.0.0.31, 8.0.0.8 and 8.5.5.1.  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

    PM88331

  • Reported component name

    WEBSPHERE APP S

  • Reported component ID

    5724J0800

  • Reported release

    610

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-05-02

  • Closed date

    2013-07-23

  • Last modified date

    2013-07-23

  • 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

    WEBSPHERE APP S

  • Fixed component ID

    5724J0800

Applicable component levels

  • R700 PSY

       UP

  • R800 PSY

       UP

  • R850 PSY

       UP



Document information

More support for: WebSphere Application Server
General

Software version: 610

Reference #: PM88331

Modified date: 23 July 2013