Support Article

Method destroy failed when trying to executeon ManagedConnection

SA-33130

Summary



Method destroy failed while trying to execute method destroy on ManagedConnection


Error Messages



1/25/17 13:45:57:332 CST] 0000008e FfdcProviderWcom.ibm.ws.ffdc.impl.FfdcProviderlogIncident FFDC1003I: FFDC Incident emitted on /apps_01/webapps/BaseXPWAS8_profile/logs/ffdc/XP2_server0_83b4d329_17.01.25_13.45.57.3282069304147777525163.txt com.ibm.ejs.container.LocalExceptionMappingStrategy.setUncheckedException 178
[1/25/17 13:45:57:358 CST] 0000008e FfdcProviderWcom.ibm.ws.ffdc.impl.FfdcProviderlogIncident FFDC1003I: FFDC Incident emitted on /apps_01/webapps/BaseXPWAS8_profile/logs/ffdc/XP2_server0_83b4d329_17.01.25_13.45.57.3338276440138716568418.txt com.ibm.ejs.j2c.MCWrapper.destroy 797
[1/25/17 13:45:57:358 CST] 0000008e MCWrapper E J2CA0081E: Method destroy failed while trying to execute method destroy on ManagedConnectionWSRdbManagedConnectionImpl@8639ff16 from resource No longer available. Caught exception: java.lang.NullPointerException
at oracle.jdbc.pool.OraclePooledConnection.removeFromImplictCache(OraclePooledConnection.java:1064)
at oracle.jdbc.pool.OracleImplicitConnectionCache.storeCacheConnection(OracleImplicitConnectionCache.java:1470)
at oracle.jdbc.pool.OracleImplicitConnectionCache.reusePooledConnection(OracleImplicitConnectionCache.java:1727)
at oracle.jdbc.pool.OracleConnectionCacheEventListener.connectionClosed(OracleConnectionCacheEventListener.java:87)
at oracle.jdbc.pool.OraclePooledConnection.callImplicitCacheListener(OraclePooledConnection.java:622)
at oracle.jdbc.pool.OraclePooledConnection.logicalCloseForImplicitConnectionCache(OraclePooledConnection.java:536)
at oracle.jdbc.pool.OraclePooledConnection.logicalClose(OraclePooledConnection.java:557)
at oracle.jdbc.driver.LogicalConnection.closeInternal(LogicalConnection.java:309)
at oracle.jdbc.driver.LogicalConnection.close(LogicalConnection.java:274)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3873)
at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:2087)
at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:2954)
at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2608)
at com.ibm.ejs.j2c.LocalTransactionWrapper.afterCompletion(LocalTransactionWrapper.java:1295)
at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.driveSynchronization(LocalTranCoordImpl.java:581)
at com.ibm.tx.ltc.embeddable.impl.EmbeddableLocalTranCoordImpl.informSynchronizations(EmbeddableLocalTranCoordImpl.java:220)


Steps to Reproduce



Configure Oracle RAC (Real Application Cluster) datasource in Websphere.


Root Cause



A third-party product issue. Did not follow the IBM Websphere Oracle RAC datasource setup.

Resolution



Make the following change to the operating environment:

The following custom properties for the datasource need to follow the exact order:


disableWASConnectionPooling
connectionCachingEnabled
connectionCacheName
removeExistingOracleConnectionPoolIfExists


Refer to the relevant IBM documentation if needed.

Published January 31, 2017 - Updated February 4, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.