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.
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.
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.
0% found this useful