sql server full text search: One or more documents stored in image columns with extension 'doc' -- sql server full text search

One or more documents stored in image columns with extension 'doc'

Victor
3/30/2006 6:29:02 AM

sql server full text search: I keep receiving these on SQL server (2000, SP3a) that my SharePoint is using:

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.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

for: pdf, doc, xls, sql, jpg, vsd, ppt, zip...

Does this mean that those files are not being index correctly or at all?

I have Adobe Ifilter 6 installed on both Portal and SQL server.

There is an article on KB
http://support.microsoft.com/kb/308841/en-us
that offeres to download latest service pack for SQL (2.0), I am running (3a)

Re: One or more documents stored in image columns with extension 'doc'

Hilary Cotter
3/30/2006 10:59:23 AM

examine the contents of your document type column. Is it varchar(3) or
varchar(4). If not there could be a problem with it trying to load "doc " as
opposed to "doc" note the trailing space.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

[quoted text, click to view]