This is Designer 8.5. Have a lotusscript agent that does removeall as seen below
Set dc = db.FTSearch(“Computed Dashboard Data”,0)
Print "Clearing Computed Dashboard Data: " & dc.Count
Call dc.RemoveAll(True)
I am the manager of the DB in question - checked security and I am accessing the DB as manager. the PRINT message gives the correct / expected count but the documents are never deleted. A subsequent run of the above code gives the same document count. NOTE: I have monitored the count value using lotusscript debug before and after the removeall and the count goes from 103 to 0 indicating the removeall should have succeeded.
Any ideas on thoughts on what may have cause this to stop working?
Thanks
Subject: Are soft deletions enabled in the database properties?
Designer Help has this note for RemoveAll:If soft deletions are enabled, the documents are available in a soft deletions view until removed from that view. If soft deletions are not enabled, the documents are permanently deleted from the database.
Check if your database has soft deletions enabled. If it does, that explains the problem.
You could also try looping through the collection and calling RemovePermanently on the individual documents. That should delete them even when soft deletions are enabled, but you won’t be able to restore them (except from a backup) if you delete the wrong thing.
Subject: Found the answer - thanks for the reply
Your reply was partially on target - the reason the code ‘stopped working’ was an ‘improvement’ I made to stop scanning the entire DB removing each document as I found it and going to the FTSearch. However, I failed to update the index after the first remove from the collection (doing repeats to handle the 5,000 document maximum since I cannot ask all users to change the notes.ini file). Adding an updateftindex between iterations fixed the problem.Thanks!