This discussion is archived
12 Replies Latest reply: Jul 19, 2012 7:51 AM by 949278 RSS

CTX_DOC.snippet fails for some files

949278 Newbie
Currently Being Moderated
Hello everybody,
I'm performing the following query and it fails for some files.

select
to_char(CTX_DOC.snippet('IDX_FILECONTENT_CONTENT',
myTable.ID,
'{fish}',
'<b>',
'</b>'))
from
myTable myTable
where myTable.code = :code

The query works perfectly for 90% of the files and it gives the following error for some of them.

ORA-20000: Oracle Text error:
DRG-11207: user filter command exited with status 139

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DOC", line 1297
ORA-06512: at line 1
20000. 00000 - "%s"
*Cause:    The stored procedure 'raise_application_error'
was called which causes this error to be generated.
*Action:   Correct the problem as described in the error message or contact
the application administrator or DBA for more information.

Could it be that the file is too big? Otherwise I don't have any idea why it doesn't work.
Could anybody help me, please?
many many thanks.
  • 1. Re: CTX_DOC.snippet fails for some files
    Roger Ford Expert
    Currently Being Moderated
    What database version is it?
  • 2. Re: CTX_DOC.snippet fails for some files
    949278 Newbie
    Currently Being Moderated
    I use this version

    Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi

    Thank you very much
  • 3. Re: CTX_DOC.snippet fails for some files
    Roger Ford Expert
    Currently Being Moderated
    10.2.0.3 used the old Verity filters.

    They didn't support Office 2007 or 2010 files.

    Do you know what type of files you are having problems with? Are you able to create a text index on those files and search for them?

    Let us know if you're not sure how to create such an index.
  • 4. Re: CTX_DOC.snippet fails for some files
    949278 Newbie
    Currently Being Moderated
    Type of file: Microsoft Word 97 - 2003 Document (.DOC)

    What do you mean by creating a text index on those files? I created a text index on the column and this is why the snippet works properly for the other files in the database.

    That's the way I created the index:

    CREATE INDEX "MYSCHEMA"."IDX_FILECONTENT_CONTENT" ON "MYSCHEMA"."FILECONTENT"
    (
    "CONTENT"
    )
    INDEXTYPE IS "CTXSYS"."CONTEXT" ;

    Is it right?
    many thx
  • 5. Re: CTX_DOC.snippet fails for some files
    Roger Ford Expert
    Currently Being Moderated
    That would be correct if the datatype of the CONTENT column is BLOB or BFILE. Can you confirm that?

    Can you check if there are any errors in CTX_USER_INDEX_ERRORS after creating the index?
  • 6. Re: CTX_DOC.snippet fails for some files
    949278 Newbie
    Currently Being Moderated
    I can confirm that files are always BLOB.

    I've checked CTX_USER_INDEX_ERROR right now (I didn't do it when I create the index) and I found many errors.

    Ordering by date desc I got (today)

    "DRG-11207: user filter command exited with status 1
    DRG-11222: Third-party filter does not support this known document format.
    "
    The same day I found other 2 errors:
    "DRG-11207: user filter command exited with status 139
    "
    and
    "DRG-11207: user filter command exited with status 1
    DRG-11221: Third-party filter indicates this document is corrupted.
    "
    How can I see deeper which file caused these errors?
    thx
  • 7. Re: CTX_DOC.snippet fails for some files
    Roger Ford Expert
    Currently Being Moderated
    CTX_USER_INDEX_ERRORS contains a column "ERR_TEXTKEY" which contains the rowid of the row causing the error.


    You can join this back your original table to find out which rows have failed.

    For example if your FILECONTENT table has a FILENAME column you could do
    select filename from filecontent, ctx_user_index_errors
    where filecontent.rowid = chartorowid(err_text_key)
    and err_index_name = 'IDX_FILECONTENT_CONTENT'
  • 8. Re: CTX_DOC.snippet fails for some files
    949278 Newbie
    Currently Being Moderated
    Thank you very much for the query, but I didn't find among the files which gave problem to the index the one which is actually giving me the error when I call the snippet function.
    Do you have any idea?
    Many many thanks
  • 9. Re: CTX_DOC.snippet fails for some files
    Roger Ford Expert
    Currently Being Moderated
    This is getting close to the point where you need to raise an SR with support so you can send them the problem file for testing, but first can you see whether CTX_DOC.FILTER works for the problem document(s)?
  • 10. Re: CTX_DOC.snippet fails for some files
    949278 Newbie
    Currently Being Moderated
    Hi Roger,
    I manged to have a test environment (so now I'm free to do all the tests I want) and I inserted the document which gave me the problem into the test table.
    I executed the query to see if there was any error in the ctx_user_index_errors and I had

    "DRG-11207: user filter command exited with status 139"

    Now, if I call the function CONTAINS on the document, it returns nothing.

    Do you have any idea?
    thank you very much
  • 11. Re: CTX_DOC.snippet fails for some files
    Roger Ford Expert
    Currently Being Moderated
    So it appears that the filter is unable to filter your file at all. Is this on Solaris by any chance?

    There are several bugs which reference "status 139" which appears to mean that the filter code crashed.

    It's likely to be fixed by the patch for bug 6161701, which is release 22 of the Verity filters. However this patch is only available for 10.2.0.4, not 10.2.0.3.

    Upgrading to 10.2.0.5 will replace the Verity filters with Outside In filters (technology owned by Oracle rather than licensed from a third party) which will almost certainly fix the problem.
  • 12. Re: CTX_DOC.snippet fails for some files
    949278 Newbie
    Currently Being Moderated
    I can confirm that the servers are all Solaris 5.10.
    Is there any issue related to this os?

    Edited by: user11112227 on Jul 19, 2012 7:51 AM

Legend

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