Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

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

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • 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.
 
    Bookmark Topic Watch Topic
  • New Topic