Searches Fail Using the SortSpec Parameter After Indexer Changed From Verity To Database.Fulltext

(Doc ID 1240203.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

The Content Server was originally configured to use Verity as the search indexer. Searches were done with the added SortSpec parameter:

&SortSpec=dInDate ASC dSecurityGroup ASC

The search indexing was changed to DATABASE.FULLTEXT. Now an error occurs when doing searches:

Unable to retrieve search results. csSearchInvalidOrderByClause(dInDate ASC dSecurityGroup)

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