Search Cache Not Updating when Using the SortSpec Option

(Doc ID 2236500.1)

Last updated on FEBRUARY 23, 2017

Applies to:

Oracle WebCenter Content - Version to [Release 11g]
Information in this document applies to any platform.


When a new document is checked in or an existing document is updated with a new revision it is not show in the search results.

Steps to reproduce:

A.  Run:'Document'&searchFormType=standard&SearchQueryFormat=UNIVERSAL&ftx=&AdvSearch=True&ResultCount=20&SortField=xSequence&SortOrder=Desc&SortSpec=order+by+xSequence+asc,dInDate+desc
We see the correct sort order for existing documents.

B. Check in a new document that will be in search results.

C. Run the same URL:'Document'&searchFormType=standard&SearchQueryFormat=UNIVERSAL&ftx=&AdvSearch=True&ResultCount=20&SortField=xSequence&SortOrder=Desc&SortSpec=order+by+xSequence+asc,dInDate+desc
The new document does not show in the search results. After the cache expires the document will show.

If the configuration entry is set the issue will not happen:  UseSearchCache=false

Note the "SortSpec" option in the search.

With the search cache disabled the search performance is not as good.




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