DQM Staging Program Fails on DQM Create Index with ORA-29855 ORA-20000 ORA-600[17182] (Doc ID 1069139.1)

Last updated on MARCH 05, 2013

Applies to:

Oracle Text - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 06-Mar-2013***


Symptoms

The DQM Staging Program fails on DQM Create Index (DQM Creation Index Program) with this errorstack:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
ORA-00600: internal error code, arguments: [17182], [0x1102E04C8], [], [], [], [], [], [], []

The trace file associated with the ORA-600[17182] shows the problem occurs as a result of an attempt to create this Text index in 11.1.0.7.0:

CREATE INDEX AR.hz_stage_parties_t1 ON hz_staged_parties(concat_col) indextype is ctxsys.context
parameters ('
 storage APPS.HZ_DQM_STORAGE
 datastore APPS.hz_party_ds SECTION GROUP APPS.HZ_DQM_PARTY_GRP
 STOPLIST CTXSYS.EMPTY_STOPLIST
 LEXER APPS.dqm_lexer
 memory 52428800');


This problem is reproducible by attempting to create this Text index via SQL*Plus:

SQL> CREATE INDEX AR.hz_stage_parties_t1
ON hz_staged_parties (concat_col)
INDEXTYPE IS ctxsys.context
PARAMETERS ( 'storage APPS.HZ_DQM_STORAGE
datastore APPS.hz_party_ds
SECTION GROUP APPS.HZ_DQM_PARTY_GRP
STOPLIST CTXSYS.EMPTY_STOPLIST
LEXER APPS.dqm_lexer
memory 52428800' )
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
ORA-00600: internal error code, arguments: [17182], [0x1102E04C8], [], [], [], [], [], []
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 365

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms