Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Text Index to avoid DRG-11225

Birthe GebhardtJan 26 2021

Hello Community,
I am playing around with Oracle Text using CTX_DOC.markup for some Word documents. But for some Words documents I get the DRG-11225 timeout error and I don't have any idea why.
The index onto the BLOB column is define:
create index "WORD_FILE_IDX_CTX" ON "WORD_FILE" ("WO_FILE") INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('datastore ctxsys.default_datastore filter ctxsys.auto_filter SYNC (EVERY "TRUNC(SYSDATE)+1") TRANSACTIONAL');
Calling the command:
ctx_doc.markup(
index_name => 'word_file_idx_ctx',
textkey => to_char(cur_rec.wo_id),
text_query => l_keywords,
restab => 'word_markup',
query_id => cur_rec.wo_id,
plaintext => FALSE,
tagset => 'HTML_DEFAULT');

Error Message:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_doc.markup
ORA-20000: Oracle Text error:
DRG-11207: user filter command exited with status 2
DRG-11225: Third-party filter timed out.

ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.CTX_DOC", line 2252

Thanks for your help.

By the way: How can I markup code over several lines here?

Thanks.
Birthe

Comments

Processing

Post Details

Added on Jan 26 2021
3 comments
619 views