We are facing an issue while using a!queryEntity to retrieve data from a View table which contains a totalCount of around 100,000 records. The expression rule fails when batchsize is -1 and returns the following error "Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data.". but if we specify a smaller batchsize it's working fine as expected.
Moreover, The expression rule works as expected in lower lanes with about 5000 records.
what could be a work around to this?
While fetching data via query there is a limit on the time taken to retrieve data. Querying in batches may resolve your issue.
If the data has to be queried in bulk, you can use a stored procedure as an alternative. But that too has some pros and cons.
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.