 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / November 2007FTS user errors that I can't replicate!
I'm logging error messages for my ASP.NET application with errors being emailed to me as they occur. I continuosly get messages from one of my search pages that uses FTS with "Execution of a full-text operation failed. A clause of the query contained only ignored words". I've taken out all words out of the dictionary file and when use exactly the same search terms (these are emailed to me as well so that's exactly what they type in) and I can't replicate those errors, it all works fine for me! Please advise... There are several possibilities here - first is that you have edited the incorrect noise word list - for US English is noise.enu (for SQL 2000), for SQL 2005 it is noiseenu.txt. Both of these can be found in c:\Program files\Microsoft SQL Server\MSSQL$InstanceName\MSSQL\FTData\SQLServer$InstanceName\Config and c:\Program files\Microsoft SQL Server\MSSQL.X\MSSQL\FTData\ where X is your instance number. Also do a select sp_configure 'default full-text language' to ensure that you are not using the neutral word breaker on your server- also check sp_helpfulltext_columns to ensure that you are not using the neutral word breaker on your tables - is so, make sure you empty this noise word list as well. The other possibility is that you have not replaced the contents of your noise word list with a single space. In SQL 2005 you can also set the transform noise word list to 1 to supress this warning message sp_configure 'transform noise words',1 Reconfigure with override  SignatureRelevantNoise.com - dedicated to mining blogs for business intelligence. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > I'm logging error messages for my ASP.NET application with errors > being emailed to me as they occur. [quoted text clipped - 4 lines] > emailed to me as well so that's exactly what they type in) and I can't > replicate those errors, it all works fine for me! Please advise... Thanks for your reply, Hilary!! We've got SQL 2000 here. I've updated the words file to have just one single space. I did run those stored procs, but how can I tell if there's a word breaker on my tables? Having run both sp_configure 'default full-text language' and sp_help_fulltext_columns and the language is 1033 which is English US if I'm not mistaken so it shouldn't be a neutral word breaker... I've blanked all instances noise.eng and noise.enu, replacing all instances with a blank space and yet I'm still getting those errors! This is an example of one of the WHERE clauses where I'm using FTS: AND ( @SearchTermFTS IS NULL OR (CONTAINS(CurrentItem.Description2, @SearchTermFTS) OR CONTAINS(CatalogueItem.CatalogueItemName, @SearchTermFTS) OR CONTAINS(CatalogueItem.CatalogueItemName, @SearchTermFTS)) ) In my ASP.NET code, I'm taking a string of search terms and processing each term to be like @SearchTermFTS = '"penci*" AND "mar*"' Am I doing something wrong? Please help, it's very frustrating!! Guys, anyone could give me a clue? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.