Avatar of Mub123
Mub123 asked on

WAS pooling issue with oracle 10g

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)

 

Java App Servers

Avatar of undefined
Last Comment
HonorGod

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
HonorGod

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Mub123

Thanks Guru,
I change the WAS minimum pool to 0 and did not get the error for the last couple of days. So, hope this will get rid off this problem for ever.
HonorGod

Excellent.  I'm glad to hear it.  I too hope that this has resolved your issue.
HonorGod

Thanks for the grade and the points.
I'm sorry that you didn't feel it warranted an A.

Good luck & have a great day
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy