You cannot use the CBR optimization SQL option CBR_DB_FIRST in a query that uses order by rank because the database first algorithm does not support this type of query.

Namespace:  FileNet.Api.Exception
Assembly:  FileNet.Api (in FileNet.Api.dll)

ToggleSyntax

Visual Basic (Declaration)
Public Shared ReadOnly RETRIEVE_OPTIMIZED_SEARCH_INVALID_RANK_ORDER As ExceptionCode
C#
public static readonly ExceptionCode RETRIEVE_OPTIMIZED_SEARCH_INVALID_RANK_ORDER
Visual C++
public:
static initonly ExceptionCode^ RETRIEVE_OPTIMIZED_SEARCH_INVALID_RANK_ORDER
JavaScript
FileNet.Api.Exception.ExceptionCode.retrievE_OPTIMIZED_SEARCH_INVALID_RANK_ORDER

ToggleSee Also