Microsoft KB Archive/317486

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

Article ID: 317486

Article Last Modified on 2/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 2

-



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.

Additional query words: fulltext FTS

Keywords: kbhotfixserver kbqfe kbsqlserv2000sp3fix kbbug kbfix kbsqlserv2000presp3fix KB317486

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.