Re: Unable to do full text search

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Kane (jt-kane_at_comcast.net)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 11:27:29 -0700

Richard,
Which of the below servers (MSSQL$SHAREPOINT or MSSQLSERVER or both) are you
having problems with SQL FTS?
If you're having problems with the default (MSSQLSERVER) SQL Server that is
running under DOMAIN\Administrator account, you might want to create a
DOMAIN\<non-Admin-account> and then change this server to that account via
the Enterprise Manager's server security tab as I've seen problems with SQL
FTS when SQL Sever is running under the DOMAIN\Administrator account.

In regards to "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'.", could you provide info on the
table (sp_help) and specifically the "file extension" datatype?

In regards to "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.", could you confirm
that the file schema.txt located at \FTDATA\SQLServer\Config\ is not
"corrupted", missing &/or altered from the version that is on the SQL Server
CD? If so, replace it with the version that is on the SQL Server CD.

Regards,
John

"Richard Brown" <anonymous@discussions.microsoft.com> wrote in message
news:16e3d01c41cee$e0c24a00$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. Will also post
> this on WSS newsgroup. \SHAREPOINT instance 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.

Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Error during pre-login handshake: SSL certificates and IIS?!
    ... After rebooting the server, people were telling me that SQL wasn't working anymore. ... If I'd be installing a new certificate, manually, I think I would break up again the SQL... ... Scott wrote: ...
    (microsoft.public.sqlserver.server)