Process Report not returning data if startCount is greater than 10000

Hi All,

We have a requirement where we need to pull data from a process report and store those information into a CSV file. We are thinking of an approach where we can pull the from process report first and by using "Export SQL to CSV" smart service, We can create a CSV file.

This report consists of huge amount of data > 200000, Hence we are using paging concept to pull data in a loop. It works fine till we have startIndex<10K but once it exceeds this limit the report throws an error

"The result cannot be returned. The number of rows requested would exceed the configured limit per engine. (APNX-1-4176-000)"

I believe report doesn't allow to query data after 10K, Can someone please advice how to fix this issue? or there is any other alternative of doing that? Thanks in advance

Parents Reply Children
No Data

 Discussion posts and replies are publicly visible