Hi All, I am trying to fetch data from Oracle DB using a query rule with batch size as -1, but the system is throwing the following error :
Expression evaluation error at function a!queryEntity [line 2]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [DataTypeName], query: [queryentity expression], order by: [[Sort[primaryKey asc]]], filters:[((Ts= TypedValue[it=9,v=3000-01-01 00:00:00.0]) AND (Valid= TypedValue[it=3,v=Y]))])
It had data of 147 rows and if I use batch size of 100 with start index 1 it's sometimes working but when I use startindex as 101 it's always failing with the above error.I am facing the same issue with some more tables from the same Oracle schema.Here I am attaching
a!queryEntity( entity: cons!DSE_TABLE_NAME, query: a!query( pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1, ) ), fetchTotalCount: true )
Discussion posts and replies are publicly visible
Did you check the tomcat stdout log file? I suspect this to be a timeout issue.
No I have not, but what I observed is that it's throwing error within 1 or 2 seconds only whereas when I tried with other table from the same Schema , which is having around 5k data , it took some time and gave results without erroring.Only for few tables (to be precise 5 or 6) are getting this error.And all tables are having same level of structure which includes working and non-working tables.