Hi,
I am trying to fetch data from a View to an interface through a query entity to create a report. The view is giving the right data while i check it on SQL developer but gives the error "
Expression evaluation error [evaluation ID = 2MJH3KMT] in rule 'abc_report' at function a!queryEntity_18r3 [line 13]: An error occurred while retrieving the data." on the report interface. I have modified the data type and publish the data store yet facing this issue. What could be the cause? Please help!
TIA!
Discussion posts and replies are publicly visible
The most common root cause of this not very helpful!) error message is that you have a date or a datetime that is set to something like '00-00-0000:0000'. That's the very first thing I check when I see this message.
Your database VIEW will quite happily show you this data but Appian throws this error when it tries to ingest the data.