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
Parents
0
sonalk
over 9 years ago
Hi Komalk,
If the table already exists, try doing impact analysis for the CDT which is being used in the constant in another environment where you are facing the issue. Sometimes if the CDT is not imported properly following the best practice then such issue can arise.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sonalk
over 9 years ago
Hi Komalk,
If the table already exists, try doing impact analysis for the CDT which is being used in the constant in another environment where you are facing the issue. Sometimes if the CDT is not imported properly following the best practice then such issue can arise.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data