Full-text query failed because full-text catalog ‘%ls’ is not yet ready for queries.

Details
Product: SQL Server
Event ID: 7623
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: Full-text query failed because full-text catalog ‘%ls’ is not yet ready for queries.
   
Explanation
This error could occur under any of these circumstances:

  • The Microsoft Search service is not started.
  • If the SQL Server instance is clustered, the full-text resource is not online.
  • The specified catalog has not been populated.
  • The specified catalog has been disabled by some method outside of SQL Server, such as a direct registry update or an MSSearch administrative tool.
   
User Action
Follow these steps:

  • Verify that the Microsoft Search service is started.
  • If the SQL Server instance is clustered, also verify that the full-text resource for the specified SQL Server instance is online.
  • Rebuild and repopulate the specified catalog.

    EXEC sp_fulltext_catalog ‘fulltext_catalog_name’ , ‘rebuild’
    EXEC sp_fulltext_catalog ‘fulltext_catalog_name’ , ‘start_full’

  • Check the Event Viewer logs for errors related to Microsoft Search or that occur around the same tme as this error.

Related:

Leave a Reply