Full Text Index Issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aarti. - 20 Jun 2005 16:36 GMT

Hey all,

I'm using full text indexing for keyword search capabilities for one of our
clients'. We needed to provide boolean search capability and hence I chose
containstable instead of freetext.

The stored proc works fine except that for specific keywords the client
expects certain documents to show which do not. This is really random and we
have not been able to find out why these documents don't show inspite of the
keyword being the the document name and summary. We also made sure the
document exists in the indexed table.

We did not want to re-populate the catalog because when we did it in the
past the client was able to find 5 documents and 10 others were not showing
up.

We even tried defragmenting the drive SQL server sits on, which did not
help. Has anyone experienced this before?

Any help will be greatly appreciated.

-Aarti.

Reply to this Message

Hilary Cotter - 21 Jun 2005 03:39 GMT

a defrag won't help. Are there any messages in the event log from MSSCI or
MSSearch?

Signature

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

> Hey all,
>
[quoted text clipped - 18 lines]
>
> -Aarti.

Reply to this Message

Aarti. - 21 Jun 2005 14:28 GMT

Thanks for your response.

I deleted and recreated the FT catalog. Here's the list of messages in the
event log:

MS Search Gatherer : The end of crawl for project <SQLServer SQL0000600005>
has been detected. The Gatherer successfully processed 10373 documents
totaling 0K. It failed to filter 2936 documents. 0 URLs could not be reached
or were denied access.

SQLFTHNDLR: One or more documents stored in image columns with extension
'doc' did not get full-text indexed because loading the filter failed with
error '0x1'.

Note: These documents will not be passed to MSSearch for indexing, and
therefore this failure will not be reflected in the end of crawl summary
statistics.

SQLFTHNDLR: One or more documents stored in image columns with extension
'vb' did not get full-text indexed because loading the filter failed with
error '0x1'.

Note: These documents will not be passed to MSSearch for indexing, and
therefore this failure will not be reflected in the end of crawl summary
statistics.

SQLFTHNDLR: One or more documents stored in image columns with extension
'wpd' did not get full-text indexed because loading the filter failed with
error '0x1'.

Note: These documents will not be passed to MSSearch for indexing, and
therefore this failure will not be reflected in the end of crawl summary
statistics.

MS Search Gatherer : One or more warnings or errors for Gatherer project
<SQLServer SQL0000600005> were logged to file <d:\Microsoft SQL
Server\MSSQL\FTData\SQLServer\GatherLogs\SQL0000600005.1.gthr>. If you are
interested in these messages, please, look at the file using the gatherer log
query object (gthrlog.vbs, log viewer web page).

Please let me know if you need any more information.

Thanks in advance.

> a defrag won't help. Are there any messages in the event log from MSSCI or
> MSSearch?
[quoted text clipped - 25 lines]
> >
> > -Aarti.

Reply to this Message