Re: Intermedia 8.1.6

check your network logs.
Let me begin by saying that I thought Imtermedia stopped using external procedures to index in 8.1.6 but I may be wrong (8.1.7?)

Anyway all of the work or indexing is being handled by an external procedure.
There should be an entry in your tnsnames.ora that refers to 'external procedure',
something like 'extproc.world'.
Make sure that there is an entry.
There is documentation on MetaLink to test the external procedure connection and how to correct for errors.

Good luck,
Tim

"Stephan Bressler" <stephan.bressler_at_pdb.sbs.de> wrote in message news:9o784r$dge$1_at_news.mch.sbs.de...
> Hi,
>
> whenever we try to build an intermedia index we end with an error:
> ORA-29855 error occurred in the execution of ODCIINDEXCREATE routine
> ORA-20000 ConText error
> ORA-28579 network error during callback from external procedure agent
> ORA-6512 ctxsys.drue line 126
> ORA-6512 ctxsys.textindexmethods line 54
> ORA-6512 at line 1
>
> The index column is a blob, database is on NT.
>
> After creating a new preference I managed to get the index creation a step
> further, but it still fails.
>
> Any Ideas?
> Tia
> Stephan
>
>
> New preference:
> begin
> ctx_ddl.create_preference('mylex', 'BASIC_LEXER');
> ctx_ddl.set_attribute ( 'mylex', 'index_themes', 'NO');
> ctx_ddl.set_attribute ( 'mylex', 'index_text', 'YES');
> end
>
> #
> # create index
> #
> SQL> create index com01.idx_20 on com01.tbl_cms_content(doc)
> 2 indextype is ctxsys.context parameters('LEXER mylex');
> create index com01.idx_20 on com01.tbl_cms_content(doc)
> *
> ERROR at line 1:
> ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
> ORA-20000: interMedia Text error:
> ORA-28579: network error during callback from external procedure agent
> ORA-06512: at "CTXSYS.DRUE", line 126
> ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 54
> ORA-06512: at line 1
> #
> # ctx log
> #
> Oracle interMedia Text: Release 8.1.6.0.0 - Production on Mon Sep 17
> 15:13:35
> 2001
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
> 15-13-35 09/17/01 begin logging
> 15-16-03 09/17/01 populate index: COM01.IDX_20
> 15-16-04 09/17/01 Begin document indexing
> 15-18-09 09/17/01 100 documents indexed
> 15-18-34 09/17/01 200 documents indexed
> 15-21-42 09/17/01 300 documents indexed
> 15-22-35 09/17/01 400 documents indexed
> 15-22-51 09/17/01 Errors reading documents: 0
> 15-22-51 09/17/01 Index data for 427 documents to be written to database
> 15-22-51 09/17/01 memory use: 12583129
> 15-23-10 09/17/01 index data written to database.
> 15-23-33 09/17/01 500 documents indexed
>
>
>
Received on Thu Sep 20 2001 - 07:41:42 CDT