Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Verified Answer
+2
person also asked this
people also asked this
Replies
16 replies
Answers
1 answer
Subscribers
9 subscribers
Views
21882 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Error occurred while retrieving the data.
Soumya.Behera
over 8 years ago
This is my expression rule:-
a!queryEntity(
entity: cons!SSB_IAL_EMP_DETAILS_VIEW,
query: a!query(
pagingInfo: a!pagingInfo(1, -1)
)
)
The error I'm getting-
Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data.
I've attached a file with XSD and MySQL query for View definition. I have seen few earlier questions related the same issue and followed the solutions. Tried recreating everything again. But the challenge persists. Let me know the solution please.
In case you are wondering, yes the id column consists of unique values.
OriginalPostID-238664
details.txt
Discussion posts and replies are publicly visible
Top Replies
Fredrick Omeniho
over 4 years ago
+6
verified
Hey All, I am just very new in Appian, 2 weeks to be specific but I am not new to application database nor database development - 18 years experience as of today. I encountered this problem today with…
Parents
0
narasimhaadityac
A Score Level 2
over 8 years ago
Hi, could you please rename the ID column, I think Appian by default reserves this column.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
narasimhaadityac
A Score Level 2
over 8 years ago
Hi, could you please rename the ID column, I think Appian by default reserves this column.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data