Support Article
Property list blank in BIX extract rule
SA-8669
Summary
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.
Resolution
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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.