unable to retrieve data - batchSize

Hello,

we have a problem using the attached rule, note that the value for batchSize is 10.

The following error message appears:
Error evaluating expression [....] in rule [...] at function queryEntity [line 3]. An error occurred while retrieving data
 
The entity being queried is a VIEW in the SqlServer database, and this view contains about 68.000 rows

In the tomcat-stdOut.log  we found the following rows:

2021-05-05 13:12:52,416 [ajp-nio-8009-exec-9] ERROR org.hibernate.util.JDBCExceptionReporter - The query has timed out.
2021-05-05 13:14:20,013 [Timer-4] INFO  com.appiancorp.cache.sail.StatefulSailCacheImpl - Stateful SAIL db cache cleanup process executing...removing expired entries from                                                      db
2021-05-05 13:14:20,013 [Timer-4] INFO  com.appiancorp.cache.sail.StatefulSailCacheImpl - Stateful SAIL current memory cache entries=2 size=40214 bytes

Looking in the custom.properties file we found that the parameters are  configured this way:

conf.data.query.timeout=10
conf.data.query.memory.limit=1M

If we change the batchsize to 11 or also to 9  this rule works (I tried many times to change these values).
I can not understand why this change in batchSize is causing a total different result, by the way the aggregation in the rule can not return more than 10 items.

Could you please give me a direction or an hint for that?

Thank you in advance, best regards.

Paolo

[View:/cfs-file/__key/communityserver-discussions-components-files/16/query1.txt:320:240]