Skip to main content
Nintex Community Menu Bar
Question

Query of LOB fields caused heap usage to exceed limit.

  • July 10, 2024
  • 3 replies
  • 658 views

Forum|alt.badge.img+8

I have no idea what this error means. f6a8956407caefad1c61d4fc1a59ce7fb5ceaf61.png Can anyone explain me what this means? How to solve this error?

This topic has been closed for replies.

3 replies

Forum|alt.badge.img+11
  • July 10, 2024

Can you check your model set ups on your page - do you have conditions to limit the query?  Number of records being pulled limited (not blank?)  You can search this community on heap size errors and find lots of other tips.


Forum|alt.badge.img+10
  • Nintex Employee
  • July 10, 2024

Chandra is right in mentioning that there are a good number of discussions on the Community here regarding heap size errors.

This heap size error generally means that your Skuid page was trying to pull too much data. Salesforce currently limits this to around 6 MB. This limit can be reached if you’re trying to pull too many fields into your model, or too many records, or both. The rule of thumb is to only pull the fields and records your users will need. Long text fields can sometimes drive up the size of the query quite a bit too. If you’re able to set a condition on your model, like Chandra suggests, to only pull “active” records" for example, that can help a great deal.

Here is an in-depth guide that will help with page performance. You’ll see in that guide that other things like filters and searches can cause this kind of issue too, if they’re especially resource-intensive.

There’s also a scenario related to file attachments that can cause this error to appear, which was just discussed on this Community post. You can see my response towards the bottom.


Forum|alt.badge.img+8

Thank you very much. I adjusted few fields and removed unwanted fields from the model. this itself solved the error