IBM Support

PM06532: DATABASE CONNECTIONS IN COMPOSITE APPLICATIONS SCHEDULED TASK AR E NOT CLOSED CORRECTLY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The UpdateApplicationsCatalogTask of the composite application
    infrastructure opens a
    database transaction that does not get closed in all component
    operations. This results in
    leaking connections.
    
    FFDC files are showing a lot of the following exceptions:
    
    com.ibm.websphere.ce.j2c.ConnectionWaitTimeoutException
    MaxConnectionsReached
    
    Connection Leak Logic Information:
    State:STATE_TRAN_WRAPPER_INUSE
    Thread Name: SchedulerWorkManager
    getConnection stack trace information:
    
    com.ibm.ejs.j2c.ConnectionManager
    .allocateConnection(ConnectionManager.java(Compiled Code))
    com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource
    .getConnection(WSJdbcDataSource.java(Compiled Code))
    com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource
    .getConnection(WSJdbcDataSource.java(Compiled Code))
    com.ibm.wps.services.datastore.DomainDataStoreImpl
    .getConnectionInternal(DomainDataStoreImpl.java:188)
    com.ibm.wps.services.datastore.DomainDataStoreImpl
    .getConnection(DomainDataStoreImpl.java:131)
    com.ibm.wkplc.cai.util.Session.initDataConnector(Session
    .java:163)
    [...]
    com.ibm.wps.cai.scheduler.tasks.UpdateApplicationsCatalogTask$Up
    dateApplicationsCatalogAction.run(UpdateApplicationsCatalogTask
    .java:133)
    

Local fix

Problem summary

  • The UpdateApplicationsCatalogTask of the composite application
    infrastructure opens a database transaction that does not get
    closed in all component operations. This results in leaking
    connections.
    
    FFDC files are showing a lot of the following exceptions:
    
    com.ibm.websphere.ce.j2c.ConnectionWaitTimeoutException
    MaxConnectionsReached
    
    NOTE: The following config task must be executed:
        <WPS_HOME>/config/WPSconfig.bat apply-pm06532
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM06532

  • Reported component name

    WEBSPHERE PORTA

  • Reported component ID

    5724E7600

  • Reported release

    60J

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-02

  • Closed date

    2010-02-18

  • Last modified date

    2010-03-17

  • 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 PORTA

  • Fixed component ID

    5724E7600

Applicable component levels

  • R60J PSY

       UP

  • R60K PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHRKX","label":"WebSphere Portal"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0.1.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 March 2010