Skip to main content
November 30, 2022
Question

Expression Evaluation Error while retrieving Data from Oracle SQL

  • November 30, 2022
  • 6 replies
  • 0 views

While querying the Entity whatever the first Start index (startindex:1, Batch Size: 20) mentioning up to that only i was able to get the data.

When i am trying to increasing the start index > 1 (startindex:21, Batch Size: 20) getting the below error 

Errors in Expression: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [COTAAuditRequestRDT14171], query: [queryentity expression], order by: [[Sort[request_id asc]]], filters:[null])

6 replies

stefanhelzle0001
Brainy
November 30, 2022

In your screenshot I see that your first call already takes almost 8 seconds. I expect that the second one runs into a timeout. Is that a view your try to query?

November 30, 2022

Yes it is a View

stefanhelzle0001
Brainy
November 30, 2022

Then this is a timeout issue and you need to drastically improve the performance of your view.