Hi All,
While running the Query entity. Facing this issue.
a!queryEntity( entity: cons!ABC_DSE, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 10 ) ), fetchTotalCount: false)
Exception:
Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [DECOMITSMNetworkDT11134], query: [queryentity expression], order by: [[Sort[computer_id asc]]], filters:[null])
Is there any log file where i can get more details?
Note: Retrieving data from Oracle.
Regards,
Nishtha Bhatnagar
Discussion posts and replies are publicly visible
Hello Nishtha Bhatnagar,
Is it possible for you to check whether the connection is established properly between your data source and Appian.
Connection is fine. Its successful. It is a view from which I am trying to access data.
Check your tomcat-stdOut.log file for additional information. Is this a view or table, and does a manual query perform decently when you run directly against the DB?
EDIT: Sorry I see you noted view - curious on the performance of the view as this can lead to the error message you posted here.