Topic
  • No replies
svhari76
svhari76
1 Post

Pinned topic Websphere Transaction error in RSA

‏2007-09-05T22:35:34Z |
Hi All,

I don't know whether i am posting my issue in right forum.If some one experienced this kind of error before ple do let me know how you resolved this.

Here is my Issue.

I am using MDB bean to listen to a MQ queue and MDb communicates with Stateless session bean and this inturn connects to DB2 using XA Data source and Oracle using Non-XA datasource.(I tried with XA data source for Oracle also).All are transaction managed componenets.I have seen several of this kind of issues and could n't able to resolve by just using XA drivers. I need to set something with local-global transaction.I don't know what that is though.

In both the cases i got the following error.
9/5/07 17:11:40:769 CDT 0000001d RegisteredRes E WTRN0063E: An illegal attempt to commit a one phase capable resource with existing two phase capable resources has occurred.
9/5/07 17:11:40:769 CDT 0000001d RegisteredRes E WTRN0086I: XAException encountered during prepare phase for transaction 00000114D7BA8BC400000001000000020E655C25A2607206568B60E10A2FD0D15CC9DD4A00000114D7BA8BC400000001000000020E655C25A2607206568B60E10A2FD0D15CC9DD4A00000001. Local resources follow.
9/5/07 17:11:40:800 CDT 0000001d RegisteredRes E WTRN0089I: XATransactionWrapper@ 26ae26ae XAResource: com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@26a626a6 enlisted: true mcWrapper.hashCode()1669882760: Vote: readonly.
9/5/07 17:11:40:800 CDT 0000001d RegisteredRes E WTRN0089I: XATransactionWrapper@ 46fc46fc XAResource: com.ibm.ejs.jms.JMSManagedSession$JMSXAResource@55705570 enlisted: true mcWrapper.hashCode()444209786: Vote: commit.
9/5/07 17:11:40:800 CDT 0000001d RegisteredRes E WTRN0089I: LocalTransactionWrapper@:2ff62ff6 localTransaction:com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl@309a309a enlisted:true registeredForSynctruemcWrapper.hashcode()569647604: Vote: none.
9/5/07 17:11:40:878 CDT 0000001d ServerSession W WMSG0031E: Exception processing JMS Message for MDB BridgeServiceMDB1, JMSDestination jms/BridgeMDBQ : javax.ejb.TransactionRolledbackLocalException: ; nested exception is: com.ibm.websphere.csi.CSITransactionRolledbackException:
com.ibm.websphere.csi.CSITransactionRolledbackException:
at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:769)
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:181)
at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:581)
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3876)
at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:107)
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:1510)
javax.ejb.TransactionRolledbackLocalException: ; nested exception is: com.ibm.websphere.csi.CSITransactionRolledbackException:
at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:769)
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:181)
at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:581)
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3876)
at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:107)
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:1510)
Caused by: com.ibm.websphere.csi.CSITransactionRolledbackException:
... 8 more
Can some one through some suggestion to resolve this?

Thanks in advance
Hari