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 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.8.0PSU-2015-04-01 00:14:53Z-r126  - 11.1.1.8.0PSU-2016-04-05 00:15:40Z-r141876 (Build:7.3.5.185)

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

11.1.1.8.0PSU-2015-04-01 00:14:53Z-r126.. Issue did not present in .8 2013-06-21

Cause

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