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
Please check logs to see what is the exact error message that is written in log.Maybe one of the following reason.Default time out configured for query in custom.properties file.Default memory size to hold the data in the application server configured in custom.properties file.
Adding to the above,
1. Please give a batch size of 5 and execute a query. If there is no error now, then the amount of data you are trying to retrieve is the issue. You can fix that by querying the necessary data to show in the report grid on the first page.
Also, please try optimizing the view to get better results always.
Thanks,
Sree Devi J R
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.
Whenever this kind of issue occurs via view things to check are
1. How much time the view is taking in DB and in Appian while fetching,
2. Is the date fields are coming correct with proper format.
3.Is the query limit of 1 MB of data or time to fetch which is 10 seconds is exceeding. if so try getting the data in batches using the pagination.
4. Mostly check the indexes to the tables which can improve your query performance and also check the unnecessary joins