Question

Expression Evaluation Error: An error occurred while retrieving the data

Forum|Forum|2 years ago
November 9, 2023
12 replies
0 views

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

gabriele.camilli

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")?

jordand0005

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.

stefanhelzle0001

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

manavik105Author

[mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] From where can I check the tomcat-stdout log file? From System Logs?

stefanhelzle0001

Yes

abhayd3663

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.

karumurua531442

Hi [mention:07380a99cd9a4931a32956f0ec3a7923:e9ed411860ed4f2ba0265705b8793d05] 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

rachid-valenting0001

Hi Manam,

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

stefanhelzle0001

As already mentioned here, in most of the cases this is caused by a timeout.

rachid-valenting0001

Yes, we found the timeout in our situation, we manage to make the processing time smaller on the view, from 22 seconds to 0.5 seconds, but the error message is the same.

Sign up

Login with SSO

Login to the community

Login with SSO