Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Exception occurs when trying to bulk process items

SA-16088

Summary



An exception occurs when an activity is run to commit a bulk number of cases to the database.


Error Messages



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>


Steps to Reproduce



Run an activity that attempts to commit a bulk number of cases to the database.


Root Cause



The activity is trying to process too much data in one transaction or commit. A review of the SystemOut logs showed there was a timeout error prior to the exception and the alert logs show a number of alerts for that requestor.

Resolution



The issue can be resolved by modifying the activity to commit the transactions in shorter intervals so there will be less data to process with each commit.
Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us