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
Can you shed more light on the three columns that are causing the issue? What type of values do they contain? And what is the nature of the view (how are joins configured, etc). The database type (if not mysql) may also help diagnose....
Hi xingc753
You can check a couple of things:
1) Make sure the view structure (column types) and the cdt column types and size are in line
2) Sometimes when you join tables, subqueries might return some multiple rows which won't get detected in the view unless you apply some filter to fetch the records in the view in DB. In that case as well, you can get similar error from Appian.
It turns out the issue is with how the columns are joined on.