Re: Unable to do full text search

From: Mike Walsh [MVP] (englantilainen_at_hotmail.com)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 07:30:08 +0300

I would suggest that rather than posting to the WSS newsgroup or the SQL
Server newsgroup, you should have posted this to the SBS newsgroup as you
are still seem to be in what could loosely be described as the installation
period of that product's implementation of WSS.

microsoft.public.windows.server.sbs

This newsgroup only covers *standalone WSS* installation/configuration
problems and other WSS problems *common to all implementations*. Your's
seems to not fall within these limits.

Mike Walsh, Helsinki, Finland
WSS FAQ at wss.collutions.com
Please post questions to the newsgroup only.

"Richard Brown" <anonymous@discussions.microsoft.com> wrote in message
news:19b8b01c41cef$1f3d0270$a301280a@phx.gbl...
> Running on SBS 2003 Server Premium:
>
> I've looked at everything I can find here and elsewhere,
> and still can't figure out what is wrong. Will also post
> on SQL Server newsgroup. \SHAREPOINT was upgraded from
> WMSDE to SQL Server 2000 instance, and Search is selected
> in WSS:
>
> local SQL instance (Enterprise Mgr) is 8.00.760 (SP3)
> \SHAREPOINT instance (Enterprise Mgr) is 8.00.880 (SP3)
>
> Microsoft Search service-Local System logon (never changed)
> MSSQL$SHAREPOINT service-Local System logon (never changed)
> MSSQLSERVER services -DOMAIN\Administrator logon (never
> changed)
>
> ----When I search from Share Point Services:
> Event viewer on server gets Event 17052:
> Error: 15457, Severity: 0, State: 1
> Configuration option 'show advanced options' changed from
> 1 to 1. Run the RECONFIGURE statement to install.
>
> -----When I try to rebuild FT index from Enterprise mgr:
> Event Viewer on server:
>
> Event 2001 (rebuilding):
> One or more documents stored in image columns with
> extension '' 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.
>
> Event 3018 (when finished):
> The end of crawl for project <SQLServer$SHAREPOINT
> SQL0000600005> has been detected. The Gatherer
> successfully processed 15 documents totaling 0K. It failed
> to filter 0 documents. 0 URLs could not be reached or were
> denied access.
>
> Event 7045 (when finished):
> The catalog was not propagated, because no new files were
> detected for the project <SQLServer$SHAREPOINT
> SQL0000600005>.
>
> Event 4103:
> Master merge has completed on c:\program files\microsoft
> sql server\mssql$sharepoint\ftdata\sql0000600005
> \build\indexer\cifiles.
>
> ------------------------
> If I try simple search from SQL Query Analyzer on
> sharepoint database 'Docs' table:
>
> select Id
> from Docs
> where CONTAINS(Content,'wordIknowisindocument')
>
> I get:
> Server: Msg 7342, Level 16, State 1, Line 1
> Unexpected NULL value returned for
> column '[FULLTEXT:Docs].KEY' from the OLE DB
> provider 'Full-text Search Engine'. This column cannot be
> NULL.
> OLE DB error trace [Non-interface error: Unexpected NULL
> value returned for the column: ProviderName='Full-text
> Search Engine', TableName='[FULLTEXT:Docs]',
> ColumnName='KEY'].
>
> Thanks for any advice.

Loading