Hi,
the process instances are stucking ,while querying the data from a view . the error is coming as:
Expression evaluation error in rule!x, at fn!a!queryEntity18r3.An error occurred while retrieving the data.
The view is having around 51000 rows and 81 colums.Its loading time is around .8147 second and query rule is taking total 1133 ms for loading and then process stucks.
In logs, it is showing as:Statement cancelled due to timeout or client request.Please suggest.
Discussion posts and replies are publicly visible
There are certain limitations. Loading 50k rows into Appian feels not like being a good idea. This might give you a hint.
https://docs.appian.com/suite/help/20.3/Querying_Data_From_an_RDBMS.html#other
Did you check the Appian logs and process monitoring for error messages?
Hi Stefan,
the query execution time limit is 10 sec as per link given by you, but my query rule is taking 1607 ms =1.607 sec for execution,when I test the query rule, then it works fine, it gives me result in 1607 ms, but in process instance , where this rule is called, that instance stucked while running the process.
its gives error:
An error occurred while evaluating expression: =rule!x(y: rule!z(y: pv!y),y: pv!y) (Expression evaluation error in rule 'p' at function a!queryEntity_18r3 [line 9]: An error occurred while retrieving the data.) (Data Inputs)
In logs its saying as:
could not execute query
Statement cancelled due to timeout or client requestPlease suggest.
There is another limit
docs.appian.com/.../Configuring_Relational_Databases.html
What Stefan is referring to is this:
The amount of memory in bytes that will be consumed in the application server for a single query before the query is halted is configured using the following property:
conf.data.query.memory.limit=1048576
NOTE: Before changing this value, consider using the query paging parameter to return less data (or return data in batches) and therefore avoid the limit. Also, consider whether the entire set of data that is being returned is actually needed. If not, use the query expression functions to select which fields to return
The full text can be found here:
https://docs.appian.com/suite/help/20.3/Post-Install_Configurations.html#query-limits