Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
7 replies
Subscribers
8 subscribers
Views
4790 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Query Entity failing while using includes operator.
sparshs
over 8 years ago
I am using a query entity where for one of the filters i have used includes operator . When i pass some string pattern which is also present there in database to the filter where this includes operator is used it gives me the desired result but when i pass it some string pattern which is not there in database instead of returning null it returns me a appian runtime error but if i use equals operator i.e "=" in my query entity it will return me null datasubset. According my buisness requirements i have to use includes operator in my query, can someone help me with handling this appian runtime exception in my query entity while passing a string pattern which is not there in database.
OriginalPostID-244610
Discussion posts and replies are publicly visible
0
jorgea999
over 8 years ago
What's the runtime error?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sparshs
over 8 years ago
An error occurred while retrieving the data
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sachin
A Score Level 1
over 8 years ago
@sparsh could you attach the code snippet here
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 8 years ago
@sparshs as suggested above, it's better you provide your code snippet to have clear picture about what's happening
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sanjays0006
over 8 years ago
@sparshs,
I have seen this error when there is large amount of data returned from the query rule.
When there is a time out for the query rule, this error will be populated.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
abhinavg712
Certified Lead Developer
over 8 years ago
@ sparshs, can you share the logs when you are seeing the error "An error occurred while retrieving the data". As pointed by Sanjay above it can be timeout or huge data set being returned.
forum.appian.com/.../kb-1156.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 8 years ago
@sparshs i agree with @Sanjays if you can share the Code Snippet as well as the Log details about that error then it will be easy to understand and fix that error. However may i know this queryEntity is expected to return how many rows at a time
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel