troubleshooting Question

WAS pooling issue with oracle 10g

Avatar of Mub123
Mub123 asked on
Java App Servers
4 Comments1 Solution2781 ViewsLast Modified:
We are getting an error everyday morning for the first DB connection from WAS. The issue will not appear again until the next day. The stack trace is as follows,

Could you please help us to find a way out of this situation? I know this could overcome with WAS pooling settings. But really not sure what needs to be changed and its impact....


 [5/24/08 12:12:50:922 AST] 00000024 SystemErr     R com.ibm.websphere.ce.cm.StaleConnectionException: enlist: caught Exception

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:643)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2014)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1969)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.isi.oms.util.ExchangeStore.addToStore(ExchangeStore.java:48)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.isi.oms.util.ExchangeStore.getExchange(ExchangeStore.java:31)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.isi.oms.beans.Order.ParseFIXMessagePostProcess(Order.java:1240)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.mubasher.connectors.trs.adaptors.TRSInternalOMSAdaptor.createOrder(TRSInternalOMSAdaptor.java:704)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.mubasher.connectors.trs.adaptors.TRSInternalOMSAdaptor.processMessage(TRSInternalOMSAdaptor.java:185)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.mubasher.connectors.trs.extern.TRSOrderProcessor.processMessage(TRSOrderProcessor.java:48)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.mubasher.connectors.trs.mdb.TRSConnectorBean.onMessage(TRSConnectorBean.java:83)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ejs.jms.listener.MDBWrapper$PriviledgedOnMessage.run(MDBWrapper.java:302)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:63)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ejs.jms.listener.MDBWrapper.callOnMessage(MDBWrapper.java:271)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ejs.jms.listener.MDBWrapper.onMessage(MDBWrapper.java:240)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.mq.jms.MQSession.run(MQSession.java:1682)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ejs.jms.JMSSessionHandle.run(JMSSessionHandle.java:967)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ejs.jms.listener.ServerSession.connectionConsumerOnMessage(ServerSession.java:891)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ejs.jms.listener.ServerSession.onMessage(ServerSession.java:656)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ejs.jms.listener.ServerSession.dispatch(ServerSession.java:623)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at java.lang.reflect.Method.invoke(Method.java:615)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ejs.jms.listener.ServerSessionDispatcher.dispatch(ServerSessionDispatcher.java:37)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:96)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:132)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ejs.jms.listener.ServerSession.run(ServerSession.java:481)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R      at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1498)

[5/24/08 12:12:50:922 AST] 00000024 SystemErr     R Caused by: oracle.jdbc.xa.OracleXAException

            at oracle.jdbc.xa.OracleXAException.<init>(OracleXAException.java:44)

            at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:938)

            at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:244)

            at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1324)

            at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1467)

            at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:141)

            at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1103)

            at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:525)

            at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3219)

            at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:396)

            at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:693)

            at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1723)

            at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java:2109)

            at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:600)

            at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2014)

            at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1969)

            at com.isi.oms.util.ExchangeStore.addToStore(ExchangeStore.java:48)

            at com.isi.oms.util.ExchangeStore.getExchange(ExchangeStore.java:31)

            at com.isi.oms.beans.Order.ParseFIXMessagePostProcess(Order.java:1240)

            at com.mubasher.connectors.trs.adaptors.TRSInternalOMSAdaptor.createOrder(TRSInternalOMSAdaptor.java:704)

            at com.mubasher.connectors.trs.adaptors.TRSInternalOMSAdaptor.processMessage(TRSInternalOMSAdaptor.java:185)

            at com.mubasher.connectors.trs.extern.TRSOrderProcessor.processMessage(TRSOrderProcessor.java:48)

            at com.mubasher.connectors.trs.mdb.TRSConnectorBean.onMessage(TRSConnectorBean.java:83)

            at com.ibm.ejs.jms.listener.MDBWrapper$PriviledgedOnMessage.run(MDBWrapper.java:302)

            at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:63)

            at com.ibm.ejs.jms.listener.MDBWrapper.callOnMessage(MDBWrapper.java:271)

            at com.ibm.ejs.jms.listener.MDBWrapper.onMessage(MDBWrapper.java:240)

            at com.ibm.mq.jms.MQSession.run(MQSession.java:1682)

            at com.ibm.ejs.jms.JMSSessionHandle.run(JMSSessionHandle.java:967)

            at com.ibm.ejs.jms.listener.ServerSession.connectionConsumerOnMessage(ServerSession.java:891)

            at com.ibm.ejs.jms.listener.ServerSession.onMessage(ServerSession.java:656)

            at com.ibm.ejs.jms.listener.ServerSession.dispatch(ServerSession.java:623)

            at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:615)

            at com.ibm.ejs.jms.listener.ServerSessionDispatcher.dispatch(ServerSessionDispatcher.java:37)

            at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:96)

            at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:132)

            at com.ibm.ejs.jms.listener.ServerSession.run(ServerSession.java:481)

            at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1498)

 

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros