My Oracle Support Banner

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 MAY 03, 2023

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.