Oracle Text Indexing Fails with "DRG-11207: User Filter Command Exited With Status 1" on MS Windows x86-64bit (Doc ID 1085320.1)

Last updated on JANUARY 21, 2013

Applies to:

Oracle Text - Version 10.2.0.2 to 10.2.0.4 [Release 10.2]
Microsoft Windows x64 (64-bit)
***Checked for relevance on 21-Jan-2013***

Symptoms

Getting Error when indexing binary documents or using CTX_DOC.FILTER with AUTO_FILTER for filtering our documents:

Line Pos Text
2 1 ORA-20000: Oracle Text error:
DRG-11207: user filter command exited with status 1
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DOC", line 745
ORA-06512: at line 11

-- Code executed
DECLARE
t_row ROWID;
l_ce_no ce_claimevent.ce_no%type;
CURSOR LossReport IS SELECT dwh_ce_no,ROWID dwh_row from DWH_LHINFO order by dwh_ce_no;
BEGIN

CTX_DOC.SET_KEY_TYPE('PRIMARY_KEY');
-- Also error if using ID by ROWID CTX_DOC.SET_KEY_TYPE('ROWID');
FOR LRCursor in LossReport LOOP
l_ce_no := LRCursor.dwh_ce_no;
t_row := LRCursor.dwh_row;
CTX_DOC.FILTER('CTX_DWH_LHINFO',l_ce_no, 'DWHT_TESTTABLE', TO_NUMBER(SubStr(l_ce_no,3)), PLAINTEXT=>TRUE);
END LOOP;
END;

select * from CTX_USER_INDEX_ERRORS where err_index_name='CTX_DWH_LHINFO';

ERR_INDEX_NAME ERR_TIMES ERR_TEXTKEY
------------------------------ --------- ------------------
ERR_TEXT
--------------------------------------------------------------------------------
CTX_DWH_LHINFO 12-MAR-10 AABlPXAAHAABkPhAAA
DRG-11207: user filter command exited with status 1


Running a simple test to index plain text is working fine, like:

connect textuser/textuser

create table quick ( quick_id number primary key, text varchar(80) );
insert into quick values ( 1, 'The cat sat on the mat' );
insert into quick values ( 2, 'The quick brown fox jumped over the lazy dog' );
commit;
create index quick_text on quick ( text ) indextype is ctxsys.context;

select * from ctx_user_index_errors where err_index_name='QUICK_TEXT';

no rows selected


Calling ctxhx.exe directly from MS Command Prompt does not reproduce any output:

R:\oracle\product\10.2.0\db_1\bin\ctxhx> ctxhx test.doc test.out
R:\oracle\product\10.2.0\db_1\bin\ctxhx> dir test.out

Directory of R:\oracle\product\10.2.0\db_1\bin\ctxhx

File Not Found



Changes

Installed additional Oracle Software on our MS Cluster system.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms