Skip to main content

Execution of SF_Filter_Util.UpdateAllFilterResults May Take Hours or Days to Complete

Article # 304014 - Page views: 194



Applies To

  • ERP System: MarkView for Oracle
  • MarkView Version: 9.1+


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.


  • 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.


WARNING: You should test this first in Non-Production before you run in Production as with any system change. 

The script should be run on a quiet system. Most customers run this after hours and/or over a weekend when users are not on the system. 


Keywords: filter