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

User Experience
, , ,
1

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?

2

@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

  1. Get tracer w dbQuery option

  2. Take the query to DBA for Explain plan

  3. 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.