Skip to main content
September 1, 2023
Question

The number of rows requested would exceed the configuration limit per engine Appian error while fecthing data from appian report

  • September 1, 2023
  • 4 replies
  • 0 views

HI All,

I am trying to fetch data from the appian report and report has around 50k records.

So I am using loop of batchsize 2500 to fetch the data from the Appian report using queryProcessAnalytics(), but when the startIndex becomes 10001 (i.e greater then 10k( it's giving me the following error.

What's the possible solution for the same ?

And is there a way if I can do it without changing any system configuration.

4 replies

stefanhelzle0001
September 1, 2023

Trying to load all data into memory is a very problematic approach and will break sooner or later. What are you trying to achieve?

September 1, 2023

I am using a batch size.. not fetching everything at once. my aim is to fetch data from appian report and store in database.

stefanhelzle0001
September 1, 2023

OK. Got you. I recommend to talk to Appian.

December 28, 2023

Hello, did you get the solution? I'm facing the same problem. Thank you