Skip to main content
September 14, 2021
Question

how to fetch the data of query entity in batches?

  • September 14, 2021
  • 10 replies
  • 0 views

Interface Definition: Expression evaluation error [evaluation ID = c9564:63ac5] : An error occurred while executing a save: Expression evaluation error in rule 'TID_documentsquery' at function a!queryEntity_18r3 [line 2]: An error occurred while retrieving the data. Details: Memory threshold reached during output conversion (rule: [queryentity expression], type: [TIDContentTagsVwDT31557], threshold: [1,048,576 bytes], objects successfully converted: [3,228])

10 replies

vimals
September 14, 2021

Your query call has reached the memory threshold limit ~ 1MB.

docs.appian.com/.../Post-Install_Configurations.html

This usually happens when you try to call a query entity with batch size set as -1 and you are trying to pull more records from the database. Check if you can reduce your output size by applying filter or batch-size

September 14, 2021

Actually i need all the data to be fetched.

vimals
September 14, 2021

It is not recommended to query more than 1MB of data to avoid memory issues. If you still need it, you can query them in batches. Like if there are 50k records, query them 5 times with a 10K batch size.

Also, if you can share your use-case, community members can share some best practices around it.