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
- Launch the Pega Client Lifecycle Management (CLM) Relationship Manager
- Click the 'New' orange button to onboard
- Select Individual or Organization
- 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.
Tags:
Published February 22, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.