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.
Discussion posts and replies are publicly visible
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.