Hi! We need to perform Full-text index search FTSearch on database to get documents containing given username in any fields.
The system here is a distributed one which the branch server replicates the design and document from the HQ.
However in few branches, we notice one of the agent has error when performing NotesDatabase.FTSearch. The similar agent runs on other branches (servers) without problem.
below is taken from the log
08/07/2004 06:32:05 AM Full Text message: Quotation usage error.
08/07/2004 06:32:05 AM GTR search error for “d:\Lotus\Domino\Data\eoffice\wbClaim.ft\ftgi”: Quotation usage error.: Query is not understandable
08/07/2004 06:32:06 AM AMgr: Agent (‘User Update’ in ‘eCompany\WBDIRECTORY.NSF’) message box: WBDIRECTORY.NSF agent UpdateWorkflowModule error <Notes error: Query is not understandable (“”)> found at line 36
08/07/2004 06:32:06 AM AMgr: Agent (‘User Update’ in ‘eCompany\WBDIRECTORY.NSF’) message box: WBDIRECTORY.NSF agent error found at line 61
Here’s the portion of code that prepares the search string, based on user’s NotesName:
If oldNotesName.OrgUnit2 <> "" Then
strSearch = {"} & oldNotesName.Common & {" & "} & oldNotesName.OrgUnit1 & {" & "} & oldNotesName.OrgUnit2 & {"}
Elseif oldNotesName.OrgUnit1 <> "" Then
strSearch = {"} & oldNotesName.Common & {" & "} & oldNotesName.OrgUnit1 & {"}
Else
strSearch = {"} & oldNotesName.Common & {"}
End If
Set moduleDC = moduleDB.FTSearch(strSearch, 0)
Anyone has similar experience when using FTSearch?