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.
No comments yet... Be the first to leave a reply!