3 Replies Latest reply: Feb 28, 2013 4:01 AM by Roger Ford-Oracle RSS

    DRG-11101 on multiple concurrent searches with CTX_DOC.MARKUP.

    984246
      I am using 11gR2 XE with .NET.

      I am getting the following exception on calling my DOMARKUP sproc which calls ctx_doc.markup:
      {"ORA-20000: Oracle Text error:
      DRG-11101: 
      failed to open file C:\\Windows\\TEMP\\drgib3
      \nORA-06512: at \"CTXSYS.DRUE\", line 160
      ORA-06512: at \"CTXSYS.CTX_DOC\", line 2198
      ORA-06512: at \"ME.DOMARKUP\", line 9
      ORA-06512: at line 1"}
      ME.DOMARKUP:
      create or replace 
      PROCEDURE DOMARKUP
      (
        C OUT CLOB
      , ID IN VARCHAR2
      , Q IN VARCHAR2
      ) AS 
      BEGIN
        
        ctx_doc.markup(index_name => 'text_index', textkey => ID, text_query => Q, restab => C, tagset => 'HTML_DEFAULT');
       
      END DOMARKUP;
      The circumstances are as follows. Quite simply, I (the user) am performing a search on my search engine. When I perform multiple searches at the same time, this error occurs. I have feeling the ctx_doc.markup is reading/writing from/to a temporary file for some reason, and the same one at that!

      Edited by: 981243 on Feb 27, 2013 11:24 PM

      Edited by: 981243 on Feb 27, 2013 11:25 PM