Rule resolved SQL query times out on MSSQL database server
After upgrading to Pega 7.4, report definitions that results in running rule resolved database queries time out on Microsoft SQLServer (MSSQL) database.
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
There is an issue in MSSQL server with rule resolved queries which delays the running time of the queries.