Skip to main content
N
nikhilau0001
Known Participant
October 17, 2021
Question

processModel error

  • October 17, 2021
  • 6 replies
  • 7 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

    P
    pauls0008
    Known Participant
    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

    N
    nikhilau0001Author
    Known Participant
    October 18, 2021

    hi, 

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

    S
    srimathig0001
    Participating Frequently
    October 18, 2021

    Use filter parameter within query entity

    csteward
    csteward
    Brainy
    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.  

      Terms & ConditionsAccessibility statement