An error occurred while evaluating expression: workflowDetails:rule!CNAM_GC_qeForAllTables(Flag:"WorkflowbyWorkFlowId",wfid:pv!workflowDetails.workflw_id) (Expression evaluation error in rule 'cnam_gc_qeforalltables' at function a!queryEntity [line 254]: An error occurred while retrieving the data. Details: Memory threshold reached during output conversion (rule: [queryentity expression], type: [CNAMGCWORKFLOWDT41204], threshold: [1,048,576 bytes], objects successfully converted: [12,000])) (Data Outputs)
Discussion posts and replies are publicly visible
Hi,
The query is returning too much data. (greater than threshold of 1Mb).
Either increase threshold (a system setting) or preferably use filtering on the query to reduce amount of data returned.
Regards
hi,
How can i increase threshold or use filter? can you please suggest
Use filter parameter within query entity
we already using it
You can also retrieve data by applying batch size in paging info parameter
If you describe your use case it may be helpful here. Do you need to display 1 MB of data to the user? What is happening in this situation?
But yes as the others mention the query is returning more data than the maximum allowed. Best practice is to update design and not the threshold configuration.