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