Search Cache Not Updating when Using the SortSpec Option (Doc ID 2236500.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Symptoms

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: http://<HostName>:16200/cs/idcplg?IdcService=GET_SEARCH_RESULTS&QueryText=dDocType++'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: http://<HostName>:16200/cs/idcplg?IdcService=GET_SEARCH_RESULTS&QueryText=dDocType++'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.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.