Skip to main content
Inspiring
Nov 30, 2022 12:31 PM UTC
Question

Expression Evaluation Error while retrieving Data from Oracle SQL

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
Nov 30, 2022 1:37 PM UTC

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?

Inspiring
Nov 30, 2022 1:44 PM UTC

Yes it is a View

stefanhelzle0001
Brainy
Nov 30, 2022 1:45 PM UTC

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