Full text search message "Query is not understandable"

by Bernd,
assono GmbH, Standort Hamburg,

We all love Lotus Notes for its RAD flexibility. But sometimes Notes has a memory like an elephant. wink.gif

A customer had recently a problem with the full text search. Early in the project a field in one of the Notes forms had been defined as a number field. Later they changed the field type to text. No big deal until a user tried to make a full text search specially for this field. The following message came as quite a surprise.

Query is not understandable

The search string FIELD fieldname= "Value" was correct.

It took a little while before we found out the right measures and the correct order to fix this problem.

I had read in the forum that the indexer determines the type of each field on the basis of the first found document while creating a new full text index. So we corrected all the documents with the wrong data type. Then we deleted the full text index and rebuilded it. The error was still the same. sad.gif

After further research we have come to the conclusion that the UNK table might be the problem. UNK stands for "UNique Key Table" and refers to an internal table that in every Notes database / application holds up a list of all fields of the database. Compacting the database using a copy (option "-c") normally recreates that table. As we had to figure out the UNK table is not rebuilt, if a full text index exists. sad.gif

The following order has finally led to success.
1. Delete the full text index
2. On the console Load compact database path -c
3. Create the full text index again

After that the query worked as expected. smile.gif

The described procedure had to be repeated for each replica.

Technical article IBM Notes IBM Notes Traveler

You have questions about this article? Contact us: blog@assono.de

Sie wollen eine individuelle Beratung oder einen Workshop? Read more

More interesting entries

Any questions? Contact us.

If you want to know more about our offers, you can contact us at any time. There are several ways to contact us for a non-binding first consultation.

assono GmbH

Location Kiel (headquarters)
assono GmbH
Lise-Meitner-Straße 1–7
24223 Schwentinental

Location Hamburg
assono GmbH
Bornkampsweg 58
22761 Hamburg

Phone numbers:
Human resources department: +49 4307 900 407
Marketing department: +49 4307 900 411

E-Mail adresses: