"Unable to execute service GET_SEARCH_RESULTS ..." Error Occurs When A Query Is Being Saved Using 'Save Search' Option (Doc ID 2189308.1)

Last updated on APRIL 20, 2017

Applies to:

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

Symptoms

ISSUE
-----------------------
When a query is saved using 'Save Search' and when navigated to My Content Server -> My Saved Queries -> Click on saved query, we get the following error.


ERROR
-----------------------
 "Unable to execute service GET_SEARCH_RESULTS and function getSearchResults
The error was caused by an internally generated issue. The error has been logged. "


STEPS TO REPLICATE
-----------------------
1. Login to Content Server and do a search.
2. On the  Search Results page, go to Search Actions -> Save Search.
3. A dialog box opens on which enter a title and click OK.
4. Now go to My Content Server -> My Saved Queries -> Click on saved query
5. Below error is generated:
"Unable to execute service GET_SEARCH_RESULTS and function getSearchResults.
The error was caused by an internally generated issue. The error has been logged. "
6. If we refresh page ( CTRL + F5 ) before clicking on the saved query, the query executes correctly.

Expected Result: User should be able to execute saved search query and get results successfully.
Actual Result: User is unable to get result due to the above said errors.

BUSINESS IMPACT
-----------------------
User is unable to execute saved searches on first attempt.

Changes

 

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