Unable To Execute A Metadata Search In WCC ADF UI When Using Brackets In The Search Term.

(Doc ID 2397997.1)

Last updated on MAY 17, 2018

Applies to:

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

Symptoms

On : 12.2.1.1.0 version, Content Server

Unable to execute a metadata search in WCC ADF UI when using brackets in the search term.

When searching using Title or any other metadata and the search term contains brackets, for example 'my ( test'  below error in the WCC ADF UI is returned.

'There was an error executing the search, possibly because the search expression was invalid.'

Below the requestaudit:

>requestaudit/6 04.30 10:13:20.570 IdcServer-2361 GET_SEARCH_RESULTS [dUser=TOXXX][QueryText=(dDocType `KM_Surveys`) (`my ( test` dDocTitle)) (dSecurityGroup `Internal`][StatusCode=-1][StatusMessage=Unable to retrieve search results. Parenthesis mismatch at character 68 in query: "(dDocType `BM_Surveys`) (`my ( test` dDocTitle)) (dSecurityGroup `Internal`"][IsJava=1] 0.11146199703216553(secs)


 

ERROR
-----------------------

'There was an error executing the search, possibly because the search expression was invalid.'



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to ADF
2. Choose a similar metadata and the search term contains brackets, for example 'my ( test'
3. Error is returned



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