An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit. (APNX-1-4198-000)

Question

Hi All, 
 I am encountering the error mentioned in the subject whenever I try to open the summary of one of the requests. 
 In the record view, we have configured the following expression: 
 rule!summary_interface(record: rule!qry_record()). 
 Note: When I switched from rule!qry_record to rv!record, the error disappeared. 
 Initially, we suspected that the issue was caused by a large dataset. To address this, we reduced the query size to ensure it evaluates within 50ms. However, the error persists. 
 To investigate further, I opened the summary interface object and tested it by passing the query rule directly. When I clicked "Test Object," it loaded without any errors. However, when I opened an unnamed interface and invoked the interface using the expression: 
 rule!summary_interface(record: rule!qry_record()), the same error occurred. Also in error message , its specifically mentioned about one child interface which just shows grid data around 20 items. If i remove this interface from summary view, we are not getting error. Again here as well I tried to do object level test for that request and its loading without any error. 
 
 Did anyone face this issue? 
 Thanks,

Varun Teja Gurrapu · Answer

Hi Vaishal , Here the Issue is the Expression Rule you are returning taking much time to retrieve the data, inorder to ignore performance issues, you need to optimize the query by adding paging/limiting the data. You are also passing whole records from the previous sync into rule input of that rule as i see there is no identifier. You need to write a query rule while passing the rv!identifier as a rule input to that rule inorder to get only specific records. rule!summary_interface(record: rule!qry_record(id: rv!identifier)) I suggest you to use rv!record as it helps us to use 100 related records instead of manually writing rules. Please check - https://docs.appian.com/suite/help/25.1/reference-records.html#use-rvrecord

Harsha Sharma · Answer

As per the error it looks like your grid containing chid rule might be causing this. Check the record configured to get data for the grid as well as the grid configurations. Without seeing the grid code, I can only guess that the record configured for grid data might be exceeding memory threshold intermittently. 
 Directly I dont see how the rule!qry_record() or rv!record impact this child interface. Anyway its best to use rv!record instead of querying the entire record. 
 For future maintenance check the grid rule and underlying code to identify if column selection, filters etc are performance effective or not.