We have configured the row limit per engine for process reports as 3000. When I pass the pagination from 3001 to 3010 then Appian throws below error.
Error: errorMessage=The result cannot be returned. The number of rows requested would exceed the configured limit per engine. (APNX-1-4176-000)
Rows that I am requesting is only 10, why do we get such kind of an error when engine can give me max 3000 rows.
Snippet:
a!queryProcessAnalytics( report: cons!QM_UNDERWRITING_TASKS_MIGRATION_REPORT, contextProcessModels: rule!QM_workflowTaskReportProcessesList(), query: a!query( pagingInfo: a!pagingInfo( startIndex: 3001, batchSize: 10, sort: a!sortInfo( field: "c1" ) ) ))
Discussion posts and replies are publicly visible
Hi Bala, did u restrict the row limit per engine by setting the property resources.appian.analytics.application.maxreportrows=?
If so , then error message is valid. You are trying to fetch the data that the analytics engine doesn't have since the upper limit is 3000. Rows below 3000 would be returned.
Please check the documentation
it clearly says that only specified number of rows will be loaded into application server memory.
"The maximum report row property shown below controls the upper limit of items in a report that can be loaded into application server memory and the last page that can be retrieved for a report. "