Domino 9 und frühere Versionen > Entwicklung

Fehler bei FTSearch

<< < (3/6) > >>

Glombi:
In der KBASE gibt es einiges:

Error: "Query Is Not Understandable"

Problem:

You enter a legitimate query in a Notes database, but the following error occurs:

   "Query is not understandable"

Solution:

This error can occur for the following reasons:

1.   If the error occurs with a particular general query, there may be too many matches of the query in relation to the number of the documents in the view.  

   For example, you have a database with 7000 documents and enter a query such as T*.  The error will occur because there are too many potential responses in which a word begins with the letter T.   The query engine cannot handle a query which results in more than 5000 matches in 800 documents.

   To workaround this limit, refine the query using one of the following suggestions:

a.   Specify a string which is less common (than *T for example) but will still retrieve the documents you are looking for.  For example  "Translate."
b.   Reword the query.  Use fewer wild cards.
c.   Perform a field-based search, using query by form.

   This limit is different from the with QueryMaxResults limit of 5000 documents (which signifies the maximum number of documents that the query engine will return).


2.   If the error occurs with every query in a database, the Full Text .DLL files on the workstation may be damaged.

   You can either reinstall the Notes client or manually replace individual .DLL files (such as the TPAPIWIN.DLL file on a Windows client) using the files from another workstation running the same version of Notes

Glombi:
Error: "Query Is Not Understandable" if an AND is Added to an OR Statement Within Parentheses

Problem:

It has been found that submitting the following query on an R5 full-text-indexed database results in the error "Query is not understandable":

(Field Subject contains "First Doc" or Field Color contains "Purple") and Field Quantity = 2

Removing the parentheses from the query string eliminates the error, but it also changes the meaning of the query, as shown below:

Field Subject contains "First Doc" or Field Color contains "Purple" and Field Quantity = 2

Note that the following query works without error:

(Field Subject contains "First Doc" or Field Color contains "Purple") and Field Shape = "Round"

Solution:

This issue was reported to Lotus Quality Engineering and has been addressed in Domino 5.0.1a.

Excerpt from the Lotus Notes and Lotus Domino Release 5.0.1a QMU fix list:

SPR# BHIR48RVXQ - Fix problems with full-text queries containing numeric or date terms when they're not the first or only term in the query, which causes either errors or incomplete search results to be returned. [5.0.1a]

The issue is related to the two different data types; specifically, text within the parentheses and numbers outside the
parentheses.  In the third query in the Problem section above, all the query field values are text.  Whereas, in the first query, the field values in the parentheses are text, and the field value outside the parentheses is numeric.

Workaround:

The following syntax is equivalent to the first query above and can be used as a workaround:

(Field Subject contains "First Doc" or Field Color contains "Purple") and (Field Quantity = 2)

Glombi:
Es kann auch mit der UNK Tabelle zusammenhängen. Wenn bspw. in der Datenbank das Feld "Abschlussdat" kein Datum sondern ein Textfeld ist, könnte die Meldung kommen. Unter R5 lautet die Fehlermeldung zwar anders, aber in R4 kann ich es nicht testen.

Andreas

koehlerbv:
Hm, ich habe den QueryString mal spassenshalber in meinem Mailfile eingegeben. "Relationale Operatoren werden in Textfeldern nicht unterstützt". Die Fehlermeldung mag in R4 anders ausgesehen haben.
Kann es sein, dass AbschlussDat nicht in allen Dokumenten der DB ein Datumsfeld ist ?

Bernhard

Bille:
Das Problem mit den 5.000 Dokumenten kann ich ausschließen. Soviel Dokumente sind's nicht.

Das Feld Abschlussdat ist ein Datumsfeld. Das kann's also auch nicht sein.

Mit der Suchleiste komm ich irgendwie nicht ganz klar.
Wie muss ich die Suchanfrage einstellen?
Genauso, wie's im Script angegeben wird?
z.B.
FIELD ASName = Mayr Thomas
oder mit Anführungszeichen?
"FIELD ASName = Mayr Thomas"
FIELD ASName = "Mayr Thomas"

Es kommt immer der gleiche Fehler
"Abfrage nicht verständlich".

Die angegebenen DLL-Dateien konnte ich nicht finden. Ich muss dazu sagen, ich arbeite an einer OS/2-Kiste mit Notes 4.5.7

Kann es irgendwas mit dem Volltext-Index zu tun haben?

Navigation

[0] Themen-Index

[#] Nächste Seite

[*] Vorherige Sete