April 29, 2002 at 3:41 am
Hi all
SS2k, full-text query problem.
Im getting the following error:
Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed. Langauge database/cache file could not be found.
running:
select *
from organisation_name
where freetext (orgname_name, 'AMA')
the cataglogs generated ok, even so, the catelog file size is 1mb with 133k entries (very strange). Im thinking the FTC isnt installed correctly or there was a issue with installation that was never tested before.
Ideas?
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
April 30, 2002 at 3:06 am
Ok
Im in the process of repopulating the catelog, basically, nothing wrong with the install. The interesting one here is that from my client pc's EE, i created the catelog etc and fulltext indexed a specific column/table, when i started the full population from my client, the catelog file stayed at 1Mb in size throughout the entire population!? but when I populated from the server (using a scheduled job), the catelog file is now growing in size (what I expect to see) and is now over 5mb...
interesting.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
April 30, 2002 at 9:12 am
That does sound extremely unusual, perhaps a Microsoft feature. Have you tried to recreate the behavior from a different client as opposed to the server?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy