Re: Intermedia Text index build problem

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Thu, 20 Feb 2003 21:45:52 +0100
Message-ID: <b33ene$4mv$1@news.mch.sbs.de>

Hi Mike,

I had problems creating indexes, too.

In my case the problem was, that the default lexer created theme lists by default. The workaround is to create your own lexer by cloning the default lexer:
begin

ctx_ddl.create_perference('mylex', 'BASIC_LEXER');
ctx_ddl.set_attribute('mylex', 'index_themes', 'NO');
ctx_ddl.set_attribute('mylex', 'index_text', 'YES');

end;
create index ... indextype is ctxsys.context parameters ('LEXER mylex ....');

There some problems with the file converion (e.g. pdf to text). In my case they went away by upgrading 8.1.7.3 to 8.1.7.4. But you say your input are HTMLs, so this should not be the problem.

good luck
STephan

"Mike Hoey" <mthoey_at_yahoo.com> wrote in message news:1ccb6e35.0302200834.1c4af463_at_posting.google.com...
> I am using Oracle 8.17 with intermedia. I am able to build small full
> text indexes and create intermedia indexes for databae cols. The
> problem I have is when I have intermedia create an index over about
> 20,000 records. All of the files are HTML.
>
>
> Tee intermedia index begins to build, and makes it through a few
> thousand records. After about an hour or so though, i get an end of
> communication channel error.
>
> When I check the intermedia error logs, there is no information in
> them and the index is marked as POPULATE. I then have to drop the
> index with force in order to be able to do anything.
>
> Any ideas on what would make intermedia fail silently?
>
> Running on Win 2000 server.
>
> Thanks
Received on Thu Feb 20 2003 - 14:45:52 CST