• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 674
  • Last Modified:

full text cluster resource failing

Hi there, we're got a sql 2000 cluster and the full-text resource has failed on both sides of the cluster (active-active).  The event log shows -

"The Gatherer property mapping file cannot be opened. Error: 80070002": and "An error occurred during the online operation for instance <SQL Server Fulltext>: 80070002 - The system cannot find the file specified."

All I've been able to find googling involves re-installing, or removing the search service, which we tried on a sandbox install and it got totally messed up.  

Just wondering if anyone has recovered from this error without a reinstall. It's an old system that uses this instance, with a 600 gig db, so we REALLY want to avoid a reinstall if possible.

Thanks for any thoughts!
0
rfamilypa
Asked:
rfamilypa
  • 3
  • 2
1 Solution
 
James MurrellProduct SpecialistCommented:
have you looked at this http://support.microsoft.com/kb/304282
0
 
rfamilypaAuthor Commented:
Yes :(  That one says we have to reinstall the instance, so I'm looking for any kind of workaround that may have been used.
0
 
rfamilypaAuthor Commented:
We solved this problem by following the steps in this link: http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.clustering/2006-08/msg00222.html

We did not have to reinstall the SQL instance!!

Basically, we had to delete the cluster resource, delete a registry key under Search\Install, run the searchstp.exe, run the ftsetup.exe (0 1 0 1 0 as the parameters), add the resource back, add 2 new registry keys in the Cluster\Resource registry for ApplicationPath and ApplicationName, then we were able to bring the new Full-Text resource back online.
0
 
rfamilypaAuthor Commented:
I meant without having to reinstall, not reboot.  Long night :)
0
 
James MurrellProduct SpecialistCommented:
great news
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now