Microsoft Search full-text catalog population fails when you upgrade SQL Server 2000 failover cluster to SQL Server 2000 Service Pack 3 (817301)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions) SP3
  • Microsoft Cluster Server
  • Microsoft Search

SYMPTOMS

When you upgrade SQL Server 2000 Failover Cluster to SQL Server 2000 Service Pack 3 (SP3), the Microsoft Search full-text catalog population may fail, and you receive the following warnings in the Event Log:

Event Source: Microsoft Search
Description : The crawl seed <MSSQL75://SQLServer/014935cb> in project <SQLServer SQL0000600005> cannot be accessed. Error: 8007007f - The specified procedure could not be found.

-and-


Event Source: Microsoft Search
Description : The crawl for project <SQLServer SQL0000600005> could not be started, because no crawl seeds could be accessed. Fix the errors and try the crawl again.

When you run a full-text catalog population, the process runs fast and completes almost immediately. Even after the full-text catalog population, the Item Count of the full-text catalog may still be 1.

WORKAROUND

To work around this problem, re-register the following Microsoft Search (MSSearch) DLL files on all the nodes of the Failover cluster:
  • Query.dll
  • Tquery.dll

To re-register the DLLs, follow these steps:
  1. Open a command prompt.
  2. Run the following command:

    regsvr32 Full path of MSSearch DLL file

    Note By default, the MSSearch DLL files exist in the C:\Program Files\Common Files\System\MSSearch\Bin folder.
After you re-register the DLL files, perform the full-text catalog population. If the full-text catalog is still not populated, you must re-register all the DLL files that are in the MSSearch DLL files folder.

MORE INFORMATION

Item Count is the number of tables and rows indexed in a full-text catalog. After a successful population of the full-text catalog, the Item Count of the full-text catalog is greater than the total number of full-text indexed tables and their rows by one number.

To view the Item Count of a full-text catalog, follow these steps:
  1. In SQL Server 2000 Enterprise Manager, expand the SQL Server Name.
  2. Expand Databases, and then expand the Database Name.
  3. Click Full-Text Catalogs.
  4. In the right pane, right-click Full-text Catalog Name, and then click Properties.
  5. In the Full-Text Catalog Properties dialog box, the number that appears in the Item Count text box is the item count.

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

811168 INF: SQL Server 2000 Service Pack 3 or Service Pack 3a Pre-Installation Checklist for SQL Server 2000 Virtual Server for Failover Clustering


For more information about how to install SQL Server 2000 Service Pack 3 on a Failover Cluster, visit the following Microsoft Web site:
SQL Server version 2000 Service Pack 3 Readme.htm

For more information about populating Microsoft Search full-text catalogs, visit the following the following Microsoft Web site:
Administering Full-Text Features Using SQL Enterprise Manager
Modification Type:MajorLast Reviewed:8/8/2006
Keywords:kbtshoot kberrmsg kbClustering kbSysAdmin kbprb KB817301 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.