query

Question

this error am getting how can i fix this 
 am querying this data to display in grid, is their any other way to display the data ?

Stefan Helzle · Answer

You just can't load that much data into an interface. See here: https://docs.appian.com/suite/help/24.4/Memory_Circuit_Breaker.html

Mike Schmitt · Answer

If that query is intended to be run while one or more of the filtering options have a value (which we can see are loaded as blank initially), you should probably prevent the query from executing at all until at least one of the filters is given a value, since (per your error message) the non-filtered query is returning enough data to trip the mandatory 1-megabyte query circuit breaker. Either that or initially run the query with a "real" batch size (instead of the "all rows" batch size of -1).