Pagination Error when retrieving over 40000 records from on-prem Oracle database using data gateway

(1) Share

Report

Posted on by MS-19081230-0

I am trying to retrieve over 40000 records from an Oracle database on-prem using the data gateway. I am getting pagination error. I have set the pagination threshold to 40000 to cover for all items, and my Odata query is set to query top 35000 records. Any suggestions on how can I get past the following pagination error? here is the error:

The response is not a valid paginated response. The paginated response should not have the same non-empty 'nextLink' or 'odata.nextLink' property from the previous page when there are no items in the 'value' property

Categories:

Business Process Flows

All responses (1)

Answers (0)

Suggested answer

Michael E. Gernaey 43,218 Super User 2025 Season 1 on at

Like (0)

Report

Pagination Error when retrieving over 40000 records from on-prem Oracle database using data gateway

Hi,

Most of the time you should grab 5K rows in a page or less, not 35000.

But also what connector are you using?

1. Did you turn on Pagination

2. What are the Connectors limit (you can look that up)

3. How many rows did it say it returned before the error?

Again trying to pull down 40K at a time, isn't going to be reasonable for the flows or apps.