Hi, team
We face the following error and pega application is freezing.
It seems be related to report definition, but I’m not sure how I resolve the issue.
Do you know how I resolve the issue?
It is occurring many times..
An error occured on executing the query for the report definition - There was a problem getting a list:
code: 0 SQLState: 57014 Message: ERROR: canceling statement due to user request
@YukiS888 please could you check PDC and your logs to find which Pega ALERT errors are linked to this?
Can you pin down the SQL which is causing these errors?
If the issue occurs specifically due to a custom report definition, then likely you will need to log a support incident and provide these details so that Cloud team can check which DB parameter wal_buffers need to be increased to certain value and perhaps an index creation may help.
This is best dealt with by logging a support incident.
Thank you for your kind advice.
I seldom use PDC… I’ve just checked log in My pega cloud.
“Log” means log from Event viewer in PDC?
Thank you so much. I found the kind of error in Event viewer. I’ll ask Pega cloud team via MSP about the cause of error.
@YukiS888 that’s great. Can you update us on what error you found?
If you do log a cloud SR (or a product INC incident) could you provide the number here so that we can track and learn from this?
@MarijeSchillern I sent you message.
What is Resolution that Pega Support team has given or is there any article for the issue?
@Maramreddy I believe that the issue came down to the fact that there was one report definition which was taking a long time, and caused Page List update failures.
The solution was to set the Report Definition timeout to 120s on the client side.
@YukiS888 could you provide some more input?