Memory Threshold Issue

Question

Hi, 
 
 We are facing the below error while trying to execute the expression rule to fetch data from data base table: 
 
 An error occurred while evaluating expression: listofIDtodelete:rule!abc(cons!xyz) (Expression evaluation error in rule 'abc' at function a!queryEntity [line 5]: An error occurred while retrieving the data. Details: Memory threshold reached during output conversion (rule: [queryentity expression], type: [DataReportDT7042], threshold: [1,048,576 bytes], objects successfully converted: [131,071])) (Data Outputs) 
 Please provide your help regarding the resolution of this issue.

Mike Schmitt · Answer

In addition to what Stefan said - in your first query, there is no need to pull back all rows of a query ("batchSize: -1") when you're just checking that the totalCount is zero. Instead set your batchsize to Zero, which makes the query pull back metadata (including TotalCount) but not pull back any rows of data.

davel001150 · Answer

One possibility might be Execute Stored Procedure. That can also be called upon to run a database FUNCTION, which can return simply the results of your aggregation. I assume you just want things like COUNT, AVE, MIN, MAX. You can have the DB run all the aggregation calculations and have it return only the few integers you need, if what you need is a few integers. That way, you don't have to bring the whole dataset to bear for Appian to perform aggregation, but let the DB do it.

Mike Schmitt · Answer

Considering that you seem to be fetching " listofIDtodelete " - how many columns are you returning in your query?

Mike Schmitt · Answer

Then I defer to 's original suggestion of employing Batching somehow within your process.

Memory Threshold Issue

Top Replies