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

org.postgresql.util.PSQLException: ERROR: canceling statement



Work table query fails. The issue also occurs when a simple query is run through the Query Runner.

Error Messages

There was a problem performing a database query: There was a problem getting a list: code: 0 SQLState: 57014 Message: ERROR: canceling statement due to user request
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request
| SQL Code: 0 | SQL State: 57014

Steps to Reproduce

Not Applicable

Root Cause

A defect or configuration issue in the operating environment.
The query took longer than 90 seconds to execute and timed out. The issue occurred because the statistics on the database table was not up to date. The ResetTableStats activity run by Pega Predictive Diagnostic Cloud (PDC) everyday impacted the auto-maintenance of the database tables on a Postgres database.


Make the following change to the operating environment:
  1. Update the statistics on the database table. The query executes successfully without timing out.
  2. Update the Dynamic System Setting (DSS) record with the 'PegaAESRemote* ResetTableStats' key to a value of false.
  3. Restart the Util node to disable the ResetTableStats feature.

Published February 10, 2020 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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