Expression Evaluation Error: An error occurred while retrieving the data

Certified Associate Developer

Hi All,

When trying to filter using a dropdown, getting below error:


Do not see any error in the backend,
data store is published successfully
also there are less than <10 records in the database so dont think of performance issue.

please advise in which logs can I check this error to debug:

Expression evaluation error [evaluation ID = abc7a:61357] in rule 'rmo_rule_getticketqueueview' (called by rule 'rmo_frm_ticketqueue') : An error occurred while retrieving the data.
Details: Unexpected error executing query (type: [RMOVWticketQueueDT29056], query: [queryentity expression], order by: [[Sort[implementerStatusPriority asc], Sort[isSameDayImplReq desc],
Sort[cutOffTime asc], Sort[urgency desc], Sort[ticketTypePriority asc], Sort[slaDateTime asc],
Sort[ticketId asc]]], filters:[((status in TypedValue[it=103,v={RS20}]) AND (isWithdrawn is null)
AND ((isGLConfirmed is null) OR (isGLConfirmed = TypedValue[it=1,v=1])) AND ((isConfidential = TypedValue[it=1,v=0]) OR ((isConfidential = TypedValue[it=1,v=1])
AND (submittedBy = TypedValue[it=4,v=manakumar])) OR ((isConfidential = TypedValue[it=1,v=1]) AND (roleAssigned = TypedValue[it=3,v=ET27]))
OR ((isConfidential = TypedValue[it=1,v=1]) AND (submittedBy = TypedValue[it=4,v=manakumar]) AND ((roleAssigned = TypedValue[it=3,v=ET25]) OR (parentRoleAssigned = TypedValue[it=3,v=ET25])))))])

  Discussion posts and replies are publicly visible

Parents Reply Children
  • 0
    Certified Associate Developer
    in reply to Stefan Helzle

     I see below error in tomcat_stdout log: Could you please advise? 

    Caused by: com.appiancorp.core.expr.exceptions.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error [evaluation ID = 93ae1:2e55b] in rule 'rmo_rule_getticketqueueview'
    (called by rule 'rmo_frm_ticketqueue') at function a!queryEntity [line 4]: An error occurred while retrieving the data. Details:
    Unexpected error executing query (type: [RMOVWticketQueueDT29056], query: [queryentity expression],
    order by: [[Sort[implementerStatusPriority asc], Sort[isSameDayImplReq desc], Sort[cutOffTime asc],
    Sort[urgency desc], Sort[ticketTypePriority asc], Sort[slaDateTime asc], Sort[ticketId asc]]],
    filters:[((status in TypedValue[it=103,v={RS20}]) AND (isWithdrawn is null)
    AND ((isGLConfirmed is null) OR (isGLConfirmed = TypedValue[it=1,v=1]))
    AND ((isConfidential = TypedValue[it=1,v=0]) OR ((isConfidential = TypedValue[it=1,v=1])
    AND (submittedBy = TypedValue[it=4,v=mvarma])) OR ((isConfidential = TypedValue[it=1,v=1])
    AND (submittedBy = TypedValue[it=4,v=mvarma]) AND (roleAssigned = TypedValue[it=3,v=ET27]))
    OR ((isConfidential = TypedValue[it=1,v=1]) AND (submittedBy = TypedValue[it=4,v=mvarma]) AND ((roleAssigned = TypedValue[it=3,v=ET25]) OR (parentRoleAssigned = TypedValue[it=3,v=ET25])))))]) (APNX-1-4198-000)

  • 0
    Certified Lead Developer
    in reply to manam

    There is not a single hint on what the issue could be. I suggest to reduce the complexity until you get it working. Then add back things step by step to identify the issue.