• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

XATransaction E J2CA0027E: An exception occurred while invoking prepare on an XA Resource Adapter

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All,

When i am trying to board some large number of data via upload utility tool in my application, first all the data get successfully inserted in staging table and then from there it goes to queue. Queue depth keeps increasing in Admin Console upto some count but then it stops and atrts decreasing and at this time I am getting this exception in SystemOut.log:



10/23/12 7:40:41:399 GMT] 000000d5 XATransaction E J2CA0027E: An exception occurred while invoking prepare on an XA Resource Adapter from DataSource jms/XXX, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54),
data(0000013a8c90f4f3000000010001041f45aeb1a76c8b3d490023648fb0bd1ff30fd1bd740000013a8c90f4f3000000010001041f45aeb1a76c8b3d490023648fb0bd1ff30fd1bd74000000010000000000000000000000000001)} : javax.transaction.xa.XAException: CWSIC8007E: An exception was caught from the remote server with Probe Id 3-013-0010. Exception: .
at com.ibm.ws.sib.comms.common.CommsByteBuffer.parseSingleException(CommsByteBuffer.java:1753)
at com.ibm.ws.sib.comms.common.CommsByteBuffer.getException(CommsByteBuffer.java:1263)
at com.ibm.ws.sib.comms.common.CommsByteBuffer.checkXACommandCompletionStatus(CommsByteBuffer.java:1218)
at com.ibm.ws.sib.comms.client.OptimizedSIXAResourceProxy.prepare(OptimizedSIXAResourceProxy.java:749)
at com.ibm.ws.sib.comms.client.SuspendableXAResource.prepare(SuspendableXAResource.java:386)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaRecoverableSiXaResource.prepare(JmsJcaRecoverableSiXaResource.java:260)
at com.ibm.ejs.j2c.XATransactionWrapper.prepare(XATransactionWrapper.java:1136)
at com.ibm.tx.jta.JTAXAResourceImpl.prepare(JTAXAResourceImpl.java:226)
at com.ibm.tx.jta.RegisteredResources.prepareResource(RegisteredResources.java:1159)
at com.ibm.tx.jta.RegisteredResources.distributePrepare(RegisteredResources.java:1415)
at com.ibm.tx.jta.TransactionImpl.prepareResources(TransactionImpl.java:1446)
at com.ibm.ws.tx.jta.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:557)
at com.ibm.tx.jta.TransactionImpl.processCommit(TransactionImpl.java:986)
at com.ibm.tx.jta.TransactionImpl.commit(TransactionImpl.java:920)
at com.ibm.ws.tx.jta.TranManagerImpl.commit(TranManagerImpl.java:436)
at com.ibm.tx.jta.TranManagerSet.commit(TranManagerSet.java:161)
at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:930)
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:233)
at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:570)
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4558)
at com.XXXgroup.XXX.interfaces.edfm.service.EJSLocalStatelessEdfmProcess_27d119f6.epEnqueueLoan(Unknown Source)
at com.XXXgroup.XXX.interfaces.edfm.service.EdfmServiceBean.processEditBatch(EdfmServiceBean.java:2621)
at com.XXXgroup.XXX.interfaces.edfm.service.EdfmServiceBean.processLoanBoarding(EdfmServiceBean.java:646)
at com.XXXgroup.XXX.interfaces.edfm.service.EdfmServiceBean.epProcessLoanBoarding(EdfmServiceBean.java:296)
at com.XXXgroup.XXX.interfaces.edfm.service.EJSLocalStatelessEdfmService_12a913fe.epProcessLoanBoarding(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.pmigroup.framework.bg.ApplFacadeMDBBean.handleJavaSerializedMessage(ApplFacadeMDBBean.java:428)
at com.pmigroup.framework.bg.ApplFacadeMDBBean.onMessage(ApplFacadeMDBBean.java:298)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1093)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:778)
at $Proxy21.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:233)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:900)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:552)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1613)
Caused by: com.ibm.websphere.sib.exception.SIErrorException: CWSIC8002E: An internal error occurred. An unknown or unexpected exception was thrown by the core API: exception com.ibm.ws.sib.msgstore.TransactionException: com.ibm.ws.sib.msgstore.PersistenceException: Cannot ROLLBACK batch as it not in the correct state! State=STATE_ROLLEDBACK.
at com.ibm.ws.sib.comms.common.CommsByteBuffer.parseSingleException(CommsByteBuffer.java:1884)
... 38 more
Caused by: com.ibm.websphere.sib.exception.SIErrorException: CWSIC8002E: An internal error occurred. An unknown or unexpected exception was thrown by the core API: exception com.ibm.ws.sib.msgstore.PersistenceException: Cannot ROLLBACK batch as it not in the correct state! State=STATE_ROLLEDBACK.
... 39 more
.
[10/23/12 7:40:41:401 GMT] 000000d5 RegisteredRes E WTRN0046E: An attempt by the transaction manager to call prepare on a transactional resource has resulted in an error. The error code was XAER_RMFAIL. The exception stack trace follows: javax.transaction.xa.XAException: CWSIC8007E: An exception was caught from the remote server with Probe Id 3-013-0010. Exception: .
at com.ibm.ws.sib.comms.common.CommsByteBuffer.parseSingleException(CommsByteBuffer.java:1753)
at com.ibm.ws.sib.comms.common.CommsByteBuffer.getException(CommsByteBuffer.java:1263)
at com.ibm.ws.sib.comms.common.CommsByteBuffer.checkXACommandCompletionStatus(CommsByteBuffer.java:1218)
at com.ibm.ws.sib.comms.client.OptimizedSIXAResourceProxy.prepare(OptimizedSIXAResourceProxy.java:749)
at com.ibm.ws.sib.comms.client.SuspendableXAResource.prepare(SuspendableXAResource.java:386)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaRecoverableSiXaResource.prepare(JmsJcaRecoverableSiXaResource.java:260)
at com.ibm.ejs.j2c.XATransactionWrapper.prepare(XATransactionWrapper.java:1136)
at com.ibm.tx.jta.JTAXAResourceImpl.prepare(JTAXAResourceImpl.java:226)
at com.ibm.tx.jta.RegisteredResources.prepareResource(RegisteredResources.java:1159)
at com.ibm.tx.jta.RegisteredResources.distributePrepare(RegisteredResources.java:1415)
at com.ibm.tx.jta.TransactionImpl.prepareResources(TransactionImpl.java:1446)
at com.ibm.ws.tx.jta.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:557)
at com.ibm.tx.jta.TransactionImpl.processCommit(TransactionImpl.java:986)
at com.ibm.tx.jta.TransactionImpl.commit(TransactionImpl.java:920)
at com.ibm.ws.tx.jta.TranManagerImpl.commit(TranManagerImpl.java:436)
at com.ibm.tx.jta.TranManagerSet.commit(TranManagerSet.java:161)
at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:930)
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:233)
at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:570)
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4558)
at com.XXXgroup.XXX.interfaces.edfm.service.EJSLocalStatelessEdfmProcess_27d119f6.epEnqueueLoan(Unknown Source)
at com.XXXgroup.XXX.interfaces.edfm.service.EdfmServiceBean.processEditBatch(EdfmServiceBean.java:2621)
at com.XXXgroup.XXX.interfaces.edfm.service.EdfmServiceBean.processLoanBoarding(EdfmServiceBean.java:646)
at com.XXXgroup.XXX.interfaces.edfm.service.EdfmServiceBean.epProcessLoanBoarding(EdfmServiceBean.java:296)
at com.XXXgroup.XXX.interfaces.edfm.service.EJSLocalStatelessEdfmService_12a913fe.epProcessLoanBoarding(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.pmigroup.framework.bg.ApplFacadeMDBBean.handleJavaSerializedMessage(ApplFacadeMDBBean.java:428)
at com.pmigroup.framework.bg.ApplFacadeMDBBean.onMessage(ApplFacadeMDBBean.java:298)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1093)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:778)
at $Proxy21.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:233)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:900)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:552)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1613)
Caused by: com.ibm.websphere.sib.exception.SIErrorException: CWSIC8002E: An internal error occurred. An unknown or unexpected exception was thrown by the core API: exception com.ibm.ws.sib.msgstore.TransactionException: com.ibm.ws.sib.msgstore.PersistenceException: Cannot ROLLBACK batch as it not in the correct state! State=STATE_ROLLEDBACK.
at com.ibm.ws.sib.comms.common.CommsByteBuffer.parseSingleException(CommsByteBuffer.java:1884)
... 38 more
Caused by: com.ibm.websphere.sib.exception.SIErrorException: CWSIC8002E: An internal error occurred. An unknown or unexpected exception was thrown by the core API: exception com.ibm.ws.sib.msgstore.PersistenceException: Cannot ROLLBACK batch as it not in the correct state! State=STATE_ROLLEDBACK.
... 39 more

