Fulltext - Langauge database/cache file missing

  • 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"

  • 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"

  • 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

    bkelley@sqlservercentral.com

    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