Question
Tata Consultancy Services - India
IN
Last activity: 4 Apr 2024 12:21 EDT
Error: An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: 08006 Message: An I/O error occurred while sending to the backend. DatabaseException caused by prior exception: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend. | SQL Code: 0 | SQL State: 08006
I got this error while running my reports in UserPortal.
i tried to run the same report in Dev environment I didn't get any error.
But in QA environment I am getting this error. What may be the issue? Can anyone explain how to resolve this issue and why it happens?
***Edited by Moderator Marije to add Capability tags***
Accepted Solution
Updated: 4 Apr 2024 12:21 EDT
Pegasystems Inc.
GB
@KowsalyaMK This query looks to be generated from a custom report definition, and possibly timing out due to query size; can you confirm? If this is a custom report, you should consult with your DBA for any index recommendations for improving query performance.
There is insufficient detail here - did you check your PegaRULES and PegaRULES-ALERT logs from the node where the report ran?
For a slow report we recommend the following steps
-
Get tracer w dbQuery option
-
Take the query to DBA for Explain plan
-
Take any index advice provided by the DBA.
If you need an in depth investigation please log a support issue via the MSP and provide the INC id here so we can help track it.