Skip to main content
Known Participant
Sep 1, 2023 5:49 AM UTC
Question

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

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
Brainy
Sep 1, 2023 7:54 AM UTC

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

Known Participant
Sep 1, 2023 11:18 AM UTC

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
Brainy
Sep 1, 2023 12:07 PM UTC

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

New Participant
Dec 28, 2023 2:50 PM UTC

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