Skip to main content
nishthab0001
Participating Frequently
Jan 12, 2023 10:08 AM UTC
Question

Query Entity Error

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
    Inspiring
    Jan 12, 2023 10:28 AM UTC

    Hello nishthab0001,

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

    nishthab0001
    Participating Frequently
    Jan 12, 2023 10:30 AM UTC

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

    csteward
    Brainy
    Jan 12, 2023 5:10 PM UTC

    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.