SQLState error occurring in pega cloud
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
Accepted Solution
Updated: 12 May 2022 0:35 EDT
Pegasystems Inc.
GB
@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.
Updated: 11 May 2022 3:01 EDT
PKUtech Co., Ltd
JP
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?
https://academy.pega.com/topic/how-access-pega-alert-logs-pega-cloud/v1?check_logged_in=1
PKUtech Co., Ltd
JP
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.
Pegasystems Inc.
GB
@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?
PKUtech Co., Ltd
JP
@MarijeSchillern I sent you message.
Updated: 26 May 2022 10:28 EDT
Pegasystems Inc.
GB
@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?