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

BIX fails to fetch properties for extract rule



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

  1. Create an extract rule.
  2. 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 .


Follow the below steps to resolve the issue:
  1. Apply Hfix-31768 and Hfix-33431
  2. Create a new Data-Admin-System-Setting with named "reporting/useForceOrderHint" in "Pega-RULES" ruleset and set its vale to true.

Suggest Edit

Published March 31, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

0% found this useful

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