Large number of queue items are not processed
Queue items are not processed when there are about 2 million queue items per day.
An error occurred on executing the query for the report definition -
com.pega.pegarules.pub.database.DatabaseException: 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
A defect in Pegasystems’ code or rules.
As a local-change, enable the AUTOVACUUM setting.
Published August 15, 2019 - 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.