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.

Published March 31, 2017 - Updated October 8, 2020

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.