Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Distributed Transaction Exception when uploading large data

 
Rumit Jain
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am trying to board some large amount of data via upload utility tool in my application. Say like i am trying to board some 10K data and only 5K get boarded successfully. Queue depth in Admin cosnole keeps increasing but after some 5k-6K data it starts decreasing. At his point i am getting below exception:

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/BoardLoanQueueFactory, 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 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 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)}
[10/23/12 7:40:41:472 GMT] 0000006a SystemOut O Setting AuthorizedNPIUser*************

Can someone please help me on this. I am relly getting no where on this exception.

 
Ranganathan Kaliyur Mannar
Bartender
Posts: 1101
10
Java Netbeans IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Rumit,
This is an old topic. Please do not reply to old topics. Create a new post to get better responses. I am creating a new post this time for you.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic