January 25, 2010 at 3:52 pm
Hi I posted this in General and didn't recieve any replies, thought I'd try re-posting here
http://www.sqlservercentral.com/Forums/Topic850923-391-1.aspx
Here's the general error I am receiving
A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: AUTO; database name is XX(id: XX); catalog name is XX (id: XX); table name XX (id: xx). Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION.
Additional information form the full-text crawl log displays
Error: 30059, Severity: 16, State: 1.
Several sites report the fix as the following
I have seen the issue occur when the SQL Full-text Filter Daemon Launcher service was running with the NT AUTHORITY\NETWORK SERVICE account. Switching the service to use the Local System account solved the issue. Then the Full Text Catalog would rebuild without any issue.
above quote from http://blog.hoegaerden.be/2009/03/04/full-text-search-fatal-error-30059/
I have found no explanation as to the relationship between the account running the full-text service and this error message. Furthermore I am running all services with Domain accounts and am still receiving the error.
Any help on additional items I can check would be much appreciated.
January 25, 2010 at 4:42 pm
Quick question is the database 2008 or upgrade? If upgrade I always advice drop all Full Text indexes and recreate new ones so all will be native to SQL Server 2008. The reason is Full Text in 2000 and below are run by the Microsoft Search services.
Kind regards,
Gift Peddie
January 25, 2010 at 5:04 pm
Thanks they are using the integrated full-text in sql 2008
January 25, 2010 at 5:13 pm
Jon.Morisi (1/25/2010)
Thanks they are using the integrated full-text in sql 2008
No I need for you to right click on the database and check if it is compatibility 100, that means 2008 if not you need to drop the full text indexes one then recreate it and do the same with all.
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply