Search on full-text catalog ‘%ls’ for database ID %d, table ID %d with search condition ‘%ls’ failed with unknown result (%x).

Details
Product: SQL Server
Event ID: 7607
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: Search on full-text catalog ‘%ls’ for database ID %d, table ID %d with search condition ‘%ls’ failed with unknown result (%x).
   
Explanation
The full-text query failed for an unspecified reason.
   
User Action
Follow these steps:

  • Check the Event Viewer logs for errors that occur at the same time as this error. If there are other errors, troubleshoot them first.
  • Stop and restart the Microsoft Search service, and then retry your full-text command. Warning: the Microsoft Search service may be used by multiple instances of SQL Server or by other applications.
  • Rebuild the full-text catalog.
  • If you have restored your \Program Files\Microsoft SQL Server\MSSQL${YourInstanceName}\FTDATA\SQLServer${YourInstanceName}\Config directory from a backup, verify that the backup was taken when the Microsoft Search and MSSQLServer services were stopped. If they were not, restore a copy that was taken when the services were not running.

Related:

Leave a Reply