Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Unable to select properties in extract rule

SA-40804

Summary



Unable to select properties in an extract rule. When clicking the gear icon, properties are not loaded and the PegaRULES log file contains an error about a query timing out.
The database is MS SQL Server 2014 SP2.


Error Messages



An error occured 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.


Steps to Reproduce

  1. Open an extract rule
  2. Clear the gear icon to select properties.


Root Cause



A defect in Pegasystems’ code or rules. The SQL query optimizer is not choosing the right execution plan.

Resolution



Perform the below steps:
  1. Apply HFix-34496
  2. Create a new Data-Admin-System-Setting named reporting/useForceOrderHint in the Pega-RULES ruleset and set its value to true.
Suggest Edit

Published August 21, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us