asked on

Trying to create Full Text Index - Lotus Notes

I have deleted the full text index of a lotus notes database as it was not updating. When I try re-create it, by selecting the database file in Admin Console and selecting Full Text Index, I get an error "Full Text Index - .... This database is already full text indexed". However, when viewing the database it is showing as not indexed and the xxxx.ft folder does not exist in the data folder with the other indexes. Any ideas how I can fix this?

Sjef Bosman

Are you sure you're looking at the same database both times? Is the indexer task busy (re-)creating the index of the database? Maybe there's still something in the cache, so a dbcache flush might help.

Which release is this, in case there are known bugs?

CRAK

Have you verified if the indexer wasn't still busy building the index?

CRAK

(sorry duplicate coment)

Andrew Narunsky

ASKER

Sjef, not at server at the moment, but tried to recreate index right after restarting server, so doubt there was something in cache, but will try flush. Version of domino is 8.02. Didn't look at indexer task but will do so.

Andrew Narunsky

ASKER

ok - it gets more strange - came in this morning and the full text index is now created??? However, if possible I'd like to leave this open a few days 'cause this database tends to suddenly stop indexing after a few days and I have to recreate it each time - all my other databases do not have this problem. Any ideas?

Andrew Narunsky

ASKER

Further Update - found this in the log this morning at 11:40 "Error full text indexing document NT00000000 d:\apps\Lotus\Domino\Data\products.ft (rc=268) File is in use by another program"
Any idea what other program could be trying to acess this???

larsberntrop

backup software?
Anti virus? <= incorrectly configured antivirus can really mess with your Domino server. Make sure ALL the Domino directories, , like the data dir, program dir, transaction logs dir and temporary directories (Where viewindexes will be stored while building them) are excluded from scanning.

Re: auto creation of FTI; lloks like the Domino server queued a request to index the db, and only got around to to it later.

Andrew Narunsky

ASKER

nothing has changed on our backup/antivirus for quite some time, but will ask our IT partner to check it out anyway. The current situation is that the database is indicating that it is Not Indexed and that it needs to be rebuilt. So I'm back to square one in terms of deleted the .ft folder and re-creating. This is the only database out of about 15 that this is happening to.

larsberntrop

The log entry indicates index creation did not compete successfully.

Please specify which options are set for the full text index

ASKER CERTIFIED SOLUTION

Andrew Narunsky

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sjef Bosman

That doesn't "resolve" the issue, it only hides it. Hundred updates per hour is nothing, unless you mean hundred per document (singular), which is an awful lot. That situation should be avoided at all costs.

Nevertheless, the FT indexer normally picks up after a delay and works only every 5-15 minutes or so. It should be capable of doing what you want. I'm wondering what else you modified in your system?

CRAK

That doesn't seem to explain it all:
You've dropped the FT index, and were stuggling to get it rebuild.
The issue is gone after a view(!!) index no longer got discarded after each use.

I tend to second Sjef: what else happened?

Andrew Narunsky

ASKER

The problem was resolved from my own actions and my own further investigations.
Reason for the lower grade is that I probably should have done further research before posting the question.