Full Text Search Doesn't Find Documents in View

Posted on 2004-11-17
Last Modified: 2013-11-16
I have a view that lists all documents in my database. I also have indexing on the database set to "Immediate". When I add new documents, they show up in the view, but the full text search doesn't find them, even the next day. If I manually update the index, it also doesn't find them, but if I delete and then re-create the index, the search will then find them.

This database has been in production for several years, and it was working fine until about a week ago. We are on Domino version 5.

How can I fix this? Thank you! Mike N
Question by:MikeN1949
    LVL 31

    Expert Comment

    SOunds like you either have corruption inthe index, or a very slow server.

    Note that when you "manually" update the index, you are basically adding an index request to the server';s index queue, which doesn't always get processed immediately, and then when it does occur, the process to update the index can take some time.  A better way to check if you are having real index problems:

    Add a few documents to the database
    Go to the physical server console or open a live console session
    Enter console command LOAD UPDALL -F nameoffolder\nameofdatabase.nsf

    Watch for the messages Index update process started, Index update process shutdown.  Look for any errors that occur in between.  While it is running, if you issue the server command SHOW TASKS you shoudl see an entry like this somewhere in the middle:
    Indexer                 Full text indexing documents in nameoffolder\nameofdatabase.nsf

    After a successful index update process shutdown, you shoudl be able to search for the new document (you may have to hit F9 in the view to refresh the view so it shows the new document -- full text query results are a combination of finding the documents and matching the document list up against the view to display the result).

    Author Comment

    Thanks, qwaletee!

    In the meantime, someone else suggested that I
    a) delete the index
    b) run compact -B on the database
    c) recreate the index

    so I have tried that and am seeing if it works. I'll let you know, but it may take a day or two.
    LVL 31

    Accepted Solution


    Cmpact -B will probably not solve your problem. Compact -C might.  Neither usually solves full text index issues.  -B just eliminates white space where possible.  -C completely rebuilds the database structure -- sometimes solving pointer or other corruption problems.  However, if the problem was database corruption, you probably would see more issues aside from the "no updates to full text indexing" problem that you describe.

    Author Comment

    Okay, thank you. I'll be away from the office until next Monday, and so far I haven't heard whether it worked or not. As soon as I do, I'll let you know. If I'm still having problems, I'll try compact -C. Thanks!

    Author Comment

    Sorry to take so long to follow up on this, but I've been away for a week and before that we were trying different things. I think we finally found a solution:

    a) I deleted the index in the database
    b) I made a new copy of the database (when I did this, I noticed that one document didn't come across)
    c) I created a full text index over the new database and put that one into production, replacing the old one

    So far, that seems to be working. I assume the problem was some sort of corruption, but nothing else seemed to fix it.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
    IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now