Re: Unable to use SharePoint search

anonymous_at_discussions.microsoft.com
Date: 04/12/04 

Date: Mon, 12 Apr 2004 12:26:24 -0700

You were right about that. However, I had so many other
problems that I just uninstalled WSS and reinstalled using
existing SQL Server instance. All is fine now. Thanks.
>-----Original Message-----
>Richard,
>
>Couple of things to look at..
>
>1) As far as not being able to register the SharePoint
instance from another
>machine, check to see in Start/All Programs/Microsoft SQL
Server/Server
>Network Utility to see if TCP/IP and/or Named Pipes are
enabled.
>
>2) As far as the Search not working, based on the event
2001 I'm wondering
>if you have a doc/file saved in the database that the
extension column in
>the Docs table somehow didn't get updated or if the
filename doesn't have an
>extension?
>
>
>--
>
>Hope that helps,
>David Copeland
>Microsoft Small Business Server Support
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>Newsgroups:
>SBS v4.x : microsoft.public.backoffice.smallbiz
>SBS 2000: microsoft.public.backoffice.smallbiz2000
>SBS 2003: microsoft.public.windows.server.sbs
>
>
>"Richard Brown" <anonymous@discussions.microsoft.com>
wrote in message
>news:173b601c41d7f$fc0b2f20$a601280a@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. \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)
>>
>> I can't seem to register the \SHAREPOINT instance using
>> Enterprise manager from other workstations; only on the
>> server, which seems strange.
>>
>> 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.
>
>
>.
>