When building a Full Text Search Catalog and Index, it is a Good Idea to check that the search works properly at the end of it, by using something along the following lines:
SELECT *
FROM tablename
WHERE Freetext (COLUMN, 'some text')
Now, I knew the create script worked, as I'd used it to create my Very First Full Text Catalog and Index only a week ago. I knew the select would work, because, again, I'd tested it. SQL 2008 SP1 was about to have a bit of a disagreement with me about what was, and what wasn't, going to work.
Not so.
SQL Server encountered error 0x80070005 while communicating with full-textfilter daemon host (FDHost) process. Make sure that the FDHost process isrunning. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.
and in the Logs:
SQL Server failed to communicate with filter daemon launch service (Windows error: Windows Error: hr = 0x80070005(failed to retrieve text for this error)). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.
Running sp_fulltext_service 'restart_all_fdhosts' did not improve matters: the command ran happily, but the error persisted. Restarting SQL didn't help either (heck, it's a DEV box, and not yet ready for the Developers).
Searching for 0x80070005 told me that the problem was to do with permissions: and the solution turned out to be setting the SQL Full Text Filter Daemon Launcher Service to run under the same account as the SQL Server Service.
The SELECT statement then deigned to execute: but did not return any results. Rebuilding the index did not help matters: however, dropping the FULLTEXT index, the index, and the Full Text catalog did work. T-SQL here for posterity for next time I have this problem.
DROP FULLTEXT CATALOG CatalogName
DROP FULLTEXT INDEX ON dbo.TableName
DROP INDEX IndexName ON dbo.TableName
Subscribe to:
Post Comments (Atom)
Thank you so much for this information. This corrected my issue but I had a little different information for anyone that is searching. I changed the service account on Launcher Service from 'local Service' to the same account as the SQL Server Service
ReplyDeleteError '0x80070005' occurred during full-text index population for table or indexed view '[EVDAUSCustomer].[dbo].[tblIntAnalysedItems_361]' (table or indexed view ID '850582239', database ID '18'), full-text key value '2954'. Attempt will be made to reindex it.
Event 30089
The fulltext filter daemon host (FDHost) process has stopped abnormally. This can occur if an incorrectly configured or malfunctioning linguistic component, such as a wordbreaker, stemmer or filter has caused an irrecoverable error during full-text indexing or query processing. The process will be restarted automatically.