[10/23/12 7:40:41:403 GMT] 000000d5 RegisteredRes E WTRN0086I: XAException encountered during prepare phase for transaction pmicentralEAR_US#pmicentralEJB-5.0.jar#EdfmService 0000013A8C90F4F3000000010001041F45AEB1A76C8B3D490023648FB0BD1FF30FD1BD740000013A8C90F4F3000000010001041F45AEB1A76C8B3D490023648FB0BD1FF30FD1BD7400000001. Local resources follow.
[10/23/12 7:40:41:403 GMT] 000000d5 JTAResourceBa I WTRN0088I: XATransactionWrapper@ 7da57da5 XAResource: com.ibm.ws.sib.api.jmsra.impl.JmsJcaRecoverableSiXaResource@66096609 enlisted: trueHas Tran Rolled Back = false mcWrapper.hashCode()1098400120 encountered XAException with error code XAER_RMFAIL.
[10/23/12 7:40:41:404 GMT] 000000d5 JTAResourceBa I WTRN0089I: XATransactionWrapper@ b290b29 XAResource: com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@7ff07ff0 enlisted: trueHas Tran Rolled Back = false mcWrapper.hashCode()1302351264: Vote: commit.
[10/23/12 7:40:41:426 GMT] 000000d5 RegisteredRes W WTRN0049W: An attempt by the transaction manager to call rollback on a transactional resource has resulted in an XAER_RMFAIL error. The resource was com.ibm.ws.tx.jta.JTAXAResourceImpl@dc20dc2#{XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54),
data(0000013a8c90f4f3000000010001041f45aeb1a76c8b3d490023648fb0bd1ff30fd1bd740000013a8c90f4f3000000010001041f45aeb1a76c8b3d490023648fb0bd1ff30fd1bd74000000010000000000000000000000000001)}


Someone please help me on this, i am stuck in this from last 10 days.
 
reply
    Bookmark Topic Watch Topic
  • New Topic