| Author |
Execution of a full-text operation failed. Only Ignored Words
|
|
|
| Hello.
I'm using SQL Server 2000 SP4 on a Windows 2003 machine.
I've cleared the noise.enu (and noise.eng) files of all noise words,
restarted the MSSearch service and rebuilt/repopulated all catalogs but still
seem to get a problem when running certain searches:
"Execution of a full-text operation failed. A clause of the query contained
only ignored words."
The problem seems to occur only when single letter searches are within quotes.
For example, r&d without quotes works fine. "r&d" in quotes generates the
error.
The same with just r d vs "r d".
Other typical noise words in quotes work fine (e.g. "it"). It looks like
just single letters are the problem.
We're using the CONTAINS clause.
Any ideas? Are single noise letters hard-coded somewhere else?
Thank you!
| |
| Hilary Cotter 2005-11-08, 4:10 pm |
| Did you replace the contents of the noise word lists with single spaces? If
not it seems to use the indexing services noise word lists.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"EricM" <EricM@discussions.microsoft.com> wrote in message
news:8BF81B10-E0F3-429A-8C04- ADBC53A2DD94@microso
ft.com...
> Hello.
>
> I'm using SQL Server 2000 SP4 on a Windows 2003 machine.
>
> I've cleared the noise.enu (and noise.eng) files of all noise words,
> restarted the MSSearch service and rebuilt/repopulated all catalogs but
still
> seem to get a problem when running certain searches:
> "Execution of a full-text operation failed. A clause of the query
contained
> only ignored words."
>
> The problem seems to occur only when single letter searches are within
quotes.
> For example, r&d without quotes works fine. "r&d" in quotes generates the
> error.
> The same with just r d vs "r d".
> Other typical noise words in quotes work fine (e.g. "it"). It looks like
> just single letters are the problem.
>
> We're using the CONTAINS clause.
>
> Any ideas? Are single noise letters hard-coded somewhere else?
>
> Thank you!
| |
|
| Hi Hillary,
Thank you so much for the reply.
I'm in the process of testing this but it seems like adding a single space
to the empty noise file may have worked!
I'll let you know if anything else comes up and can't understand why this
works but your help is definitely appreciated!
"Hilary Cotter" wrote:
> Did you replace the contents of the noise word lists with single spaces? If
> not it seems to use the indexing services noise word lists.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "EricM" <EricM@discussions.microsoft.com> wrote in message
> news:8BF81B10-E0F3-429A-8C04- ADBC53A2DD94@microso
ft.com...
> still
> contained
> quotes.
>
>
>
|
|
|
|