Skip to main content
V
vikrams247
July 6, 2021
Question

Summary view error

  • July 6, 2021
  • 1 reply
  • 0 views

Hi All,

i am getting following error on my summary view.

Error Evaluating UI Expression Expression evaluation error [evaluation ID = EEBZL4J1] in rule!APN_qry_xyz at function a!recordBodyWrapper: An error occurred while retrieving the data. Details: Cannot open connection (APNX-1-4198-000)

I can see rest of my code(expression rule, qry rule, interfaces, integration and all other objects) working fine except summary view.

Kindly help me.

Thanks in Advance.

    1 reply

    gayathris111098
    gayathris111098
    July 6, 2021

    https://community.appian.com/support/w/kb/299/kb-1074-cannot-open-connection-caused-by-javax-resource-resourceexception-no-matching-credentials-in-subject-error-thrown-during-jboss-startup
    https://community.appian.com/support/w/kb/373/kb-1156-an-error-occurred-while-retrieving-the-data-error-thrown-when-accessing-a-record-that-queries-a-database
    https://community.appian.com/support/w/kb/1103/kb-1681-unable-to-retrieve-data-due-to-query-timeout

    Did you get a chance to look in to logs to see what is the exact error message that is written in log? The above error message is a generic one in log you can find detailed error.
    There are a few possible causes for this issue:
     1. There is too much data being pulled back( max 1MB).
     2. The query timed out(Max 10).
     3. There is a data error on the database(date format error).

    First, consider whether the entire set of data that is being returned is actually needed. If not, use the query expression functions to select which fields to return.
    Second, use the query rules paging parameter to return less data (or return data in batches) and therefore avoid the limit.
    Third, If these solutions still do not meet the requirements of the use case, consider the number of concurrent query rules that are expected in the system and the amount of free memory available on the application server.
    Fourth, If above things does not works, then change the maximum amount of time in seconds that a query waits for a response from the database before timing out and change the amount of memory in bytes that will be consumed in the application server for a single query before the query is halted.

    community.appian.com/.../81554

    Terms & ConditionsAccessibility statement