Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Report definition performance degrades after Pega 8.1.4 upgrade

SA-86461

Summary



After upgrading to Pega  Platform 8.1.4, report definition performance degrades.


Error Messages



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
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request
| SQL Code: 0 | SQL State: 57014
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 is coming in the logs



Steps to Reproduce



Perform a Search operation which executes  a report definition in the background.


Root Cause



A defect or configuration issue in the  operating environment.

The report definition generated query's performance degrades and takes approximately 156 seconds to be executed.
It must be noted that large data is being extracted. Additionally, the performance degraded due to the introduction of the 'AND "PartyURI"."pxindexpurpose" = ?' SQL parameter in Pega Platform 8.1.4.



Resolution



Update to Pega Platform 8.1.6.

In Pega Platform 8.1.4, the 'AND "PartyURI"."pxindexpurpose" = ?' additional parameter introduced is addressed in Pega Platform 8.1.6.

Additionally, to optimize the query in the current release, database timeout is removed in the database,

Increase the report timeout in the DataAccess tab of the report definition from 30 seconds to 120 seconds.
Suggest Edit

Published December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us