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."
Last updated on JUNE 14, 2018
Applies to:Oracle WebCenter Content - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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-->
..... (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.
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