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

Property list blank in BIX extract rule



When trying to create a BIX extract rule, the list of properties does not show up on the pop up screen to select for extract.

Error Messages

On screen user views "No Matches Found".  
On the clipboard user sees error "Retrieving the report data exceeded the limit of 30 seconds."

Steps to Reproduce

Try to create an extract rule and select properties.

Root Cause

The root cause of this problem is in a third-party product. The select query to retrieve the properties is taking a lot of time.  


This issue is resolved by making the following local-change to the operating environment: 

Within the rules schema there is a stored procedure called SPPR_REBUILD_INDEXES which rebuilds all of the indexes of the rules tables and recomputes the statistics on them. 

Execute this stored procedure with the parameter Index_type set to 'rules'

For example, on a SQL Server database you must run this command

        exec SPPR_REBUILD_INDEXES @Index_type='rules'

With the database indexes rebuilts the property list is populates as expected.

Published January 31, 2016 - Updated December 2, 2021

Was this useful?

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.

Did you find this content helpful?

Want to help us improve this content?

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