Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / December 2006

Tip: Looking for answers? Try searching our database.

full text not populate in secundary cluster node

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ana R. Pulido - 15 Dec 2006 08:32 GMT
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,
Hilary Cotter - 15 Dec 2006 15:46 GMT
Does this help? http://www.indexserverfaq.com/clusterfailure.htm Look at
second portion to address your problem.

Signature

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

> Hello
> We have 2 boxes running clustered windows 2000, SQL server 2000 sp4 in
[quoted text clipped - 11 lines]
>
> Regards,
Ana R. Pulido - 20 Dec 2006 09:05 GMT
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 can´t  in this articles no

> Does this help? http://www.indexserverfaq.com/clusterfailure.htm Look at
> second portion to address your problem.
[quoted text clipped - 14 lines]
>>
>> Regards,
Hilary Cotter - 21 Dec 2006 12:54 GMT
Did you re-register  the dll's and add the registry key? I strongly suspect
this is your problem.

Signature

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

> Hello,
> thank you for your answer,
[quoted text clipped - 38 lines]
>>>
>>> Regards,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.