We have problem on our 2 original sql instances in a 4-node cluster.

Both the 2 old instances get one warning and one error message in the
event log.
This is the warning message for one of the instances:

****

Source: Microsoft Search
Category: Gatherer
Event ID: 3055

Description:
The Gatherer property mapping file cannot be opened. Error: 80070002.
The default values are being used. You may have to copy the property
mapping file from the setup CD, or reinstall the application.

****

Here comes the error message for the same instance:

****

Source: Microsoft Search
Category: Gatherer
Event ID: 10006

Description:
An error occured during the online operation for instance <SQL Server
Fulltext (Inst2)>: 80070002 - The system cannot find the file
specified

****

The service Microsoft Search is running, it's the cluster resource
that freak out. Since the full text is not used we removed the
resources from the clustergroups. without them it all works as it
should.

We have 2 new sql instances and they run the SQL Server Fulltext in
the cluster on whatewer node of the 4 witch the group is moved to. The
account used for sql is the same in all 4 instances and it's in the
administators group on all 4 nodes. The same goes fore the account
that runs the cluster.

What I would like to know is what file is the event message pointing
to? We can't se anything odd.

What is the default values?

If I copy it from the install CD, what directory?

If I reinstall, what will I have to reinstall?

In both cases. what about servicepack and hotfixes after?

/Peter

Hello Peter,

Please refer to the following Knowledge Base article concerning this issue:

304282 PRB: Full Text Resource Fails to Come Online on a Cluster with
"Event ID
http://support.microsoft.com/?id=304282

Regards,
Farooq Mahmud [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Hi there Farooq!

I have checked out that article already.

Since we have 2 instances that work we compare them with each other.
We found no differenses. That's why I ask the questions about
reinstalling from the CD.

I.E how to do the part I quote, what about the reinstall from CD or
rebuild. Where can I find the steps, and if I take it from the CD what
about SP and hotfixes? I hope you can help me.

"
From Knowledge Base-artikel - 304282

MORE INFORMATION
If the files in the FTDATA folder are replaced, corrupted, or deleted,
or if the FTDATA folder itself is deleted, the SQL Server Fulltext
cluster resource may have to be rebuilt to be restored to a stable
state.
"

/Peter


On Tue, 11 May 2004 13:08:15 GMT, farooqm (AT) online (DOT) microsoft.com (Farooq
Mahmud [MS]) wrotc: