Skip to main content
New Participant
April 15, 2025
Solved

Have a issue in record type, " Expression evaluation error [evaluation ID = a8853:4ed82] at function a!recordList_ui_design: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory lim

I have create a record type using a view, Which has more than a million data.

But in performance im getting the below error 
"Expression evaluation error [evaluation ID = a8853:4ed82] at function a!recordList_ui_design: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit.. (APNX-1-4198-000)"

    mathieud0001
    Genius
    April 16, 2025

    Your view is too slow. Make it faster [emoticon:c4563cd7d5574777a71c318021cbbcc8]

    That could mean adding indexes on the some of the underlying tables. You could also consider doing a materialized view:

    community.appian.com/.../use-database-and-materialized-views-in-appian

    3 replies

    davidj137213
    Brainy
    April 15, 2025

    Ant the question is? Seems that you are having a timeout  or memory problem with that query......

    mathieud0001
    Genius
    April 16, 2025

    Your view is too slow. Make it faster [emoticon:c4563cd7d5574777a71c318021cbbcc8]

    That could mean adding indexes on the some of the underlying tables. You could also consider doing a materialized view:

    community.appian.com/.../use-database-and-materialized-views-in-appian

    New Participant
    April 21, 2025

    Hi 

    I had created a materialized view on top the same view which i used, this solved my issue.
    im refreshing MV every 15 min.