IBM Support

PK52881: J2CA0081E ERROR MAY CAUSE JDBC CONNECTIONS TO LEAK

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Multiple instances of the following error can be seen in the
    application server servant output.  If this error is
    encountered, a physical connection to the database will not be
    closed.
    
    Trace: 2007/05/30 18:07:18.952 01 t=9BB448 c=UNK key=P8
    (13007002)
      ThreadId: 0000003c
      FunctionName: com.ibm.ejs.j2c.MCWrapper
      SourceId: com.ibm.ejs.j2c.MCWrapper
      Category: SEVERE
      ExtendedMessage: BBOO0220E: J2CA0081E: Method cleanup failed
    while trying to execute method cleanup on ManagedConnection
    WSRdbManagedConnectionImpl@3d723d72 from resource
    jdbc/DB2DATASOURCE5.
    Caught exception: com.ibm.ws.exception.WsException: DSRA0080E:
    An exception was received by the Data Store Adapter. See
    original exception message: Cannot call 'cleanup' on a
    ManagedConnection while it is still in a transaction..
    .at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException
    .at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException
    .at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterExcep
      tion
    .at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.
      cleanupTransactions
    .at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup
    .at com.ibm.ejs.j2c.MCWrapper.cleanup
    .at com.ibm.ejs.j2c.FreePool.returnToFreePool
    .at com.ibm.ejs.j2c.PoolManager.release
    .at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager
    .at com.ibm.ejs.j2c.RRSLocalTransactionWrapper.afterCompletion
    .at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.
      informSynchronizations
    .at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.cleanup
    .at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.end
    .at com.ibm.ws.webcontainer.webapp.WebAppTransactionCollaborat
      or.postInvoke
    .at com.ibm.ws.wswebcontainer.webapp.WebApp.transactionPostIn
      voke
    .at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequ
      est
    ...
    .at com.ibm.ws.util.ThreadPool$ZOSWorker.run
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of WebSphere Application Server    *
    *                 V6.1 for z/OS using DB2 Universal Drive      *
    *                 type-2 z/OS connectivity and local           *
    *                 transaction support.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: Multiple instances of J2CA0081E:        *
    *                      Method cleanup failed -- cannot call    *
    *                      'cleanup' on a ManagedConnection        *
    *                      while it is still  in a transaction --  *
    *                      causing connection leaking and          *
    *                      subsequent                              *
    *                      ConnectionWaitTimeoutException.         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Multiple instances of the following error can be seen in the
    application server servant output.  If this error is
    encountered, a physical connection to the database will not be
    closed.
    
    Trace: 2007/05/30 18:07:18.952 01 t=9BB448 c=UNK key=P8
    (13007002)
    ThreadId: 0000003c
    FunctionName: com.ibm.ejs.j2c.MCWrapper
    SourceId: com.ibm.ejs.j2c.MCWrapper
    Category: SEVERE
    ExtendedMessage: BBOO0220E: J2CA0081E: Method cleanup failed
    while trying to execute method cleanup on ManagedConnection
    WSRdbManagedConnectionImpl@3d723d72 from resource
    jdbc/DB2DATASOURCE5.
    Caught exception: com.ibm.ws.exception.WsException: DSRA0080E:
    An exception was received by the Data Store Adapter. See
    original exception message: Cannot call 'cleanup' on a
    ManagedConnection while it is still in a transaction..
    .at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException
    .at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException
    .at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterExcep
    
    tion
    .at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.
    cleanupTransactions
    .at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup
    .at com.ibm.ejs.j2c.MCWrapper.cleanup
    .at com.ibm.ejs.j2c.FreePool.returnToFreePool
    .at com.ibm.ejs.j2c.PoolManager.release
    .at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager
    .at com.ibm.ejs.j2c.RRSLocalTransactionWrapper.afterCompletion
    .at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.
    informSynchronizations
    .at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.cleanup
    .at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.end
    

Problem conclusion

  • Local transaction has been modified to correctly enlisted with
    RRS to commit or rollback on a transaction boundary and allow
    the connection to be cleanup without J2CA0081E.
    
    APAR PK52881 is currently targeted for inclusion in Service
    Level (Fix Pack) 6.1.0.13 of WebSphere Application Server V6.1
    for z/OS.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK52881

  • Reported component name

    WEBSPHERE FOR Z

  • Reported component ID

    5655I3500

  • Reported release

    610

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-09-13

  • Closed date

    2007-10-20

  • Last modified date

    2007-12-03

  • 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 FOR Z

  • Fixed component ID

    5655I3500

Applicable component levels

  • R500 PSN

       UP

  • R601 PSN

       UP

  • R610 PSY UK31212

       UP07/11/22 P F711

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS7K4U","label":"WebSphere Application Server for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
28 December 2021