Skip to main content
Inspiring
January 6, 2021
Question

Retrieving huge amount of data

  • January 6, 2021
  • 11 replies
  • 1 view

Hi,

I have created a view to display it in read only grid. 

There is huge amount of data that needs to be retrieved and displayed.

But when am writing simple query to fetch data am getting error:

a!queryEntity(
entity: cons!AB_DE_V_DD,
query: a!query(

pagingInfo: if(
rule!APN_isEmpty(
ri!pagingInfo
),
a!pagingInfo(
startIndex: 1,
batchSize: 50
),
ri!pagingInfo
)
)
)

Error: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data.

Can someone help to sort this issue.

Note: When am using filter to retrieve data, am not getting any error

    11 replies

    stewart.burchell
    Participating Frequently
    January 6, 2021

    You need to examine the Appian logs to find out the exact root cause of the error. Look in the current stdOut log. Given that you've already said the dataset is huge it may be volume-related, but check the logs to be sure, there are other reasons why this error occurs.

    Inspiring
    January 6, 2021

    Thanks seems so many date field are used so that issue..

    Inspiring
    January 6, 2021

    Can you help me with like how to retrieve data from db for last 10 days