Fullt Text Search fails in a 2 node cluster

Hi!
I have a problem with Full Text Search in a clustered enviroment.
The Resource Fullt Text Search will not come online, it fails and giving me
a error in the log that says
"An Error occurred during the online operation for instance <SQL Server
Fulltext (UTB2)>: 80070002 - the system cannot find the file specified."
I′ve tried to reinstall Full Text by reading the KB 827449, but when i get
to the part where i should use the command "ftsetup.exe" i get a error in the
application log saying:
"Faulting application ftsetup.exe, version 2000.80.2039.0 faulting module
msvcr71.dll, version 7.10.3052.4, fault adress 0x00014d5c."
I also get a similar error concerning msvcrt.dll version 7.0.3790.1830.
We are using Windows 2003 SP1 and SQL 2000 Enterprise edition SP4
The strange about this is that right now there are 4 instances on the same
node where 2 of them has full text online and working but the 2 others has
the error mentioned above, so as i can understand there are no problem with
the nodes but instead i believe that the instances is not aware of Microsoft
Search. therefore as the KB article says i need to run the command
FTSETUP.EXE to configure the instances with Microsoft Search.
Right now i have no other ideas, fearing that the only thing to solve this
is to reinstall the whole SQL instance :o( wich is nothing i′m looking
forward to.
So please if you have any ideas, fill me in...
SweGuy
Sweden
Look in the FTData folder for each instance for files called Clus0.0,
clus0.1 etc. If those are not there, you may want to consider calling PSS
on this, as clustered FT issues are very difficult to troubleshoot.
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com
"SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
news:FB3CFE0A-FDB8-4DE6-ACD0-9395599AE818@.microsoft.com...
> Hi!
> I have a problem with Full Text Search in a clustered enviroment.
> The Resource Fullt Text Search will not come online, it fails and giving
> me
> a error in the log that says
> "An Error occurred during the online operation for instance <SQL Server
> Fulltext (UTB2)>: 80070002 - the system cannot find the file specified."
> Ive tried to reinstall Full Text by reading the KB 827449, but when i get
> to the part where i should use the command "ftsetup.exe" i get a error in
> the
> application log saying:
> "Faulting application ftsetup.exe, version 2000.80.2039.0 faulting module
> msvcr71.dll, version 7.10.3052.4, fault adress 0x00014d5c."
> I also get a similar error concerning msvcrt.dll version 7.0.3790.1830.
> We are using Windows 2003 SP1 and SQL 2000 Enterprise edition SP4
> The strange about this is that right now there are 4 instances on the same
> node where 2 of them has full text online and working but the 2 others has
> the error mentioned above, so as i can understand there are no problem
> with
> the nodes but instead i believe that the instances is not aware of
> Microsoft
> Search. therefore as the KB article says i need to run the command
> FTSETUP.EXE to configure the instances with Microsoft Search.
> Right now i have no other ideas, fearing that the only thing to solve this
> is to reinstall the whole SQL instance :o( wich is nothing im looking
> forward to.
> So please if you have any ideas, fill me in...
> --
> SweGuy
> Sweden
|||Yes the FDATA folder exist and i have also granted both the SQL and the
Cluster Service Account full control to the folder. Also checked permissions
in the registry. It looks OK everywhere but it fails on the DLLs mentioned
before.
SweGuy
IT Professional
Sweden
"Kevin3NF" wrote:

> Look in the FTData folder for each instance for files called Clus0.0,
> clus0.1 etc. If those are not there, you may want to consider calling PSS
> on this, as clustered FT issues are very difficult to troubleshoot.
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> http://kevin3nf.blogspot.com
>
> "SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
> news:FB3CFE0A-FDB8-4DE6-ACD0-9395599AE818@.microsoft.com...
>
>
|||does this help?
http://www.indexserverfaq.com/clusterfailure.htm
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
news:FB3CFE0A-FDB8-4DE6-ACD0-9395599AE818@.microsoft.com...
> Hi!
> I have a problem with Full Text Search in a clustered enviroment.
> The Resource Fullt Text Search will not come online, it fails and giving
> me
> a error in the log that says
> "An Error occurred during the online operation for instance <SQL Server
> Fulltext (UTB2)>: 80070002 - the system cannot find the file specified."
> Ive tried to reinstall Full Text by reading the KB 827449, but when i get
> to the part where i should use the command "ftsetup.exe" i get a error in
> the
> application log saying:
> "Faulting application ftsetup.exe, version 2000.80.2039.0 faulting module
> msvcr71.dll, version 7.10.3052.4, fault adress 0x00014d5c."
> I also get a similar error concerning msvcrt.dll version 7.0.3790.1830.
> We are using Windows 2003 SP1 and SQL 2000 Enterprise edition SP4
> The strange about this is that right now there are 4 instances on the same
> node where 2 of them has full text online and working but the 2 others has
> the error mentioned above, so as i can understand there are no problem
> with
> the nodes but instead i believe that the instances is not aware of
> Microsoft
> Search. therefore as the KB article says i need to run the command
> FTSETUP.EXE to configure the instances with Microsoft Search.
> Right now i have no other ideas, fearing that the only thing to solve this
> is to reinstall the whole SQL instance :o( wich is nothing im looking
> forward to.
> So please if you have any ideas, fill me in...
> --
> SweGuy
> Sweden
|||I have opened a case with Microsoft Support. Hopefully we can clear this out.
I′l let you know how it goes.
SweGuy
IT Professional
Sweden
"Hilary Cotter" wrote:

> does this help?
> http://www.indexserverfaq.com/clusterfailure.htm
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
> news:FB3CFE0A-FDB8-4DE6-ACD0-9395599AE818@.microsoft.com...
>
>
|||Who got your case? I mean the support engineer at MS...
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
news:01CAF11F-F93A-44B5-9631-206DCB2885D0@.microsoft.com...[vbcol=seagreen]
>I have opened a case with Microsoft Support. Hopefully we can clear this
>out.
> Il let you know how it goes.
> --
> SweGuy
> IT Professional
> Sweden
>
> "Hilary Cotter" wrote:
|||I have no specific name but the guy i talked to in the phone was Daniel
Berglund. He has passed the problem forward to other support engineers.
Apperently this kind of problems ususally result in a re-installation of the
SQL instance, but Daniel thought that maybe someone has solved this matter in
another way.
And thats what i′m hoping for :o)
SweGuy
IT Professional
Sweden
"Kevin3NF" wrote:

> Who got your case? I mean the support engineer at MS...
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
> news:01CAF11F-F93A-44B5-9631-206DCB2885D0@.microsoft.com...
>
>
|||Yup. The only "Official" way to fix most full-text resource issues is
uninstall/re-install.
Download filemon from sysinternals to get the exact file and path it is
looking for and go from there...
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
news:FD031460-357C-414A-A2E4-2B69293DC12F@.microsoft.com...[vbcol=seagreen]
>I have no specific name but the guy i talked to in the phone was Daniel
> Berglund. He has passed the problem forward to other support engineers.
> Apperently this kind of problems ususally result in a re-installation of
> the
> SQL instance, but Daniel thought that maybe someone has solved this matter
> in
> another way.
> And thats what im hoping for :o)
> --
> SweGuy
> IT Professional
> Sweden
>
> "Kevin3NF" wrote:

full text not populate in secundary cluster node

Does this help? http://www.indexserverfaq.com/clusterfailure.htm Look at
second portion to address your problem.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ana R. Pulido" <arpulido@.hac.juntaex.es> wrote in message
news:uJpaMOCIHHA.960@.TK2MSFTNGP04.phx.gbl...
> Hello
> We have 2 boxes running clustered windows 2000, SQL server 2000 sp4 in
> clustered mode, we have 2 instance of sql server in each node, and full
> text indexing run ok in the primary node but it fails in the instance of
> the secundary node, when I looked at the FTSDATA logs (with gthrlog.vbs) I
> had these:
> 14/12/2006 8:58:32 Add The gatherer has started
> 14/12/2006 8:58:32 Add The initialization has completed
> 14/12/2006 9:14:24 Add Started Full crawl
> 14/12/2006 9:14:26 MSSQL75://SQLServer/76818e95 Add Error fetching URL,
> (80070002 - The system cannot find the file specified)
>
> Thanks for your help.
> Regards,
>
>
Did you re-register the dll's and add the registry key? I strongly suspect
this is your problem.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ana R. Pulido" <arpulido@.hac.juntaex.es> wrote in message
news:Om%23DQYBJHHA.4376@.TK2MSFTNGP03.phx.gbl...
> Hello,
> thank you for your answer,
> i have read the article you suggested me and i do all the steps:
> 1) Is MSSearch running? -->Yes
> 2) Select ServerProperty(N'IsFulltextInstalled') --checking to verify the
> SQL FTS is actually installed on this machine --> yes
> 3) examine the response from Select * From fulltexttest where
> contains(*,'test') --> nothing rows are returned
> 4) Check the gatherer logs. -->14/12/2006 9:14:26
> MSSQL75://SQLServer/76818e95 Add Error fetching URL, (80070002 - The
> system cannot find the file specified)
> An this occurss in the instance sql server in the secundary node, not in
> the primery node .
> all the topics I see about it is something reinstall the SQLFTS, or change
> some keys in the regedit, do you know what can I do?
> thanks you again, regards
> Ana R
>
> my problem is different because one ni cant in this articles no
> "Hilary Cotter" <hilary.cotter@.gmail.com> escribi en el mensaje
> news:%23Ylch$FIHHA.2232@.TK2MSFTNGP02.phx.gbl...
>
>