August 19, 2008 at 8:25 am
Hi Friends,
We recently migrated a SQL 2000 instance from Windows 2000 server to Windows 2003 server. After migration we are receiving this error related to full text catalog when executing a stored procedure. After googling,I found that word breaker dll has been changed in windows 2003 which causes this issue.
Command:
UPDATE Company SET Desc = ISNULL(STUFF(Desc ,PATINDEX('%AT&T%', Desc),LEN('AT&T' ) + 1,'') ,Part_Desc) FROM Company WHERE CONTAINS(Desc,'"AT&T"')
Error:
Server: Msg 7619, Level 16, State 1, Line 1 Execution of a full-text operation failed. A clause of the query contained only ignored words.
Is there any solution for this because all of the below results are outdated and may be some fix would have been done by now!
http://www.databasejournal.com/features/mssql/article.php/3454281
http://www.sqlservercentral.com/Forums/Topic117679-8-1.aspx
Regards,
Sakthi
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
August 31, 2008 at 8:51 am
Hi All,
After contacting Microsoft we got the reply that this error is by behaviour.. so below are the option...
1) Remove the words creating issue from noise word list and repopulate FT catalog.
2) Switch back to Windows 2000 so that old wordbreaker dll will be used.
3) Use FREETEXT() instead of CONTAINS() keyword. Disadvantage is that FREETEXT will be less precise meaning if you search for "tunein" it will list everything like "tunein.in" "tunein radio" etc.. but CONTAINS will return exactly matching results.
4) Change the noise words to something else. For ex: AT&T to ATT.
5) Change regsitries in Windows 2003 to use Old wordbreaker dll which will become unsupported SQL version.
Hope this helps! Contact me for more help!
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply