This discussion is archived
3 Replies Latest reply: Feb 28, 2013 2:01 AM by Roger Ford RSS

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

984246 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points