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
7694 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
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
0
sikhivahans
over 9 years ago
@komalk Thanks for mentioning the log data. Apologies that I am not aware of this issue and that's why I am not making any further comments. But I would like to suggest to wait for a good suggestion re this problem as I don't think that it is due to exceeding query limits or a problem with the cdt(Assuming that Appian and database environments of both the instances are in sync). It could be something like as said by @narasimhaadityac. Please do update the post if the issue is resolved.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
vikask146
over 9 years ago
Couple of steps would like to test : 1. Is this only CDT giving problem, what about others CDT or tables ? I mean for other processes.
2. If it is specific to CDT then please attach CDT XSD and if this issue is for all then check your pre-defined data source name configuration in file to correct mapping and its privileges with the help of DBA.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
komalk
over 9 years ago
Thanks to all of you for your useful comments. Issue is resolved now. Database was missing higher synonyms. Thanks again!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@komalk Thanks for the update. Seems like @narasimhaadityac is spot on.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<