a!queryEntity: An error occurred while retrieving the data.

I am getting this error message when running a query entity rule for a view. The view itself only has 31 rows, and it takes .044 secs to execute on the DB side. I've verify the DS and everything is good. Reading through other posts, there were mentions of appian erroring out if the DB has a datetime field column with 0:00:00, but there are no datetime field in the view. I ended up querying the view one column at a time and found out 3 of the columns were causing the issue. They are just a text and number field. I've also query each table individually from which the views are joined on and everything runs fine also.  At this point I am not sure what else I can do to debug this issue, any suggestion is appreciated. Thanks

  Discussion posts and replies are publicly visible