Support Article
Timeout error occurs on selecting a date range in custom filter
SA-68850
Summary
Timeout error occurs on selecting a date range, that is more than one day, in the custom filter in a report definition. Error occurs despite exposing all the columns and indexing the properties used in the filter.
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
Unknown
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
- Apply HFix-40408.
- Create a new Data-Admin-System-Setting (DASS) with the name, 'reporting/useForceOrderHintForRRandAC' in the Pega-RULES ruleset.
- Set the value as true.
Published January 5, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.