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?
rizwan0001 I think here the issue is not with the query entity , please check the time taken by the view to retrive the complete data from the DB client side. If its taking moretime the issue is with the view. I dont think so 100000 record is the issue and my suggestion is to always use paging and get datas as per the batching.
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.