Question

6
Replies
493
Views
PHANISURA Member since 2013 4 posts
Tcs
Posted: 3 years ago
Last activity: 3 years 10 months ago
Closed

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

        …

          é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***

System Administration SR Exists
Moderation Team has archived post
Share this page LinkedIn