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
15 replies
Subscribers
8 subscribers
Views
7704 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I have created Expression rule with queryEntity() function. It connects with dis
komalk
over 9 years ago
I have created Expression rule with queryEntity() function. It connects with distant database, and fetches data.
The rule works fine in dev environment. but it fails in another environment.
I tried publishing datastore for entity: MY_PROJECT_CUST
Rule is:
a!queryEntity(
entity: cons!MY_PROJECT_CUST,
query: a!query(
selection: a!querySelection(
columns: {
a!queryColumn(
field: "CUST_ID"
),
a!queryColumn(
field: "CUST_NME"
)
}
),
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: - 1,
sort: a!sortInfo(
field: "CUST_NME",
ascending: true()
)
)
)
).data
I am getting error:Expression evaluation error at function a!queryEntity [line 2]: An error occurred while retrieving the data.
OriginalPostID-187384
OriginalPostID-187384
Discussion posts and replies are publicly visible
Parents
0
vvravikumarl
over 9 years ago
Hi Komal,
We'll get this kind of issues generally either when we have some wrong data into database or if we have huge amount of data. This works fine in dev because in dev environment we'll have limited data. Check the data you are trying to fetch is in right format or not and also the total number of records.
Hope this helps...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
vvravikumarl
over 9 years ago
Hi Komal,
We'll get this kind of issues generally either when we have some wrong data into database or if we have huge amount of data. This works fine in dev because in dev environment we'll have limited data. Check the data you are trying to fetch is in right format or not and also the total number of records.
Hope this helps...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data