2012年3月19日星期一

full text issue

I have issue in production full text search where using contains cluase with
long name of client and companies e.g. Robert M Junior Estate if my
contains clause has Robert and M and Junior - it does not return any rows
but if it is Robert and Junior it will return the rows. I have similar test
environment with same version of SQl2000 sp4 and it works when I provide all
3 criterias. I have tried to reproduce on test but unable to produce it.
Tried to dropped the catalogue and rebuilded twice on production,
repopulated. Matching noise files on test and production also.
Any idea ?
Please helpManoj.
M is a noise word and one behavior of full-text search is that a noise word
cause no results to return. So, I suspect that there is actually a
difference in the noise word files. Please double-check its contents.
Also make sure that the production and test indexes are defined to use the
same language. (I have some British English columns with no noise words and
some English columns with noise words.)
Note: A noise word file with no noise words needs at least a space in it.
(Or an impossible word, such as supercalifragalisticexpialidocious.)
RLF
"Manoj" <Manoj@.discussions.microsoft.com> wrote in message
news:E612A941-B35C-4918-A8C8-CBF77E40BEA2@.microsoft.com...
>I have issue in production full text search where using contains cluase
>with
> long name of client and companies e.g. Robert M Junior Estate if my
> contains clause has Robert and M and Junior - it does not return any
> rows
> but if it is Robert and Junior it will return the rows. I have similar
> test
> environment with same version of SQl2000 sp4 and it works when I provide
> all
> 3 criterias. I have tried to reproduce on test but unable to produce it.
> Tried to dropped the catalogue and rebuilded twice on production,
> repopulated. Matching noise files on test and production also.
> Any idea ?
> Please help|||I have tried replacing noise word files from production to test and
rebuilded catalogue and still works in test but not in production
"Russell Fields" wrote:
> Manoj.
> M is a noise word and one behavior of full-text search is that a noise word
> cause no results to return. So, I suspect that there is actually a
> difference in the noise word files. Please double-check its contents.
> Also make sure that the production and test indexes are defined to use the
> same language. (I have some British English columns with no noise words and
> some English columns with noise words.)
> Note: A noise word file with no noise words needs at least a space in it.
> (Or an impossible word, such as supercalifragalisticexpialidocious.)
> RLF
> "Manoj" <Manoj@.discussions.microsoft.com> wrote in message
> news:E612A941-B35C-4918-A8C8-CBF77E40BEA2@.microsoft.com...
> >I have issue in production full text search where using contains cluase
> >with
> > long name of client and companies e.g. Robert M Junior Estate if my
> > contains clause has Robert and M and Junior - it does not return any
> > rows
> > but if it is Robert and Junior it will return the rows. I have similar
> > test
> > environment with same version of SQl2000 sp4 and it works when I provide
> > all
> > 3 criterias. I have tried to reproduce on test but unable to produce it.
> > Tried to dropped the catalogue and rebuilded twice on production,
> > repopulated. Matching noise files on test and production also.
> >
> > Any idea ?
> >
> > Please help
>
>|||Manoj,
Did you double-check the language definition of your full-text indexes?
RLF
"Manoj" <Manoj@.discussions.microsoft.com> wrote in message
news:61D160A2-8CA6-483A-8999-2AF0E789C447@.microsoft.com...
>I have tried replacing noise word files from production to test and
> rebuilded catalogue and still works in test but not in production
> "Russell Fields" wrote:
>> Manoj.
>> M is a noise word and one behavior of full-text search is that a noise
>> word
>> cause no results to return. So, I suspect that there is actually a
>> difference in the noise word files. Please double-check its contents.
>> Also make sure that the production and test indexes are defined to use
>> the
>> same language. (I have some British English columns with no noise words
>> and
>> some English columns with noise words.)
>> Note: A noise word file with no noise words needs at least a space in it.
>> (Or an impossible word, such as supercalifragalisticexpialidocious.)
>> RLF
>> "Manoj" <Manoj@.discussions.microsoft.com> wrote in message
>> news:E612A941-B35C-4918-A8C8-CBF77E40BEA2@.microsoft.com...
>> >I have issue in production full text search where using contains cluase
>> >with
>> > long name of client and companies e.g. Robert M Junior Estate if my
>> > contains clause has Robert and M and Junior - it does not return any
>> > rows
>> > but if it is Robert and Junior it will return the rows. I have similar
>> > test
>> > environment with same version of SQl2000 sp4 and it works when I
>> > provide
>> > all
>> > 3 criterias. I have tried to reproduce on test but unable to produce
>> > it.
>> > Tried to dropped the catalogue and rebuilded twice on production,
>> > repopulated. Matching noise files on test and production also.
>> >
>> > Any idea ?
>> >
>> > Please help
>>

没有评论:

发表评论