Relational Operators Not Allowed in Text Fields

HCL Domino Domino Forum
1

I have replica copies of my application. I dont encounter in one replica of my application, but on other replicas I encounter this error

“Relational Operators Not Allowed in Text Fields” while running FTSearch.

According to documentation, the cause of error is

“In Domino R5, it has been found that a problem can occur with respect to full text indexing when a field type is changed within a database. Specifically, when a field type is changed and a full text search is performed on that field, using either a field-specified or formula-string search of this new type, the following error will occur:”

“Relational Operators Not Allowed in Text Fields” while running FTSearch.

I’ve tried creating new replica…replace the index and still it didn’t work.

Please help!

2

Subject: Relational Operators Not Allowed in Text Fields

I have come across this before (I think when I changed a number field to a text field) and as far as I remember, it was not a problem with the FT Index but with the documents themselves (some sort of flag had been set on the documents internally). Have you tried creating NEW documents and limiting the search to those only? You may need to do a refresh on all your existing documents.

3

Subject: RE: Relational Operators Not Allowed in Text Fields

all docs are newly created…still not working…

i dont encounter this error if I t create a NEW COPY of the database, only when creating replica this error occur.