Oracle Text 10g Issue


We recently deployed an application which leveraged Oracle Text to a UAT environment and when it was moved to the production environment all our searches failed.

After checking the index errors table CTX_INDEX_ERRORS,  which is owned by the user CTXSYS, and most users do NOT have SELECT privilege to it by default. The following errors were observed:

DRG-11207: user filter command exited with status 1
DRG-11222: Third-party filter does not support this known document format.

The main difference we were informed of was that Oracle 10g in the UAT environment was version 10.2.0.4 and production was version 10.2.0.3.

To test the production environment we performed the steps recommended in the Oracle Text FAQ but modified the table to include a BLOB vs. a VARCHAR column to match our implementation.  We did find in the Oracle Forums the bug we were experiencing in production:

=========================
From Bug: 5105799

PROBLEM: – Clear description of the problem encountered:

When trying to index plain text stored in a BLOB it gives error: .
DRG-11207: user filter command exited with status 1
DRG-11227: Third-party filter does not support this document format. . –

DIAGNOSTIC ANALYSIS: .
Import table from customer (6 rows) .
try to create index on it and will get error: .
DRG-11207: user filter command exited with status 1
DRG-11227: Third-party filter does not support this document format. . for each row .

WORKAROUND: Use format column to bypass filtering

RELATED BUGS: none

REPRODUCIBILITY:
Consistent in 10.1.0.4.0 and 10.2.0.1.0 not reproducible on 10.1.0.3.0.
==========================

It was decided an upgrade to production be performed to resolve the error.

Technorati Tags: ,

About Wes MacDonald

Wes MacDonald is a DevOps Consultant for LIKE 10 INC., a DevOps consulting firm providing premium support, guidance and services for Azure, Microsoft 365 and Azure DevOps.

No comments yet... Be the first to leave a reply!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: