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

Rule resolved SQL query times out on MSSQL database server

SA-71374

Summary



After upgrading to Pega 7.4, report definitions that results in running rule resolved database queries time out on Microsoft SQLServer (MSSQL) database.


Error Messages



com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out.
DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
 | SQL Code: 0 | SQL State: HY008



Steps to Reproduce

  1. Launch the Pega Client Lifecycle Management (CLM) Relationship Manager
  2. Click the 'New' orange button to onboard
  3. Select Individual or Organization
  4. Run the flow. Error occurs


Root Cause



There is an issue in MSSQL server with rule resolved queries which delays the running time of the queries.


Resolution

Apply HFix-44396.



 

Suggest Edit

Published February 22, 2019 - Updated 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