Tips on troubleshooting FT indexing

HCL Domino Domino Forum
,
1

We have a database with 71.000 documents. Filesize is 1.8 GB. We are trying to create a FT Index on the database, but it has now run in more than 24 hours and are still not finished. Index size is at the moment 63 MB and when pressing "Count unindexed documents", the message is "The full text index needs to be rebuilt". Since we created the FT index the CPU load on the server har been nearly 100% all the time.

Domino server version is 12.0.2 on Windows 2019

How to troubleshoot this issue? Any notes.ini parameters that can help us finding the cause of the problem?

2

My first guess would be a corrupt document/attachment but that is of course far fetched without knowing more about the FTI settings, errors in the log etc.

You will find a good overview of debug settings and troubleshooting tips in the document attached to this KB https://support.hcl-software.com/csm?id=kb_article&sysparm_article=KB0105209

3

Agree with Andreas. You can also try this:

  • make sure db is ODS 55
  • shut down Domino Server
  • make a backup of db (if you like ...)
  • delete xy.ft subdirectory where db resides
  • start an offline database fixup (on a not partitioned server start a command prompt, go to Domino prog directory and run 'nfixup -j subdir\dbname.nsf)
  • start an offline index rebuild (nupdall -r)

If this type of fixup doesn't cure the problem, create a new replica of db or eventually even a new copy of db to have it as clean as possible.

4

If you see "Full Text message: Start position error" in the log then following article should help:

https://support.hcl-software.com/csm?id=kb_article&sysparm_article=KB0032897

5

We had a similar problem and the following fixed it:

delete the FTI

run fixup on the DB

re-create the FTI