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.
1 Download ddl check all the query is
working fine or not
2- create new test expression rule and only pass query and paging info do not do any calculations if you get same errors then problem would be in data base side or the constant which holding the entity
3 - check the datatype whether the entity is added on the Data store or not
Just faced this error a day ago in my code. Try to check the rows you're trying to retrieve. There are one or multiple null values in the DB which shouldn't be null. Once you add some dummy values to them (to verify this is the issue), it should work fine.
Tried all ways , it’s still throwing error