Support Article
BIX fails to fetch properties for extract rule
SA-35861
Summary
The user is unable to select the properties (as the properties are not loading on clicking the gear) to configure the BIX extract rule. The Pega rules log file contains the TimeOutException. This issue is specific to 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
- Create an extract rule.
- Click the gear button, for selecting the properties
Root Cause
A defect in Pegasystems’ code or rules. SQL query optimizer is not choosing the right execution plan. Same query works fine in SQL server 2014 but not in SQL server 2014 + SP2 .
Resolution
Follow the below steps to resolve the issue:
- Apply Hfix-31768 and Hfix-33431
- Create a new Data-Admin-System-Setting with named "reporting/useForceOrderHint" in "Pega-RULES" ruleset and set its vale to true.
Published March 31, 2017 - 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.