Expression Evaluation Error: An error occurred while retrieving the data

Hi,

Do all the types of the rule input used match the types of the expected expression? (Field has same type as input, no Multiple Variables when "=" or singles with "in")?

Hi Manam,

Sounds like a timeout which is unusual with the number of records in your view.

How long does the query take to execute before you see that error?

How many tables are included in the joins of your view?

How many rows do the source tables have for your view?

If your source tables have many rows you may have to evaluate the indexes you have/don't have in order to optimise the query filters you have.

You write "Do not see any error in the backend". Does this mean you checked the tomcat-stdout log file?

  From where can I check the tomcat-stdout log file? From System Logs?

Yes

 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)

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.

Unexpected error executing query... is mostly due to query timeout. The error is thrown when the query takes more time to retrieve data from database. 

Hi manam this error due timeout while retrieving the data from database, if you are trying retrieve the data from database view, remove some of the unused joins in the view and also add indexes for the columns. Using indexes will improve the performance of view while retrieving the data

Hi Manam,

Did you manage to fix the issue and what was the solution?