Query Not Understandable

HCL Domino Domino Forum
1

Query Not Understandable. It is a date field.

I am getting this error in 1 database. If I make a copy of it on the same server and run the query, it works. However if I make a replica of it on the same server it does not work.

I have tried removing the field out of the database and compacting. I have tried ‘copy style compact’. I have removed all forms out of the database and ran compact again. Replicas of this database on other servers seem to work.

The notes.ini file on this server and the servers that work are the same.

Any help would be greatly appreciated.

2

Subject: Query Not Understandable

sounds like one is full text indexed and the other is not… not sure.

When running a search, try using double quotes. You might be using a search keyword, such as the equals sign.

3

Subject: RE: Query Not Understandable

Thanks for the info. Both are FT indexed and have tried with and without double quotes.

4

Subject: Query Not Understandable

Fix from IBM:

  1. load fixup -F database.nsf

  2. load compact -c database.nsf

  3. load updall -R database.nsf

  4. If there is no improvement in the situation, create a replica (either local or to your test server), delete the affected database on the production server, and replicate the database back to the server.

5

Subject: Query Not Understandable

The information you supplied is not enough to detect the problem. What are the attributes of the field? Has it any formulae or LS code?

6

Subject: RE: Query Not Understandable

No formula no LS