Disable Automatic Index Rebuilding For Unusable Indexes

Question / Problem: 

Kofax Analytics for Capture Alert.Log for the database is showing that Indexes have been marked unusable.  Is there any method to disable unused indexes in the KAFC application?

Answer / Solution: 

The issue where indexes have been marked as unusable is due to the way in which Kofax Insight is rebuilding the indexes automatically, as opposed to being done by Oracle. 

A snippet of the possible error(s) has been included for reference, as follows: 

Index KCKA_PRDKOF01_D.I_BatchGuidChangedFieldBatc_01 or some [sub]partitions of the index have been marked unusable

Index KCKA_PRDKOF01_D.I_ReceivedTimeChangedFieldB_01 or some [sub]partitions of the index have been marked unusable

Index KCKA_PRDKOF01_D.I_HistoryOfFieldDeleteChunk or some [sub]partitions of the index have been marked unusable

Index KCKA_PRDKOF01_D.I_IdHistoryOfFieldDays or some [sub]partitions of the index have been marked unusable

Index KCKA_PRDKOF01_D.I_ReceivedTimeCountOfTouche_01 or some [sub]partitions of the index have been marked unusable

Index KCKA_PRDKOF01_D.I_ReceivedTimeOPSeparations or some [sub]partitions of the index have been marked unusable

 

Steps to Disable Rebuilding Indexes for Kofax Analytics for Capture: 

• Ensure your version of the Kofax Insight product is at least 5.4.0.12
• Review and Complete steps to disable the Auto-Index Rebuilding by following the steps in the documents, attached: 
  • KAFC_Disable_Rebuilding_Indexes.docx
  • KAFC_Disable_Rebuilding_Indexes.sql

Source: Kofax Analytics for MarkView (KAMV) - COD7425; See Related Knowledge Article

Applies to:  

Product	Version
KAFC	2.0.0.2