Re: Full-text catalog is not building properly (completely)
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Fri, 27 Jan 2006 06:56:43 -0500
Could you contact me offline?
--
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
"Greg Smalter" <GregSmalter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4751A23C-77C7-4C55-AA20-CD79D827084B@xxxxxxxxxxxxxxxx
>I can zip the backup file to about 25MB and send it to you, if you tell me
> where. It should restore with the full-text catalog and everything so the
> problem should be evident. I could try to cut down the size if it's more
> convenient.
>
> Thanks.
>
> Greg
>
> "Hilary Cotter" wrote:
>
>> Item count is the number of tables you are full-text indexing and the
>> number
>> of rows you are full text indexing. So if there are 130747 rows in your
>> database, somehow 130747-104878 rows are missing - that's 25869
>> rows/books.
>>
>> Any way you can bcp the data out and send it to me?
>>
>> --
>> 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
>>
>> "Greg Smalter" <GregSmalter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:A607CA49-EDD2-482A-84C5-47531B6429FF@xxxxxxxxxxxxxxxx
>> > Okay, well, this is really bad. It thinks it has repopulated the
>> > catalog
>> > but
>> > it clearly hasn't, or I wouldn't have to go in and modify a row in
>> > order
>> > for
>> > it to ever be returned.
>> >
>> > The catalog automatically repopulates after I do a rebuild operation.
>> >
>> > Additional information:
>> >
>> > In the properties window for the catalog, the "Repopulate catalog"
>> > Catalog
>> > Option is greyed out. I have db_datareader as the owner of the
>> > catalog.
>> >
>> > The item count is 104879. There are 130747 books in the database (some
>> > are
>> > duplicates with respect to the full text keys). The unique key count
>> > is
>> > 56505.
>> >
>> > It seems like the item count should be the same as the book count. I
>> > understand why the unique key count is lower.
>> >
>> > This is a deal breaker for this system and for full-text in general for
>> > my
>> > entire company. I need to ensure that everything gets put in the
>> > catalog
>> > initially.
>> >
>> > Greg
>> >
>> > "Hilary Cotter" wrote:
>> >
>> >> No the catalog should be automatically populated as soon as you create
>> >> it.
>> >> You are looking at the correct log file I think. Sounds like it thinks
>> >> the
>> >> population happened successfully!
>> >>
>> >> --
>> >> 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
>> >>
>> >> "Greg Smalter" <GregSmalter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> >> message
>> >> news:5AE90F70-2733-41F7-9B6B-871B597C7914@xxxxxxxxxxxxxxxx
>> >> >I am using the default "Track changes:" option of "Automatic." This
>> >> >should
>> >> > prevent the catalog from becoming fully populated to start, though,
>> >> > should
>> >> > it?
>> >> >
>> >> > The platform is Windows Server 2003 Standard x64 Edition with SQL
>> >> > Server
>> >> > 2005 Standard x64.
>> >> >
>> >> > I looked in a file called SQLFT0000500005.LOG and saw no errors. Is
>> >> > there
>> >> > more gatherer log information I can get at?
>> >> >
>> >> > Thank you.
>> >> >
>> >> > Greg
>> >> >
>> >> > "Hilary Cotter" wrote:
>> >> >
>> >> >> I hate to say this to you, but this works for me.
>> >> >>
>> >> >> There could be a couple of factors involved - you could be using
>> >> >> change
>> >> >> tracking and the row might not be indexed yet. This is especially
>> >> >> the
>> >> >> case
>> >> >> if you are indexing binary content. I take it you have tried
>> >> >> repeatedly
>> >> >> and
>> >> >> can repro this. Also it could be that for some reason the row was
>> >> >> not
>> >> >> indexed - check the gatherer logs for any entry.
>> >> >>
>> >> >> Your noise word list should contain a single space. If it doesn't
>> >> >> it
>> >> >> will
>> >> >> using the Indexing Services noise word lists.
>> >> >>
>> >> >> One final question - what OS and version of SQL Server and sp?
>> >> >>
>> >> >> --
>> >> >> 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
>> >> >>
>> >> >> "Greg Smalter" <GregSmalter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> >> >> message
>> >> >> news:0DF7A09B-94DF-4AC9-B6DC-A45738635909@xxxxxxxxxxxxxxxx
>> >> >> >I have a full-text index on a Title column in a Books table and I
>> >> >> >have a
>> >> >> > CONTAINSTABLE query that seems to work well in most cases.
>> >> >> > Recently
>> >> >> > I
>> >> >> > discovered that the query was failing to return an expected
>> >> >> > result.
>> >> >> > When
>> >> >> > I
>> >> >> > search for titles containing the word "shining," I expect the
>> >> >> > following
>> >> >> > title
>> >> >> > to match:
>> >> >> >
>> >> >> > Stephen King 2 -- Three Volume Boxed Set: Christine; The Shining;
>> >> >> > Cujo
>> >> >> >
>> >> >> > But, coming off a fresh rebuild of the catalog (and then waiting
>> >> >> > until
>> >> >> > the
>> >> >> > status has gone from Populating to Idle), the above title does
>> >> >> > not
>> >> >> > match.
>> >> >> >
>> >> >> > The query (which I've simplified) looks similar to this:
>> >> >> >
>> >> >> > SELECT booksTable.Title FROM Books booksTable
>> >> >> > INNER JOIN CONTAINSTABLE( Books, Title, 'shining') titleRank ON
>> >> >> > booksTable.BookId = titleRank.[KEY]
>> >> >> >
>> >> >> > Note that the non-simplified version actually uses the rank
>> >> >> > information
>> >> >> > that
>> >> >> > CONTAINSTABLE provides.
>> >> >> >
>> >> >> > At first, I thought it was a probably with Noise Words or the
>> >> >> > semicolons
>> >> >> > and
>> >> >> > hyphens in that particular title. That's not the case, though.
>> >> >> > It
>> >> >> > turns
>> >> >> > out
>> >> >> > that if I modify anything about that book whatsoever (say,
>> >> >> > changing
>> >> >> > the
>> >> >> > word
>> >> >> > "Stephen" to "Steven", or even changing a non-Title column in the
>> >> >> > same
>> >> >> > book
>> >> >> > row), a subsequent query (the exact same query as above) WILL
>> >> >> > return
>> >> >> > the
>> >> >> > result.
>> >> >> >
>> >> >> > It looks like the full-text catalog is not completely populating
>> >> >> > itself,
>> >> >> > and
>> >> >> > this particular book is only getting added to the catalog when I
>> >> >> > update
>> >> >> > it
>> >> >> > in
>> >> >> > some way (any way at all). After that, it matches perfectly,
>> >> >> > just
>> >> >> > like
>> >> >> > I'd
>> >> >> > expect.
>> >> >> >
>> >> >> > My noise words file is completely empty (I tried adding ';' and
>> >> >> > '-'
>> >> >> > to
>> >> >> > it
>> >> >> > and rebuilding, to no effect).
>> >> >> >
>> >> >> > As I said, I've tried rebuilding the catalog completely and
>> >> >> > waiting
>> >> >> > for
>> >> >> > it
>> >> >> > to repopulate. I need a way to force everything to get indexed
>> >> >> > right
>> >> >> > off
>> >> >> > the
>> >> >> > bat without waiting for records to be updated before they'll show
>> >> >> > up
>> >> >> > in
>> >> >> > a
>> >> >> > search. How do I do this?
>> >> >> >
>> >> >> > Thank you.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>
.
- References:
- Re: Full-text catalog is not building properly (completely)
- From: Hilary Cotter
- Re: Full-text catalog is not building properly (completely)
- From: Greg Smalter
- Re: Full-text catalog is not building properly (completely)
- From: Hilary Cotter
- Re: Full-text catalog is not building properly (completely)
- From: Greg Smalter
- Re: Full-text catalog is not building properly (completely)
- From: Hilary Cotter
- Re: Full-text catalog is not building properly (completely)
- From: Greg Smalter
- Re: Full-text catalog is not building properly (completely)
- Prev by Date: Re: Advantages?
- Next by Date: Text field in a group by, how can I make it work?
- Previous by thread: Re: Full-text catalog is not building properly (completely)
- Next by thread: Urgent Info
- Index(es):
Relevant Pages
|
Loading
