Support Article
Unable to view Advanced and Basic controls in section rule
SA-74601
Summary
In a section rule, unable to view the Advanced and Basic controls.
Error Messages
An error occurred on executing the query for the report definition - 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
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
at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:381) ~[prprivate.jar:?]
Steps to Reproduce
- Open any section rule.
- Click Basic and Advanced options.
Root Cause
On click of the Advanced or the Basic option, the SQL query triggered to provide the controls list from the database takes time to retrieve the results. Hence, the query times out and database exceptions occur and controls do not display in the UI.
For SQL server databases and report definition rules with Rules Resolution enabled, Pega generated a query with an Inner Join that results in a slow execution plan or query time out.
Resolution
Perform the following local-change:
Set the following Dynamic system Setting (DSS) to configure the application to use an Inner Merge Join for the query:
- Setting Purpose: reporting/useMergeHintForRRquery
- Owning Ruleset: Pega-Reporting
- Value: True
Published March 12, 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.