Oracle Text Index to avoid DRG-11225

Birthe Gebhardt

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

Paulzip

Set the timeout attribute of the ctxsys.auto_filter to a higher value. By default it is 120 seconds. That document appears to be taking longer than that. Big document?

See here for information on the attribute.

Birthe Gebhardt

Hello Paulzip,

thank you for your hint.

I have set the timeout to a higher value,but unfortunaly the docs are not fully transfered into html.

My test result is not really clear: The greatest doc is successfully contered into html

test2.docx	        67588	OK
test.docx	        67714	OK
WordTemplateNEW.docx	104167	OK
UEH-05-A-40003.docx	115198	OK
2000001573_000.docx	127219	Failed
2000000137_001.docx	285978	OK
test3.docx	        391249	Failed
1000000765_02E.docx	547348	OK

Do you have any idea's ?

Many thanks,

Birthe

Paulzip

Are you saying they are failing to to convert or failing to convert in time?

If the latter, try setting the value much higher to see if they all finish.