Neutral Noise file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Guy Brom - 29 Jul 2004 12:44 GMT

Hi there,

To ignore noise words errors (i.- Server: Msg 7619, Level 16, State 1, Line
1
Execution of a full-text operation failed. A clause of the query contained
only ignored words. )

I've searched and emptied the content (not deleted) from all occurences of
the noise.dat file.

I restarted mssearch before and after deleting, but still - I get this error
when trying to search for "dream AND 2".

Anything I'm missing here?

Thanks!

Guy

Reply to this Message

Hilary Cotter - 29 Jul 2004 13:39 GMT

issue a sp_help_fulltext_columns in the database which you are full text
indexing.

this will tell you which columns you are indexing, and the word breakers you
are using in the FULLTEXT_LANGUAGE

to correlate this with your noise word list issue a master.dbo.xp_MSfulltext
and note the language which LCID's value matches the value for your columns
returned in the sp_help_fulltext_columns query.

noise.dat is for the neutral word breaker with a LCID of 0.
noise.enu is for US English with an LCID of 1033
noise.eng is for British English with an LCID of 2057

Does this match the noise word list you are using?

Did you modify the list in C:\Program Files\Microsoft SQL
Server\MSSQL\FTDATA\SQLServer\config?

Lastly did you wrap your search phrase in double quotes?

ie

select * from tablename where contains(*,'"dream and 2"')

thats a single quote, a double quote, dream and 2, double quote, single
quote.

Signature

Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html

> Hi there,
>
[quoted text clipped - 14 lines]
>
> Guy

Reply to this Message

Guy Brom - 29 Jul 2004 20:41 GMT

Hilary hi,

All FULLTEXT_LANGUAGE rows are 0. I modified all occurences of noise.dat,
and yes, I'm wrapping everything in double quotes, i.e-

select * from tablename where contains(*,'"dream and 2"')

Is that wrong?

Thanks.

> issue a sp_help_fulltext_columns in the database which you are full text
> indexing.
[quoted text clipped - 44 lines]
> >
> > Guy

Reply to this Message

Hilary Cotter - 30 Jul 2004 01:29 GMT

what is in your noise.dat file? if it is 0 bytes, open it up and put a
single blank space in it and then save it.

> Hilary hi,
>
[quoted text clipped - 60 lines]
> > >
> > > Guy

Reply to this Message

Guy Brom - 30 Jul 2004 09:41 GMT

It was indeed 0 bytes. I've added the single blank space and it worked.
Thank you! Thank you!

> what is in your noise.dat file? if it is 0 bytes, open it up and put a
> single blank space in it and then save it.
[quoted text clipped - 64 lines]
> > > >
> > > > Guy

Reply to this Message