Memory Circuit Breaker

Question

We had an interface, while loading the interface in the flow sometimes we are getting Memory Circuit breaker error and we could not able to move forward as we cannot click anything on interface. We already optimized the code to maximum extent. Is there any way that we can show that error in separate section which will not block the interface, so that we can move forward by clicking on submit button

Stefan Helzle · Accepted Answer

No. You will have to modify that interface so that it takes less memory.

Stefan Helzle · Answer

Sorry, but no.

Stefan Helzle · Answer

Appian is not made to handle "huge" files in memory. You either have to limit file size, or find a different way of implementation.

Stefan Helzle · Answer

One issue with your approach is, that you store the whole data three times in different local variables. This will not help reducing memory consumption. 
 But, in general, you have to make sure that these files stay within certain limits. In case that's not an option, you will have to find a different way to do, what you need to do.

Harsh Kumar Agarwal · Answer

You can try the following approach: 
 
 Instead of handling these large files in SAIL take help of database.
 
 You can create a staging/temporary table in the databse to store data of these files. 
 Load data of files into these tables. 
 if data volume is large you can take help of batching.

It will be easy to create/maintain grids from database. 
 Instead of loading all the rows in the local variable, only load limited rows you are displaying in a page. You can achieve it keeping paginginfo same for local of datasubset and paginggrid. 
 The logic for comparing rows from first file to another you can build on database side using view, materialized view or SP.

Memory Circuit Breaker

Top Replies