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
Discussion posts and replies are publicly visible
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.
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.