QueryEntity unable to retrieve large data in expression rule

Hi,

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?  

Parents
  • 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.

Reply
  • 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.

Children
No Data

 Discussion posts and replies are publicly visible