SQLEXPRESS 2009 FULL TEXT SEARCH

Question

The first 1 or 2 times that I try to do a full text search (using CONTAINS(...)), I get the following error:

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Additional information: Word breaking timed out for the full-text query string. This can happen if the wordbreaker took a long time to process the full-text query string, or if a large number of queries are running on the server. Try running the query again under a lighter load.

After that it starts working ok. I'm working from within Visual Studio 2008 and using SQLEXPRESS 2009 with advanced services.

---

JLRosado

Answer 1

The first 1 or 2 times that I try to do a full text search (using CONTAINS(...)), I get the following error:

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Additional information: Word breaking timed out for the full-text query string. This can happen if the wordbreaker took a long time to process the full-text query string, or if a large number of queries are running on the server. Try running the query again under a lighter load.

After that it starts working ok. I'm working from within Visual Studio 2008 and using SQLEXPRESS 2009 with advanced services.

---

JLRosado

Hi JLRosado,

I think it’s SQL Server 2008 Express with Advanced Services,right?

Please have a look at the following document, which lists the probable causes for this issue and how to fix it:

MSSQLSERVER_30053
http://technet.microsoft.com/en-us/library/cc879279.aspx
 

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 2

Thanks for your response. The reference you gave does a pretty good job at explainning and re-explainning the problem. This is typical of Microsoft documentation and Books On Line. There are a lot of words and and space usage and jumping around the links and very few solutions. Every other link recomended in the MSDN documentation usually repeats what was read in the previous link but adds very little in the way of solutions. Documentation that is worth your while in all of Microsoft can probably be stored in less than 1 GB.

Thanks anyway!

---

JLRosado

Answer 3

I am wondering if you are using any 3rd party word breakers?

Perhaps you are running into this issue:

http://support.microsoft.com/kb/915850

---

looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 4

Hi:
NO. I was using plain vanilla SQLSERVER EXPRESS 2009 with advanced services. Nothing else. Now I installed SQL 2009 Developer edition and I have no problem. Oh, and yes this computer is always connected to the Internet.

Thanks

---

JLRosado

Answer 5

can you please follow the instructions in that kb article to see if it solved the problem on your 2008 machine. IIRC the certificates/signatures are still checked on 2008 for 3rd party wordbreakers.

---

looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941