Unexpected error executing query

Question

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

Mike Schmitt · Answer

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.

Chris · Answer

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.

Unexpected error executing query

Top Replies