FTSearch Error in Field Type

HCL Domino Domino Forum
1

hiwe have a customized search-form with a lotusscript-action performing a NotesDatabase.FTSearch(…).

Since a week we get an Error: “…Query is not understandable…”

SearchSyntax is:

((FIELD XNumber Contains 1234) And (“test”))

Problem is the datatype of the field XNumber !

When I manually build the searchsyntax using the advanced search options the XNumber-field dialog only offers “is equal” or “is less than”…, but the datatype is Text!!!

XNumber is used in many forms, views,… as Text, only years ago we had one or two forms with XNumer with Number Datatype.

We have more than 4 replicas of the database on different servers (same design) but the problem occurs only on 2 databases. I did a compact -c because there was some hint to rebuild the UNK Table and an Updall -x to rebuild the FT-Index, but no result:(

This came with Notes 8.

Please help

Heinrich Mueller

2

Subject: Leftover documents

It seems that you have one or more old documents that have XNumber as a number item. When the full-text index is constructed, it decides the field type based on the type in the first document it comes across. This may not be the same document in each replica, which accounts for your differing results.

You must write an agent to find all documents where this field is a number, and change it to text. This is easy to do with a macro agent.

And then you must delete the full-text index, compact -c and recreate the index.

3

Subject: Leftover documents

hi Andre

sorry for the late answer.

Thank you very much!!!

Indeed a customized agent had found and corrected some old documents.

Afterwards I deleted the ft index,

did a compact -c and

recreated the ft index.

That was the (only) solution!