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?
Discussion posts and replies are publicly visible
As said,
1. TIme taken to run the query is limited and configure in the property file.
2. The amount of memory in bytes is also limited in conf file that.
3. Better to use paging and query in batch to keep the application in performance.
Let us know above 2 point config value and queryEntity expression to fins the issues.
Cheers