Skip to main content
nishthab0001
nishthab0001
January 12, 2023
Question

Query Entity Error

  • January 12, 2023
  • 3 replies
  • 0 views

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

    3 replies

    konduruc733182
    konduruc733182
    January 12, 2023

    Hello nishthab0001,

    Is it possible for you to check whether the connection is established properly between your data source and Appian.

    nishthab0001
    nishthab0001Author
    January 12, 2023

    Connection is fine. Its successful. It is a view from which I am trying to access data.

    csteward
    csteward
    January 12, 2023

    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.

    Terms & ConditionsAccessibility statement