Oracle FullText Search (OTS) and WebCenter Content (WCC) Accounts with Underscores Generates Error: "Error Unable to retrieve search results. Encountered an exception while executing a query."

(Doc ID 1672808.1)

Last updated on JUNE 14, 2018

Applies to:

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

Symptoms

Fulltext Search Error when using WCC Accounts, and OTS.

Execute search for a regular user results in error generated:

Content Server Request Failed
Error Unable to retrieve search results. Encountered an exception while executing a query.

STEPS TO REPRODUCE:

A Webcenter Content Credential Map is added similar to this example:
- In the Map Identified field type:  testmap
- Add this in the Map box-->
"...
&test1,                    fulltexttest
&test1,                    @TESTL(R)
&test1,                    @TEST_COM(R)
&test1,                    @TEST_COM-01-01-01(RWD)
&test1,                    @TEST_COM-01-02-01(RWD)
&test1,                    @TEST_COM-01-03-01(RWD)
.....
&test1,                    @TEST_COM-05-06(RWD)
&test1,                    @TEST_COM-05-07(RWD)
&test1,                    @TEST_COM-05-09-01(RWD)

..... (Add more accounts, etc)

Initially check-in at least 100 MS Word, PDF and text documents
- must use one of the Account names above (use a different name for each document).

Keep adding accounts to the above credential map to eventually cause the error.

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