Skip to main content
G
gaganpreetk0002
April 1, 2022
Question

facing this errotr in the user ineterface

  • April 1, 2022
  • 9 replies
  • 0 views

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])

    9 replies

    arockiaprincyv0003
    arockiaprincyv0003
    April 1, 2022

    Hi,

    There are a few possible causes for this issue:

    • There is a lock on the database.
    • There is too much data being pulled back.
    • The query timed out.
    G
    gaganpreetk0002Author
    April 1, 2022

    Yes, it’s pulling large data. Any suggestion to resolve this issue

    arockiaprincyv0003
    arockiaprincyv0003
    April 1, 2022

    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.

    P
    parthy0001
    April 3, 2022

    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

    harshitb6843
    harshitb6843
    April 3, 2022

    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. 

    G
    gaganpreetk0002Author
    April 5, 2022

    Tried all ways , it’s still throwing error

    Terms & ConditionsAccessibility statement