DRG-11221 & DRG-11225 When Indexing MS Word 97-2003 Saved As MS Word 2016 (Doc ID 2699807.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

On : 12.2.0.1 version, RDBMS

ACTUAL BEHAVIOR
---------------
DRG-11221 & DRG-11225 When Indexing MS Word 97-2003 Saved As MS Word 2016

conn / as sysdba

drop user testctxhx cascade;

grant connect,resource,ctxapp,unlimited tablespace to testctxhx identified by password;

exec ctxsys.ctx_adm.set_parameter('file_access_role', 'CTXAPP')
exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public')
grant TEXT DATASTORE ACCESS to TESTCTXHX;

conn testctxhx/oracle

begin
--ctx_ddl.drop_preference('COMMON_DIR');
ctx_ddl.create_preference('COMMON_DIR','FILE_DATASTORE');
ctx_ddl.set_attribute('COMMON_DIR','PATH','<PATH_ON_THE_SERVER_TO_DOCUMENTS>');
end;
/

begin
--ctx_ddl.drop_preference('COMMON_FIL');
ctx_ddl.create_preference('COMMON_FIL','AUTO_FILTER');
ctx_ddl.set_attribute('COMMON_FIL','timeout',500000);
end;
/

drop table mytable purge;
create table mytable(id number primary key, docs varchar2(2000));
insert into mytable values(1,'SMLIS-MU.doc');
insert into mytable values(2,'SMLIS-MU2016.docx');
commit;

drop index myindex force;
create index myindex on mytable(docs)
indextype is ctxsys.context
parameters (
'datastore COMMON_DIR
filter COMMON_FIL');

select * from ctx_user_index_errors where err_index_name='MYINDEX';

Output of the execution:

drop user testctxhx cascade
         *
ERROR at line 1:
ORA-01918: user 'TESTCTXHX' does not exist

Grant succeeded.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

grant TEXT DATASTORE ACCESS to TESTCTXHX
     *
ERROR at line 1:
ORA-00990: missing or invalid privilege

Connected.

Role set.

USER is "TESTCTXHX"
DATABASE is "msesom"

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

drop table mytable purge
          *
ERROR at line 1:
ORA-00942: table or view does not exist

Table created.

1 row created.

1 row created.

Commit complete.

drop index myindex force
          *
ERROR at line 1:
ORA-01418: specified index does not exist

Index created.

ERR_INDEX_NAME
--------------------------------------------------------------------------------
ERR_TIMES ERR_TEXTKEY
--------- ------------------
ERR_TEXT
--------------------------------------------------------------------------------
MYINDEX
13-JUL-20 AAHTOBAAEAAABBFAAA
DRG-11207: user filter command exited with status 2
DRG-11225: Third-party filter timed out.

Changes

Cause

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