No Global Transaction exists to rollback - Failed during Commit
|
HI, Getting below error when doing a load test. Below highlighted commit step is done at the end of Agent Activity on the WO. (Used OOTB commitwitherrorHandling) Gone through PDN threads and found one related to this (Check XA Driver configuration), i have verified the same and it is as expected.
PEGA Version : 7.1.9 Below are high level on steps we do in agent activity: 1. Browse first 100 records from DB whose status is pending (used RDB-List) 2. Create Work OBject and with in WO: 2.1: Some business logic to see what records need to be processed. 2.2: Final activity to Send these 100 records to another system and wait for response and update the status back to DB for each record (Using Connect-REST to send the request) 3. Finally doing a commitwitherror handling on the WO
$WTRN0124_TIMED_OUT_TRANSACTION_STACK ºWTRN0124I: When the timeout occurred the thread with which the transaction is, or was most recently, associated was {0}. The stack trace of this thread when the timeout occurred was: {1} com.ibm.ws.tx.jta.TimeoutManager 0com.ibm.ws.Transaction.resources.TransactionMsgs Application Server |
|
HI, Getting below error when doing a load test. Below highlighted commit step is done at the end of Agent Activity on the WO. (Used OOTB commitwitherrorHandling) Gone through PDN threads and found one related to this (Check XA Driver configuration), i have verified the same and it is as expected.
PEGA Version : 7.1.9 Below are high level on steps we do in agent activity: 1. Browse first 100 records from DB whose status is pending (used RDB-List) 2. Create Work OBject and with in WO: 2.1: Some business logic to see what records need to be processed. 2.2: Final activity to Send these 100 records to another system and wait for response and update the status back to DB for each record (Using Connect-REST to send the request) 3. Finally doing a commitwitherror handling on the WO
$WTRN0124_TIMED_OUT_TRANSACTION_STACK ºWTRN0124I: When the timeout occurred the thread with which the transaction is, or was most recently, associated was {0}. The stack trace of this thread when the timeout occurred was: {1} com.ibm.ws.tx.jta.TimeoutManager 0com.ibm.ws.Transaction.resources.TransactionMsgs Application Server |
… |
é2016-12-02 09:58:36,249 [PegaWorkManager : 12] [ STANDARD] [ ] [ FPM:01.03] ( internal.access.DatabaseImpl) ERROR - Encountered problem when performing a Commit
com.pega.pegarules.pub.database.JTAException: Exception while attempting to start global transaction: code: <none> SQLState: @No Global Transaction exists to rollback. Message: <none>
From: (BED0E2D3A0DF3646895AA75A014E9A2D6)
| at com.pega.pegarules.data.internal.access.ThreadConnectionStoreImpl.endTransaction(ThreadConnectionStoreImpl.java:230) | |
| at com.pega.pegarules.data.internal.access.ThreadConnectionStoreImpl.rollback(ThreadConnectionStoreImpl.java:403) | |
| at com.pega.pegarules.data.internal.access.DatabaseImpl.attemptToProcessUpdates(DatabaseImpl.java:2755) | |
| at com.pega.pegarules.data.internal.access.DatabaseImpl.processUpdates(DatabaseImpl.java:2322) | |
| at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2061) | |
| at com.pegarules.generated.activity.ra_action_scisend_4e9acf40f0e69c32db58dd8a43d44346.step11_circum0(ra_action_scisend_4e9acf40f0e69c32db58dd8a43d44346.java:1022) | |
| at com.pegarules.generated.activity.ra_action_scisend_4e9acf40f0e69c32db58dd8a43d44346.perform(ra_action_scisend_4e9acf40f0e69c32db58dd8a43d44346.java:294) | |
| at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3505) | |
| at com.pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:721) | |
| at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:602) | |
| at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:945) | |
| at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1259) | |
| at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008) | |
| at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:901) | |
| at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:670) | |
| at com.pega.pegarules.session.internal.async.Agent.queueBatchActivityForAgent(Agent.java:1504) | |
| at com.pega.pegarules.session.internal.async.Agent.queueBatchActivityForAgent(Agent.java:1293) | |
| at com.pega.pegarules.session.internal.async.AgentQueue.run(AgentQueue.java:792) | |
| at com.pega.pegarules.session.internal.async.Agent.runAgentTask(Agent.java:936) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.processAsyncTask(AsyncServant.java:221) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.invoke(AsyncServant.java:167) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:315) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:263) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.ejb.EngineBean.invokeEngine(EngineBean.java:225) | |
| at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source) | |
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56) | |
| at java.lang.reflect.Method.invoke(Method.java:620) | |
| at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370) | |
| at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411) | |
| at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223) | |
| at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:245) | |
| at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:168) | |
| at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.mdb.PRAsync.processRequest(PRAsync.java:155) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.AsyncTask.run(AsyncTask.java:64) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.RunnableWrapper.run(RunnableWrapper.java:71) | |
| at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:271) | |
| at java.security.AccessController.doPrivileged(AccessController.java:400) | |
| at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:797) | |
| at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222) | |
| at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206) | |
| at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881) |
Caused by:
java.lang.IllegalStateException: No Global Transaction exists to rollback.
| at com.ibm.ws.tx.jta.UserTransactionImpl.rollback(UserTransactionImpl.java:350) | ||
| at com.ibm.ejs.container.UserTransactionWrapper.rollback(UserTransactionWrapper.java:352) | ||
| at com.pega.pegarules.data.internal.access.ThreadConnectionStoreImpl.endTransaction(ThreadConnectionStoreImpl.java:228) | ||
| ... 41 more | ||
| SystemOut Dispatcher-Thread-62 < !HPEL 0 X¾Á·[ „ q | † |
Î2016-12-02 09:58:36,250 [PegaWorkManager : 12] [ STANDARD] [ ] [ FPM:01.03] (_Work_Communication_SCI.Action) ERROR - Error in commit()
com.pega.pegarules.pub.database.JTAException: Exception while attempting to start global transaction: code: <none> SQLState: No Global Transaction exists to rollback. Message: <none>
From: (BED0E2D3A0DF3646895AA75A014E9A2D6)
| at com.pega.pegarules.data.internal.access.ThreadConnectionStoreImpl.endTransaction(ThreadConnectionStoreImpl.java:230) | |
| at com.pega.pegarules.data.internal.access.ThreadConnectionStoreImpl.rollback(ThreadConnectionStoreImpl.java:403) | |
| at com.pega.pegarules.data.internal.access.DatabaseImpl.attemptToProcessUpdates(DatabaseImpl.java:2755) | |
| at com.pega.pegarules.data.internal.access.DatabaseImpl.processUpdates(DatabaseImpl.java:2322) | |
| at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2061) | |
| at com.pegarules.generated.activity.ra_action_scisend_4e9acf40f0e69c32db58dd8a43d44346.step11_circum0(ra_action_scisend_4e9acf40f0e69c32db58dd8a43d44346.java:1022) | |
| at com.pegarules.generated.activity.ra_action_scisend_4e9acf40f0e69c32db58dd8a43d44346.perform(ra_action_scisend_4e9acf40f0e69c32db58dd8a43d44346.java:294) | |
| at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3505) | |
| at com.pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:721) | |
| at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:602) | |
| at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:945) | |
| at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1259) | |
| at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008) | |
| at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:901) | |
| at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:670) | |
| at com.pega.pegarules.session.internal.async.Agent.queueBatchActivityForAgent(Agent.java:1504) | |
| at com.pega.pegarules.session.internal.async.Agent.queueBatchActivityForAgent(Agent.java:1293) | |
| at com.pega.pegarules.session.internal.async.AgentQueue.run(AgentQueue.java:792) | |
| at com.pega.pegarules.session.internal.async.Agent.runAgentTask(Agent.java:936) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.processAsyncTask(AsyncServant.java:221) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.invoke(AsyncServant.java:167) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:315) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:263) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.ejb.EngineBean.invokeEngine(EngineBean.java:225) | |
| at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source) | |
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56) | |
| at java.lang.reflect.Method.invoke(Method.java:620) | |
| at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370) | |
| at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411) | |
| at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223) | |
| at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:245) | |
| at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:168) | |
| at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.mdb.PRAsync.processRequest(PRAsync.java:155) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.AsyncTask.run(AsyncTask.java:64) | |
| at com.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.RunnableWrapper.run(RunnableWrapper.java:71) | |
| at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:271) | |
| at java.security.AccessController.doPrivileged(AccessController.java:400) | |
| at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:797) | |
| at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222) | |
| at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206) | |
|
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
***Updated by Moderator: Marissa to add group tag SR Exists*** |
PEG
IN
I'm afraid to ask you that what is the driver used for external database as you were using RDB-List to fetch the data from external db. Is it XA driver or non-XA?
Tcs
IN
Hi, Please find below my findings and please let me know any suggestions.
As explained above, regarding the error and exceptions in logs. I have observed that the issue is with the table where we are doing a saving a record into, which has a BLOB column (Required to save Email content - Larger messages).
Observation:
Scenario 1 : We ran a campaign with 100000 records and the records in table were 0. This campaign ran successfully without any issues.
Scenario 2 : We ran a campaign with100000 records again and 40000 got inserted on top of above load. After that we started getting the timeout issue.
If I truncate the table, and run the campaign, it seems to work fine as expetected.
The tablespace allotted is 40GB.