Microsoft KB Archive/817301

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

Article ID: 817301

Article Last Modified on 5/12/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 3
 * Microsoft Cluster Server 1.1
 * MSN 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  in project  cannot be accessed. Error: 8007007f - The specified procedure could not be found.

-and-

Event Source: Microsoft Search

Description : The crawl for project  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

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.

