WebCenter Content (WCC) Oracle Text Search Query Negative <NOT> Search Generates Error: Unable to Retrieve Search Results. Error Occurred While Processing

(Doc ID 2138838.1)

Last updated on AUGUST 16, 2017

Applies to:

Oracle WebCenter Content - Version and later
Information in this document applies to any platform.


On : 00:14:53Z-r126  - 00:15:40Z-r141876 (Build:

Oracle Database with OracleTextSearch set.

Error generated when executing "Not Equals" operator Oracle Text search
STEPS to reproduce
The issue can be reproduced at will with the following steps:
1. Config.cfg: Set (ORACLETEXTSEARCH)UniversalQueryOperators=|equals|hasAsWord|hasAsWordPrefix|dateGE|dateLess| numberGreater|numberGE|numberEquals|numberLE|notHasAsSubstring|numberLess|notEquals|
2. Execute with not matches <NOT> a Search
3. Error is generated

Changes 00:14:53Z-r126.. Issue did not present in .8 2013-06-21


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