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
If you are on the Appian cloud, please raise a support ticket with Appian. It seems to be a configuration issue.
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.