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