Article ID: 814035 - View products that this article applies to.
BUG #: 364037 (SQL Server 8.0)
After you upgrade to SQL Server 2000 Service Pack 3 (SP3), the population of a full-text catalog might fail, and you receive an error message.
The population finishes quickly, without an error, if it is initialized by using Query Analyzer. However, the following command returns 0, indicating that no items have successfully been indexed:
Additionally, the following warning is reported in the application event log:
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3036
The crawl seed <MSSQL75://SQLServer/xxxxxx> in project <SQLSERVER SQLxxxxxxxxxx> cannot be accessed. Error: 80004002 - No such interface supported.
This problem only shows up on servers that have had Microsoft SQL Server 7.0 and its full-text search component installed. SQL Server 7.0 full-text search uses a different registration mechanism than SQL Server 2000 full-text search for loading word breakers (used to tokenize text at index and at query time).
As such, the following registry key exists (for SQL Server 7.0 full-text search) that corresponds to the neutral word breaker:
Additionally, the following key exists (for SQL Server 2000 full-text search) that corresponds to the neutral word breaker:
The first registry key (for SQL Server 7.0) points to the Query.dll file as the neutral word breaker. In SQL Server 7.0 (all versions), and in SQL Server 2000 (all versions up to Service Pack 2), the neutral word breaker resides in the Query.dll file.
In SQL Server 2000 SP3, the neutral word breaker moves to a different module, Tquery.dll. The second registry key (the one shown for SQL Server 2000), is updated by Microsoft Search (MSSearch) setup, to indicate the correct location of the neutral word breaker in SQL Server 2000 SP3. However, the way that MSSearch loads word breakers is that it first honors the SQL Server 7.0 registration mechanism (in this case, using the old location for the neutral word breaker), followed by the SQL Server 2000 registration mechanism.
As such, when a repopulation of full-text catalogs begin in this scenario, MSSearch tries to load the neutral word breaker by using the SQL Server 7.0 location; therefore, the repopulation cannot complete.
Service pack informationTo 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:
(http://support.microsoft.com/kb/290211/ )How to obtain the latest SQL Server 2000 service pack
Hotfix informationThe English version of this fix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Note: Because of file dependencies, the most recent hotfix or feature that contains the files may also contain additional files.
Date Time Version Size File name -------------------------------------------------------------- 20-Feb-2003 20:38 9.107.8320.3 200,704 bytes Searchstp.exe
To work around this behavior, follow these steps:
256986WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
(http://support.microsoft.com/kb/256986/EN-US/ )Description of the Microsoft Windows Registry
If full-text search is a clustered resource, the following additional considerations apply:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.This problem was first corrected in Microsoft SQL Server 2000 Service Pack 4.