Forum Stats

  • 3,768,996 Users
  • 2,252,894 Discussions
  • 7,874,831 Comments

Discussions

Oracle Text Index to avoid DRG-11225

Birthe Gebhardt
Birthe Gebhardt Member Posts: 23 Red Ribbon

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

Tagged:

Answers

  • Paulzip
    Paulzip Member Posts: 8,494 Blue Diamond

    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
    Birthe Gebhardt Member Posts: 23 Red Ribbon

    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
    Paulzip Member Posts: 8,494 Blue Diamond

    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.