Skip to main content
Kofax

Disable Automatic Index Rebuilding For Unusable Indexes

3014560

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: 

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

Applies to:  

Product Version
KAFC 2.0.0.2

 

 

  • Was this article helpful?