Hello,we have developed a vacation and shift organisation application. This application has a Notes Database to store the data and a VB.Net GUI. Each entry in this application is stored as a document. All read and write operations to this DB are handled by the VB.Net GUI. To search and view entrys, lot of FTSearch commands are used, thats the reason why the fulltext index of this DB must every time actual. After a while, sometimes after 5 new entrys, sometimes after 50 new entrys, I got the error message that the index must be rebuild. To read and write a local copy of DB is used. There are any hints available to fix this broken index after a while ?
Thanks
objNotesDoc = objNotesDB.CreateDocument
objNotesDoc.ReplaceItemValue("Form", "Gridentry")
objNotesDoc.ReplaceItemValue("Grid_Personal_TX", ....)
…
objNotesDoc.Save(True, False)
If objNotesDB.LastFTIndexed < objNotesDB.LastModified Then
objNotesDB.UpdateFTIndex(False)
End If
Doc.Save works fine, the error occurs at reindex database. Actual about 170.000 docs are stored. The only solution at this time is to delete the index and create a new one. But for the end-user it’s not acceptable.