Skip to main content
nikhilau0001
Known Participant
Oct 17, 2021 1:58 PM UTC
Question

processModel error

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

    pauls0008
    Known Participant
    Oct 17, 2021 3:49 PM UTC

    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

    nikhilau0001Author
    Known Participant
    Oct 18, 2021 5:01 AM UTC

    hi, 

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

    srimathig0001
    Participating Frequently
    Oct 18, 2021 5:21 AM UTC

    Use filter parameter within query entity

    csteward
    csteward
    Brainy
    Oct 18, 2021 2:54 PM UTC

    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