wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes Distributed Transaction Exception when uploading large data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Distributed Transaction Exception when uploading large data" Watch "Distributed Transaction Exception when uploading large data" New topic
Author

Distributed Transaction Exception when uploading large data

Rumit Jain
Greenhorn

Joined: Nov 02, 2012
Posts: 4
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

Joined: Oct 16, 2003
Posts: 1076
    
  10

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.


Ranga.
SCJP 1.4, OCMJEA/SCEA 5.0.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Distributed Transaction Exception when uploading large data
 
Similar Threads
XATransaction E J2CA0027E: An exception occurred while invoking prepare on an XA Resource Adapter
XA-Transaction Error with WAS 6.1, MQ (SIB) and Oracle 10g
com.ibm.websphere.ce.cm.StaleConnectionException
MQJMS2012: XACLOSE failed
XA exception in JMS