"Jonathan Levine" <myfoo2@nospam.nospam> wrote in message
news:23546C67-AAE7-43AB-B435-C255BB43CF0B@microsoft.com...
> Hello everyone,
>
> I have a large table (around 15m rows) I'm trying to Full-Text index using
> the Japanese wordbreaker.
>
> When I do a full process, after processing 3-4 million rows, I see a
couple
> of "Error Fetching URL (80070006 - Invalid handle)" records in the Gather
> Log, followed by many many c0000005 records in the log.
>
> At that point, the MSSearch service is still running, but if I try to shut
> it down using the sql server service manager or the windows tasks control
> panel, it hangs while stopping. I have to kill it using the task manager
> process panel.
>
> I tried applying SP4 and recreating the catalog, but I have the same
problem.
>
> Any suggestions?
>
> Regards,
>
> Jonathan

"Hilary Cotter" wrote:
> does this apply -
> http://support.microsoft.com/default.aspx?scid=kb;en-us;298794

"Jonathan Levine" <myfoo2@nospam.nospam> wrote in message
news:21043DBE-5885-41FC-A68B-462A7A6DEA47@microsoft.com...
> Hi again Hilary,
>
>
> "Hilary Cotter" wrote:
>> This is possibly a buffer overrun. How are you storing your data? Is it
>> in
>> char, varchar, text or image? If Image what is your document format?
>>
>
> Buffer overrun sounds likely to me.
>
> The data is in two columns: one big nvarchar, and an ntext.
>
> It is Japanese text from web pages (the web pages have been stripped of
> HTML
> tags).
>
> Regards,
>
> Jonathan
>
>

"Jonathan Levine" <myfoo2@nospam.nospam> wrote in message
news:23546C67-AAE7-43AB-B435-C255BB43CF0B@microsoft.com...
> Hello everyone,
>
> I have a large table (around 15m rows) I'm trying to Full-Text index using
> the Japanese wordbreaker.
>
> When I do a full process, after processing 3-4 million rows, I see a
couple
> of "Error Fetching URL (80070006 - Invalid handle)" records in the Gather
> Log, followed by many many c0000005 records in the log.
>
> At that point, the MSSearch service is still running, but if I try to shut
> it down using the sql server service manager or the windows tasks control
> panel, it hangs while stopping. I have to kill it using the task manager
> process panel.
>
> I tried applying SP4 and recreating the catalog, but I have the same
problem.
>
> Any suggestions?
>
> Regards,
>
> Jonathan

"Hilary Cotter" wrote:
> This is possibly a buffer overrun. How are you storing your data? Is it in
> char, varchar, text or image? If Image what is your document format?
>

"Hilary Cotter" wrote:
> just out of curiosity, do you get the problem when you index the content
> with the neutral word breaker?
>

"Jonathan Levine" <myfoo2@nospam.nospam> wrote in message
news:51A6B6D7-D439-4351-B619-D8645494DDF5@microsoft.com...
> Hilary,
>
> "Hilary Cotter" wrote:
> > just out of curiosity, do you get the problem when you index the content
> > with the neutral word breaker?
> >
> I haven't tried the neutral word breaker. The neutral word breaker
doesn't
> handle Japanese text very well: most Japanese is written without
whitespace
> between the words, so I don't think the neutral word breaker index would
be
> very useful even if it worked.
>
> Jonathan

"Hilary Cotter" wrote:
> I realize you are loosing the language capabilities you need - however if it
> works using the neutral word breaker the problem is with the Japanese word
> breaker and you can raise this as a bug with MS. If it fails with the
> neutral word breaker something is wrong with your environment which might be
> solved with a reapplication of the service pack, or by removing and
> reinstalling SQL FTS.