Interface Definition: Expression evaluation error in rule 'kt_qry_getanalystassignmentreport' at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [KT_VGenerateReportAnalystAssignmentDT23979], query: [queryentity expression], order by: [[Sort[NtdId desc]]], filters:[null])
Discussion posts and replies are publicly visible
Hi,
There are a few possible causes for this issue:
Yes, it’s pulling large data. Any suggestion to resolve this issue
use paging info.When you retrieve the query you can limit the data.
paginginfo: a!pagingInfo( startIndex: 1, batchsize:100 )
If you are providing batch size is -1 means it will retrieve all the data from the table.Use Filter option to filter the data as per your requirement.
I have given batch size 10 for interface .
Still same error is showing ?Did you check the code
Hi, There are multiple things you can do enhance your performance,
1. Try to use selection in your query, query only necessary columns
2.avoid using wildcase ("like","in") operators in filters
3.use proper batch size
4.check query execution time in database and see explain plan tab for explanation to see where delay is happening
One more thing, did you try to use queryrecordtype? I have seen querying record type is little faster than query entity.