OUD Sorted Search LDAP Error "result=12" and "The search results cannot be sorted because the given search request is not indexed" (Doc ID 2215182.1)

Last updated on NOVEMBER 01, 2022

Applies to:

Symptoms

While trying to migrate from an OID/OVD environment to a newer OUD/OVD environment, one of the application maintainers has identified a problem performing the server side sort.

After some load balancer adjustments, tested from the application again and got the following error.

Some snippets from a) OVD access log, b) OVD diagnostic log, and c) OUD access log, are:

[2016-12-08T11:40:32.103-05:00] [octetstring] [NOTIFICATION] [OVD-20043] [com.octetstring.accesslog] [tid: 37] [ecid: <ECID>] conn=390,786 op=1 SRCH base=ou=people,dc=dev,<SUFFIX_DN> scope=2 filter=(|(&(|(|(testPhoneBookDisplayName=*r10e*))(|(givenName=*r10e*))(|(sn=*r10e*))(|(testEmailName=*r10e*))(|(mail=*r10e*))(|(telephoneNumber=*r10e*))(|(physicalDeliveryOfficeName=*r10e*))(|(postOfficeBox=*r10e*))(|(employeeNumber=*r10e*))(|(testAssignedcom=*r10e*))))) requestedAttributes=[employeeNumber] sizelimit=201 timelimit=0 typesOnly=FALSE
[2016-12-08T11:40:32.115-05:00] [octetstring] [NOTIFICATION] [OVD-20044] [com.octetstring.accesslog] [tid: 37] [ecid: <ECID>] conn=390,786 op=1 RESULT err=53 tag=0 nentries=0 etime=12 dbtime=0 mem=155,758,320/257,949,696

[2016-12-08T11:40:32.113-05:00] [octetstring] [WARNING] [OVD-40066] [com.octetstring.vde.backend.jndi.ConnectionHandle] [tid: 37] [ecid: <ECID>] Remote Server Failure:<HOSTNAME>:<PORT>.[[
javax.naming.OperationNotSupportedException: [LDAP: error code 12 - The search results cannot be sorted because the given search request is not indexed]; remaining name 'ou=People,<SUFFIX_DN>'

[08/Dec/2016:11:40:32 -0500] SEARCH REQ conn=209369 op=25379 msgID=25380 base="ou=People,<SUFFIX_DN>" scope=sub filter="(|(testPhoneBookDisplayName=*r10e*)(givenName=*r10e*)(sn=*r10e*)(testEmailName=*r10e*)(mail=*r10e*)(physicalDeliveryOfficeName=*r10e*)(employeeNumber=*r10e*)(testAssignedcom=*r10e*))" attrs="testEmailName,postOfficeBox,givenName,employeeNumber,sn,testPhoneBookDisplayName,testAssignedcom,physicalDeliveryOfficeName,mail,telephoneNumber"
[08/Dec/2016:11:40:32 -0500] SEARCH RES conn=209369 op=25379 msgID=25380 result=12 message="The search results cannot be sorted because the given search request is not indexed" nentries=0 etime=2

Cause

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