Adaptive Search RESTAPI- Search with Advance Query Descriptor Is Not Fetching More Than 10k Records (Doc ID 3012521.1)

Last updated on APRIL 09, 2024

Applies to:

Symptoms

On : 11.13.24.01.0 version, Custom Objects

Adaptive Search Search with Advance Query Descriptor REST API Is Not Fetching More Than 10k Records

We have a requirement where we want to fetch more than 10000 records using below rest API endpoint.

https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

But currently it is able to fetch only 10000 records when checked from postman as well as from OIC.

If we set the limit as 20000, we are getting 500 error response.

ERROR
-----------------------
"Error": "Incident with id: 23 was written on server: ServiceServer_as1_01"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Invoke the below rest endpoint to get custom object records.
https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries

Body :

{
  "entity" : "customobject_c",
  "limit" : 20000,
  "onlyData" : "true",
"op" : "$eq",
  "attribute" : "sampleattribute_c",
  "value" : "XYZ"
  },
  {
  "op" : "$ne",
  "attribute" : "sampleattribute_c",
  "value" : "ABC"
  } ]
  }
}

2. Run a POST operation.
3. See status returned as 500 Internal Server Error.
"Error": "Incident with id: ** was written on server: <sever_name>"


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot fetch more than 10k records with this endpoint.

Changes

Cause

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