I have created Expression rule with queryEntity() function. It connects with dis

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
  • @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.
Reply
  • @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.
Children
No Data