My Oracle Support Banner

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 SEPTEMBER 09, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 18.8.13.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


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