FIX: A Query That Uses a Large Search String in the CONTAINS Clause May Fail with Error Message 7607 (317486)

The information in this article applies to:

Microsoft SQL Server 2000 (all editions) SP2

This article was previously published under Q317486

BUG #: 356573 (SHILOH_BUGS)

SYMPTOMS

If you use large search strings in the CONTAINS clause of a full-text query, you may receive the following error message:

Msg 7607, Level 17, State 1
Search on full-text catalog (%s) for database ID (%d), table ID (%d) with search condition (%s) failed with unknown result (%x).

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How To Obtain the Latest SQL Server 2000 Service Pack

NOTE: The following hotfix was created before the release of Microsoft SQL Server 2000 Service Pack 3.

The English version of this fix should have the following file attributes or later:

   Version          File name
   -----------------------------

   9.107.6815.5     Mssearch.exe

NOTE: Because of file dependencies, the most recent hotfix or feature that contains the files may also contain additional files.

WORKAROUND

This problem can occur with search strings that are approximately 8 KB. To work around the problem, reduce the size of the search string.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3.

MORE INFORMATION

After the error message occurs, subsequent executions of full-text queries may fail with the following error message:

Server: Msg 7619, Level 16, State 1
Execution of a full-text operation failed. The pipe has been ended.

Then, the MS Search service may quit unexpectedly.

Modification Type:	Minor	Last Reviewed:	9/27/2005
Keywords:	kbHotfixServer kbQFE kbSQLServ2000sp3fix kbbug kbfix kbSQLServ2000preSP3fix KB317486