Execution of SF_Filter_Util.UpdateAllFilterResults May Take Hours or Days to Complete
11833
Summary
11833
Applies To
- ERP System: MarkView for Oracle
- MarkView Version: 9.1+
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.
- NOTE: Running 'rebuild_filter_v11.sql' may still take some time to update the filter results, but this should perform faster than the original version.
- The following article contains a query to get a count of items by queue that may be useful in troubleshooting: https://knowledge.kofax.com/MarkView/New_Articles/Query_to_Get_a_Count_of_Work_Items_By_Queue
- NOTE: Running 'rebuild_filter_v11.sql' may still take some time to update the filter results, but this should perform faster than the original version.
- 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.
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