Re: Execution of a full-text operation failed. A clause of the query contained only ignored words.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Kane (jt-kane_at_comcast.net)
Date: 09/08/04 

Date: Tue, 7 Sep 2004 19:19:20 -0700

Hilary,
Paul's search string from his initial posting including a long string of
asterisks...:

SELECT @match_string = '"Steve" AND "Jackson" AND "34620" AND
"******************************"'

The above can be converted to a contains clause using the pubs table
pub_info:

select pub_id, pr_info from pub_info where contains(*,'"Steve" AND
"Jackson" AND "34620" AND "******************************"')
/* -- returns:
Server: Msg 7619, Level 16, State 1, Line 3
Execution of a full-text operation failed. A clause of the query contained
only ignored words.
*/

-- Alternative without the string of asterisks...
select pub_id, pr_info from pub_info where contains(*,'"Steve" AND
"Jackson" AND "34620"')
/* returns as expected and with no Msg 7619:
pub_id pr_info
------ ------------------------------------------------------------

(0
 row(s) affected)
*/

In affect, this is less about searching on noise words in the noise word
files (noise.*) and more about editing or parsing the user's input and
elimating noise words &/or a long string of asterisks...

Regards,
John

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:OUBTDPUlEHA.1244@TK2MSFTNGP15.phx.gbl...
> I'm a little confused. Why would someone want to parse a search string to
> remove words that he/she is trying to search on?
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> "John Kane" <jt-kane@comcast.net> wrote in message
> news:%23NM13pRlEHA.3544@TK2MSFTNGP15.phx.gbl...
> > Paul,
> > In addition to the advise Hilary has provided below, i.e.., removing all
> > noise words, you can also try the following programmatic methods (one
> > provide by Hilary) for trapping the error instead of causing your
program
> to
> > crash.
> >
> > 1) Review KB article 246800 (Q246800) "INF: Correctly Parsing Quotation
> > Marks in FTS Queries" at
> > http://support.microsoft.com//default.aspx?scid=kb;EN-US;246800
> >
> > 2) Review the code provide in the attached zip file (SearchPage.zip)
that
> > contains SearchPage.htm for client-side editing or parsing out the noise
> > words in the user input.
> >
> > Depending upon the size of your FT Catalog, removing all noise words,
can
> > cause the FT Catalog to grow significantly and if you have a very large
FT
> > Catalog, can affect your FTS query performance.
> >
> > Regards,
> > John
> > PS: If you cannot access the zipped file, I can paste the code into
> another
> > posting, if need be...
> >
> >
> >
> >
> > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> > news:ugrTCXRlEHA.2340@TK2MSFTNGP11.phx.gbl...
> > > Remove all numbers from your noise word list for the language you are
> > using
> > > for your word breaker.
> > >
> > > Make sure you use the noise word lists which can be found in
> > >
> > > C:\Program Files\Microsoft SQL Server\MSSQL\FTdata\SQLServer\Config
> > >
> > > For us english you would edit noise.enu, for uk english noise.eng.
> > >
> > > If you are using the neutral word breaker use noise.dat
> > >
> > > If by change your noise word list is 0 bytes, open it and save it
again
> > with
> > > a single blank space in the file.
> > >
> > > You will have to stop mssearch to make these changes and then restart
it
> > > after you have completed your changes. You will have to rebuild your
> > > catalogs.
> > >
> > > --
> > > Hilary Cotter
> > > Looking for a SQL Server replication book?
> > > http://www.nwsu.com/0974973602.html
> > >
> > >
> > > "Paul" <xx@nospam.com> wrote in message
> > > news:%23n%23laMRlEHA.2224@tk2msftngp13.phx.gbl...
> > > > Hi
> > > >
> > > > I'm getting the message below when trying to query my fulltext index
> > (see
> > > > example code).
> > > > I've researched on google and tried everything I could find, I
cleared
> > the
> > > > noise word files, restarted the full-text service and rebuilt my
> indexes
> > > and
> > > > I still get the message.
> > > > I tried freetext instead of contains but that seems to find matches
> > which
> > > > are not really matches.
> > > >
> > > > Any suggestions? Is there at least a way to trap the error instead
of
> > my
> > > > program crashing?
> > > > Thanks
> > > >
> > > >
> > > >
> > > > Server: Msg 7619, Level 16, State 1, Line 5
> > > > Execution of a full-text operation failed. A clause of the query
> > contained
> > > > only ignored words.
> > > >
> > > > DECLARE @match_string char(40)
> > > >
> > > > SELECT @match_string = '"Steve" AND "Jackson" AND "34620" AND
> > > > "******************************"'
> > > > SELECT 1 FROM resume WHERE contains(thefile, @match_string)
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
>
>

Relevant Pages

  • Re: two interesting data structure/algorithm questions
    ... for an arbitrary string and return the page numbers where this string ... In other words, for now, forget about the search string being able ... and so on in the inverted index instead of just the word "this". ...
    (comp.programming)
  • Re: Execution of a full-text operation failed. A clause of the query contained only ignored words.
    ... searching on asterisks will generate this error. ... > Paul's search string from his initial posting including a long string of ... this is less about searching on noise words in the noise word ... > "Hilary Cotter" wrote in message ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Excel 2003 Macro to add text to front of data in cell
    ... search string that you enter is not the full content of a cell, ... A step would have to be designed to test each cell for the ... this macro would pass it. ...
    (microsoft.public.excel.programming)
  • Re: Search only values, then replace
    ... subordinate to the Formulas checkbox, though, so I didn't touch that. ... and enter your search string and replace string and ... whose *value* contains the search string, ... inside the cell with a replacement string if the cell doesn't contain ...
    (microsoft.public.excel)
  • Re: Tokenizing a large buffer
    ... how long can a Regex match string be? ... So rather than looping with multiple searches using Regex, just loop on the tokens in creating the search string. ...
    (microsoft.public.dotnet.languages.csharp)