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 / March 2007

Tip: Looking for answers? Try searching our database.

SQL Server 2000 - Full Text Search Error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AF - 23 Mar 2007 15:35 GMT
Hello All.

I have a Windows Server 2003 & SQL Server 2000 (SP4) EE cluster setup
using FTS on one table. It seems that when one node was failed over it
started throwing the following errors shortly after the crawl job
starts:

The crawl seed <MSSQL75://SQLServer/21ccaaa4> in project <SQLServer
SQL0000500006> cannot be accessed. Error: 8007007f - The specified
procedure could not be found.  .

Then a second later:

The crawl for project <SQLServer SQL0000500006> could not be started,
because no crawl seeds could be accessed. Fix the errors and try the
crawl again.

Then finally:

The end of crawl for project <SQLServer SQL0000500006> has been
detected. The Gatherer successfully processed 0 documents totaling 0K.
It failed to filter 1 documents. 0 URLs could not be reached or were
denied access.

Any ideas what is causing this?

*THANKS*
Hilary Cotter - 23 Mar 2007 18:06 GMT
You need to re-register your search dll's.
Follow the instructions towards the bottom where it tells you how to
register them of this link:

http://www.indexserverfaq.com/clusterfailure.htm

It applies to both clusters and stand alone machines.

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 All.
>
[quoted text clipped - 23 lines]
>
> *THANKS*
AF - 23 Mar 2007 19:23 GMT
> You need to re-register your search dll's.
> Follow the instructions towards the bottom where it tells you how to
[quoted text clipped - 38 lines]
>
> > *THANKS*

Any idea why this happens? I've done a lot of searching - this seems
quite common! :(
AF - 23 Mar 2007 19:39 GMT
> You need to re-register your search dll's.
> Follow the instructions towards the bottom where it tells you how to
[quoted text clipped - 38 lines]
>
> > *THANKS*

Ouch - there are about 20 .DLL - every one needs to be registered?
Hilary Cotter - 23 Mar 2007 22:55 GMT
To be on the safe side you should.
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

>> You need to re-register your search dll's.
>> Follow the instructions towards the bottom where it tells you how to
[quoted text clipped - 42 lines]
>
> Ouch - there are about 20 .DLL - every one needs to be registered?
AF - 26 Mar 2007 13:52 GMT
> To be on the safe side you should.
> --
[quoted text clipped - 54 lines]
>
> > Ouch - there are about 20 .DLL - every one needs to be registered?

Well, thank you! That did the trick - but do you have any idea as to
how/why that happened?
Hilary Cotter - 26 Mar 2007 22:55 GMT
If you are running on a cluster from what I understand sometimes the dll's
get corrupted during failover. I have no idea why this happens on a single
node.

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

>> To be on the safe side you should.
>> --
[quoted text clipped - 63 lines]
> Well, thank you! That did the trick - but do you have any idea as to
> how/why that happened?
AF - 27 Mar 2007 14:08 GMT
> If you are running on a cluster from what I understand sometimes the dll's
> get corrupted during failover. I have no idea why this happens on a single
[quoted text clipped - 78 lines]
> > Well, thank you! That did the trick - but do you have any idea as to
> > how/why that happened?

Wow - that's a little unsettling!
 
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.