Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ConText indexing error

ConText indexing error

From: Gerhard Moeller <Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de>
Date: 1997/10/02
Message-ID: <60vru7$ua9@news.Informatik.Uni-Oldenburg.DE>#1/1

Hi,

the other day I posted a question about a terribly long ConText indexing process. Thanks to Thomas Kyte, it proved that the indexing process was actually hanging (still consuming lots of CPU cycles, however) due to insufficent SYSTEM tablespace. (Which I cannot explain, as the SYSTEM tablespace is set autoextend unlimited)

Changing the default tablespace for ctxsys helped, however, now I get some other error that is not amusing, either:

(remark: those might not be the original error messages, I translated them from German to English, as I set my NLS variables to German...)

TEST_at_gerhard:orcl SQL(16)> EXECUTE CTX_DDL.CREATE_INDEX( 'udk_schlagwortede_soundex', 1 );
begin CTX_DDL.CREATE_INDEX( 'udk_schlagwortede_soundex', 1 ); end;

*
ERROR at line 1:
ORA-20000: ConText error:
DRG-00100: Internal Error; Arguments:
[50853],[/m/ctx_src_2/src/dr/dreb/drebk.c],[662],[],[]

ORA-01401: Inserted Value to large for column.
ORA-06512: at "CTXSYS.DRUE", line 110
ORA-06512: at "CTXSYS.CTX_DDL", line 245
ORA-06512: at line 1

What the hell is happening here?
I use a rather large stop word list (250 entries), soundex, German stemming, HTML filtering, 50 MByte reserved RAM for the engine, and some other preferences that should cause no problem.

The attribute to index is a VARCHAR2(700) type, and the textkey is VARCHAR2(37). I use ConText option 1.x on a DEC alpha OSF 1, v4.0c and Oracle RDBMS 7.3

What did I do wrong?

        Thanks for any help, Gerhard. Received on Thu Oct 02 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US