DRG-11207, DRG-11222, DRG-11221, DRG-11301, DRG-11302, DRG-11428 Error Occurs When Sync Full Text Search Index For PDF Attachment (Doc ID 2440836.1)

Last updated on JUNE 08, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
When trying to sync Full Text Search Index for PDF, below error occurs

ERROR
DRG-11207: user filter command exited with status 1
DRG-11222: Third-party filter does not support this known document format.

DRG-11221: Third-party filter indicates this document is corrupted.

DRG-11301: error while indexing document
DRG-11302: document may be partially indexed
DRG-11428: document contains invalid characters

STEP
1. Move to $ORACLE_BASE/admin/[SID]/create/agile
2. Login with CTXSYS user using SQL*Plus and run below SQL

delete from DR$PENDING;
delete from DR$WAITING;
commit;

3. On the same session(CTXSYS user) in SQL*Plus, run below SQL

agile9_fts_prefs.sql
agile9_fts_prefs_lexer_world.sql

4. Login to agile user in SQL*Plus and run below SQL

agile9_fts.sql
agile9_ctx_recreate.sql

5. Delete ctx_user_index_errors record using SQL*Plus(agile user)

delete from ctx_user_index_errors where err_index_name = 'FILES_CONTENT_IDX';
commit;

6. Press Update Content URLs Now button on Java Client Full Text Search node

7. Check the record expected to be synchronized by running the below SQL in SQL*Plus(agile user)

select count(*) from files where content_url is not null;

8. Run the below SQL in SQL*Plus(agile user) to perform synchronization

exec ctx_ddl.sync_index('FILES_CONTENT_IDX');

9. Login to web client and create new part and attach the PDF file

10. sync fts index

exec ctx_ddl.sync_index('FILES_CONTENT_IDX');

11. Run the below SQL and confirm that the issue arise.

select a.*, b.*
from files a, ctxsys.ctx_user_index_errors b
where a.rowid=b.err_textkey
and b.err_index_name = 'FILES_CONTENT_IDX'
order by b.err_timestamp desc;

Cause

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