My Oracle Support Banner

Searches Fail Using the SortSpec Parameter After Indexer Changed From Verity To Database.Fulltext (Doc ID 1240203.1)

Last updated on FEBRUARY 08, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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