Skip to main content
udayasain741
May 24, 2021
Question

Unexpected error executing query

  • May 24, 2021
  • 2 replies
  • 0 views

Hi Team,

Please find attached 

I am using the rule in my process and it fails sometimes, can i know is something issue due to connection or something issue in code

How we can avoid this issues

    2 replies

    csteward
    May 24, 2021

    These errors are very often due to either the size of the data set you are trying to return, or performance on the view. 

    When the query fails, does it work the second time if you simply restart the node later?

    How much data are you expecting when it errors? 

    How does the view perform when calling it directly on the database? 

    Are you / do you need to set fetchTotalCount to true? 

    If you can share your queryEntity call that may assist as well.  

    mikes0011
    Brainy
    May 24, 2021

    In addition to what Chris already said, sometimes funky data in the DB can cause a similar query error (i forget if it's this specific one or something just sorta simiar).  The easiest thing to check is that there aren't any dates in the DB as "0000-00-00"; they either have to be NULL or a real(ish) date.

    The Expression Guru