Rebuild Filter - Execution of SF_Filter_Util.UpdateAllFilterResults may take hours or days to complete

Applies To

• ERP System: All
• MarkView Version: All

Behavior

The execution of SF_Filter_Util.UpdateAllFilterResults (which is sometimes a step in the application of a Fix Pack) may take several hours or days to complete.

Resolution

Generally, the updating of the filter results can take some time. However, we may be able to increase the speed by excluding the non-required end queues from the filter update. The attached script 'rebuild_filter_v11.sql' can be used to for this purpose, instead of using the generic SF_Filter_Util.UpdateAllFilterResults API call. It still may take some time to update the filter results, but this should perform faster than the original version.

Note: Run the script on a quiet system.