Support Article
Error message displays on the log file
Summary
Error message displays on the log file.
Error Messages
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
- Open a section rule
- Click the Basic tab. 'No items' displays on the popup window
Root Cause
A defect or configuration issue in the operating environment. Dynamic System Setting (DSS) is not present.
Resolution
Perform the following local-change:
- Use the below Dynamic System Setting (DSS)
Purpose: reporting/useForceOrderHint
Ruleset: Pega-RULES
Value: true
for ac
reporting/useForceOrderHintForRRandAC
ruleset: PEGA-RULES
value: true
Purpose: reporting/useMergeHintForRRquery
Ruleset: Pega-Reporting
Value: true
- Restart the node
Published May 1, 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.