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:Primavera P6 Enterprise Project Portfolio Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
When attempting to upgrade P6 EPPM,
the following error occurs.
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
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)'')';
The issue can be reproduced at will with the following steps:
- Attempt to upgrade P6 EPPM using dbsetup.bat/sh
- During the upgrade process, the upgrade fails
- Error occurs and cannot complete the upgrade
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