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
  • 0
    A Score Level 1
    26 days ago

    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.

Reply
  • 0
    A Score Level 1
    26 days ago

    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.

Children
No Data

 Discussion posts and replies are publicly visible