ERROR: "DRG-12504: stoplist CTXSYS.DEFAULT_STOPLIST does not exist" When Attempting to Upgrade P6 EPPM Using Dbsetup.bat/sh (Doc ID 2664801.1)

Last updated on AUGUST 23, 2023

Applies to:

Symptoms

When attempting to upgrade P6 EPPM,
the following error occurs.

ERROR
-----------------------
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-12504: stoplist CTXSYS.DEFAULT_STOPLIST does not exist
ORA-06512: at "CTXSYS.DRUE", line 171
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 316
ORA-06512: at line 6
SQL Query:
declare
vcnt pls_integer:=0;
begin
select count(1) into vcnt from user_indexes where index_name='DOCVER_DOCDATA_QSI';
if vcnt=0 then
  execute immediate 'CREATE INDEX DOCVER_DOCDATA_QSI on
DOC_VERSION(doc_data)INDEXTYPE IS CTXSYS.CONTEXT parameters(''lexer global_lexer
wordlist mywordlist sync (on commit)'')';
end if;
end;


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Attempt to upgrade P6 EPPM using dbsetup.bat/sh
2. During the upgrade process, the upgrade fails
3. Error occurs and cannot complete the upgrade

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.