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
7 subscribers
Views
7006 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 8 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
sikhivahans
over 8 years ago
@komalk Try as said by @allanb. If not, it would be worth finding out the location of the logs as per your Appian instance and then the application-server.log in them. Ideally it would be
/logs/application-server.log. To the best of my knowledge this will determine the root cause.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 8 years ago
@komalk Try as said by @allanb. If not, it would be worth finding out the location of the logs as per your Appian instance and then the application-server.log in them. Ideally it would be
/logs/application-server.log. To the best of my knowledge this will determine the root cause.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data