posted 11 years ago
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.