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...
>
>

FTS does not index htm file in image column

Hi,
I have FT indexing set up on an image column, the column is binded to a
document type column and the FT indexing works fine. My problem is that
when a html file has the following utf-8 metatag
<META http-equiv=Content-Type content="text/html; charset=utf-16">
then the FT searches do not work on that particular file at all. Does
anyone know why this should be the case? Is there a way of making FT
index these files?
thanks in advance,
Paul
what is the value of your document type column? Are there any errors in your
gatherer log?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
<paul.craigie@.gmail.com> wrote in message
news:1105972135.333652.164980@.f14g2000cwb.googlegr oups.com...
> Hi,
> I have FT indexing set up on an image column, the column is binded to a
> document type column and the FT indexing works fine. My problem is that
> when a html file has the following utf-8 metatag
> <META http-equiv=Content-Type content="text/html; charset=utf-16">
> then the FT searches do not work on that particular file at all. Does
> anyone know why this should be the case? Is there a way of making FT
> index these files?
> thanks in advance,
> Paul
>
|||thanks for prompt response.
the value of the documenttype column for a html file that does not get
returned by FTS is corpUpdate3.htm. For comparison, the documenttype
value for another record which does get returned (i.e. does not have
the utf-8 meta tag) is corpUpdate4.htm . I'm not sure what you mean by
gatherer log, I have checked the event viewer and there's nothing there
from MS Search or msci.
Paul
|||I think you will need to add the MS.Locale language tag for this to work.
Let me try to repro it.
Also, the DocumentType column contents should be htm, html, .htm, or .html
<paul.craigie@.gmail.com> wrote in message
news:1105974655.007897.288270@.z14g2000cwz.googlegr oups.com...
> thanks for prompt response.
> the value of the documenttype column for a html file that does not get
> returned by FTS is corpUpdate3.htm. For comparison, the documenttype
> value for another record which does get returned (i.e. does not have
> the utf-8 meta tag) is corpUpdate4.htm . I'm not sure what you mean by
> gatherer log, I have checked the event viewer and there's nothing there
> from MS Search or msci.
> Paul
>
|||Hi Hilary,
I've worked out where the gatherer log files are. There are lots of
this kind of error in there ..
f28c7c9b1c4fcb0MSSQL75://SQLServer/3805392f/000000638000001c080040e21Multiple-step
OLE DB operation generated errors. Check each OLE DB status value, if
available. No work was done.
does this tell us anything?
Paul
|||It could. Could you possibly post the html file here?
Also is there anything non-standard about your machine? Do you have
Sharepoint, Yukon, Exchange running on this machine? Is this a cluster?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
<paul.craigie@.gmail.com> wrote in message
news:1105979877.237531.111230@.c13g2000cwb.googlegr oups.com...
> Hi Hilary,
> I've worked out where the gatherer log files are. There are lots of
> this kind of error in there ..
> f28c7c9b 1c4fcb0 MSSQL75://SQLServer/3805392f/00000063 8000001c 0 80040e21
Multiple-step
> OLE DB operation generated errors. Check each OLE DB status value, if
> available. No work was done.
> does this tell us anything?
> Paul
>
|||OK,
the first test file looks like this ..
<html>
<head><META http-equiv=Content-Type content="text/html;
charset=utf-8"></head>
<body>
<p>paultest2</p>
</body>
</html>
and the second test file looks like this
<html>
<head></head>
<body>
<p>paultest2</p>
</body>
</html>
when I do a search on 'paultest2', only the second file is returned.
The SQL server is on a dedicated DB server, there are no other apps
running on it. I tried the MS.Locale language tag but it hasn't made
any difference to the chances of a file being returned by FTS.
Paul