IBM Support

PK86552: GETTING java.lang.NullPointerException followed by DSRA9110E: Connection is closed exception

Fixes are available

Java SDK 1.5 SR10 Cumulative Fix for WebSphere Application Server
7.0.0.7: WebSphere Application Server V7.0 Fix Pack 7 for IBM i
7.0.0.7: WebSphere Application Server V7.0 Fix Pack 7 for AIX
7.0.0.7: WebSphere Application Server V7.0 Fix Pack 7 for Windows
7.0.0.7: WebSphere Application Server V7.0 Fix Pack 7 for HP-UX
7.0.0.7: Java SDK 1.6 SR6 Cumulative Fix for WebSphere Application Server
7.0.0.7: WebSphere Application Server V7.0 Fix Pack 7 for Solaris
7.0.0.7: WebSphere Application Server V7.0 Fix Pack 7 for Linux
7.0.0.9: WebSphere Application Server V7.0 Fix Pack 9 for IBM i
7.0.0.9: WebSphere Application Server V7.0 Fix Pack 9 for Windows
7.0.0.9: WebSphere Application Server V7.0 Fix Pack 9 for AIX
7.0.0.9: WebSphere Application Server V7.0 Fix Pack 9 for HP-UX
7.0.0.9: Java SDK 1.6 SR7 Cumulative Fix for WebSphere Application Server
7.0.0.9: WebSphere Application Server V7.0 Fix Pack 9 for Solaris
7.0.0.9: WebSphere Application Server V7.0 Fix Pack 9 for Linux
7.0.0.11: WebSphere Application Server V7.0 Fix Pack 11 for IBM i
7.0.0.11: WebSphere Application Server V7.0 Fix Pack 11 for Windows
7.0.0.11: WebSphere Application Server V7.0 Fix Pack 11 for HP-UX
7.0.0.11: WebSphere Application Server V7.0 Fix Pack 11 for AIX
7.0.0.11: Java SDK 1.6 SR7 Cumulative Fix for WebSphere Application Server
7.0.0.11: WebSphere Application Server V7.0 Fix Pack 11 for Solaris
7.0.0.11: WebSphere Application Server V7.0 Fix Pack 11 for Linux
6.1.0.29: Java SDK 1.5 SR11 Cumulative Fix for WebSphere Application Server
6.1.0.31: Java SDK 1.5 SR11 FP1 Cumulative Fix for WebSphere Application Server
6.1.0.33: Java SDK 1.5 SR12 FP1 Cumulative Fix for WebSphere
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for AIX
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for HP-UX
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for IBM i
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for Linux
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for Solaris
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for Windows
7.0.0.13: Java SDK 1.6 SR8FP1 Cumulative Fix for WebSphere Application Server
6.1.0.35: Java SDK 1.5 SR12 FP2 Cumulative Fix for WebSphere
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for AIX
7.0.0.15: Java SDK 1.6 SR9 Cumulative Fix for WebSphere Application Server
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for HP-UX
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for IBM i
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for Linux
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for Solaris
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for Windows
6.1.0.37: Java SDK 1.5 SR12 FP3 Cumulative Fix for WebSphere
7.0.0.17: WebSphere Application Server V7.0 Fix Pack 17
7.0.0.17: Java SDK 1.6 SR9 FP1 Cumulative Fix for WebSphere Application Server
7.0.0.19: WebSphere Application Server V7.0 Fix Pack 19
7.0.0.21: WebSphere Application Server V7.0 Fix Pack 21
7.0.0.23: WebSphere Application Server V7.0 Fix Pack 23
7.0.0.25: WebSphere Application Server V7.0 Fix Pack 25
7.0.0.27: WebSphere Application Server V7.0 Fix Pack 27
7.0.0.29: WebSphere Application Server V7.0 Fix Pack 29
6.1.0.47: WebSphere Application Server V6.1 Fix Pack 47
7.0.0.31: WebSphere Application Server V7.0 Fix Pack 31
7.0.0.27: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.33: WebSphere Application Server V7.0 Fix Pack 33
7.0.0.35: WebSphere Application Server V7.0 Fix Pack 35
6.1.0.39: Java SDK 1.5 SR12 FP4 Cumulative Fix for WebSphere Application Server
6.1.0.41: Java SDK 1.5 SR12 FP5 Cumulative Fix for WebSphere Application Server
6.1.0.43: Java SDK 1.5 SR13 Cumulative Fix for WebSphere Application Server
6.1.0.45: Java SDK 1.5 SR14 Cumulative Fix for WebSphere Application Server
6.1.0.47: Java SDK 1.5 SR16 Cumulative Fix for WebSphere Application Server
7.0.0.19: Java SDK 1.6 SR9 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.21: Java SDK 1.6 SR9 FP2 Cumulative Fix for WebSphere
7.0.0.23: Java SDK 1.6 SR10 FP1 Cumulative Fix for WebSphere
7.0.0.25: Java SDK 1.6 SR11 Cumulative Fix for WebSphere Application Server
7.0.0.27: Java SDK 1.6 SR12 Cumulative Fix for WebSphere Application Server
7.0.0.29: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Problem description:
    
    
    Customer observing the following
    error messages in log files:
    
    java.lang.NullPointerException
    at java.util.Hashtable.getEntry(Hashtable.java:468)
    at java.util.Hashtable.containsKey(Hashtable.java:354)
    at com.ibm.db2.jcc.b.sf.setCursorName(sf.java:763)
    at
    com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper.doStatem
    entClean
    up(DB2UniversalDataStoreHelper.java:225)
    at
    com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.closeWrapper(W
    SJdbcPre
    paredStatement.java:435)
    
    
    followed by the follwing object closed exception
    
    
    
    [4/24/09 10:25:31:197 EST] 00000029 MCWrapper     E   J2CA0081E:
    Method cleanup failed while trying to execute method cleanup on
    ManagedConnection WSRdbManagedConnectionImpl@49a849a8 from
    resource jdbc/SRSSCHDB_SRSDEV1. Caught exception:
    com.ibm.ws.exception.WsException: DSRA9110E: Connection is
    closed.
    at
    com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>
    (DataStoreAdapterException.java:241)
    at
    com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>
    (DataStoreAdapterException.java:190)
    at
    com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException
    (AdapterUtil.java:388)
    at
    com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.dissociate(WSJdbcConn
    ection.java:1383)
    at
    com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.dissociateCo
    nnections(WSRdbManagedConnectionImpl.java:841)
    at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java:1436)
    at com.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:487)
    at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:1780)
    at
    com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:22
    81)
    at
    com.ibm.ejs.j2c.LocalTransactionWrapper.afterCompletion(LocalTra
    nsactionWrapper.java:1228)
    at
    com.ibm.ws.LocalTransaction.LocalTranCoordImpl.driveSy
    
    
    
    This APAR is only for the NullPointerException followed by the
    object closed exception. If the NullPointerException is
    observed with out the object closed exception it is caused by
    a DB2 problem see the following link
    
    
    http://www-01.ibm.com/support/docview.wss?uid=swg1IZ27010
    
    
    This APAR will make sure that this method is not returned to the
    application in the case were the connection is already closed.
    
    
    Note: This APAR is created for DSRA9110E: Connection is closed
    not for NullPointerException.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application Server
    ****************************************************************
    * PROBLEM DESCRIPTION: Customers using DB2 datasource          *
    *                      observe the NullPointerException        *
    *                      error messages in log files.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The problem occurs when a closed connection is being returned
    to freepool, the statement cleanup code throws
    NullPointerException.
    

Problem conclusion

  • The actual problem is with DB2 code and the fix is
    available at
    http://www-01.ibm.com/support/docview.wss?uid=swg1IZ27010.
    As explained in this link, customers are recommended to
    upgrade their DB2 version.
    This IBM WebSphere Application Server APAR, PK86552, handles
    the exception gracefully and provides temporary relief to
    the customers who cannot upgrade the DB2 version immediately.
    
    The fix for this APAR is currently targeted for inclusion in
    fix packs 6.0.2.37, 6.1.0.27 and 7.0.0.7.  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

    PK86552

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    60A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-14

  • Closed date

    2009-06-29

  • Last modified date

    2009-06-29

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    PK89366

Fix information

  • Fixed component name

    WEBS APP SERV N

  • Fixed component ID

    5724H8800

Applicable component levels

  • R60A PSY

       UP

  • R60H PSY

       UP

  • R60I PSY

       UP

  • R60P PSY

       UP

  • R60S PSY

       UP

  • R60W PSY

       UP

  • R60Z PSY

       UP

  • R61A PSY

       UP

  • R61H PSY

       UP

  • R61I PSY

       UP

  • R61P PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP

  • R61Z PSY

       UP

  • R700 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":"6.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
29 December 2021