Skip to main content
October 17, 2021
Question

processModel error

  • October 17, 2021
  • 6 replies
  • 0 views

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)

    6 replies

    October 17, 2021

    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

    October 18, 2021

    hi, 

    How can i increase threshold or use filter? can you please suggest 

    October 18, 2021

    Use filter parameter within query entity

    csteward
    October 18, 2021

    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.