Skip to main content
Nintex Community Menu Bar
Solved

Apex heap size limit error when no data fits model criteria

  • July 11, 2024
  • 5 replies
  • 23 views

Forum|alt.badge.img+7

I have a model (well a few models) powering a Skuid page. As long as I have a record that fits my model criteria, everything works as expected. However, if no records meet my primary model’s criteria, I get an Apex Heap Size Limit error.

Any advice on pinpointing the problem or solving it entirely would be greatly appreciated!

Best answer by Skuidward_Tentacles

Some model conditions have a setting of “if no rows in source model, deactivate condition” or something along those lines. If you only have one condition on a model and it gets deactivated due to this setting, the model will try to load all records up to the record limit you are setting.
My guess is that you have a second model that is conditioned on the model you are questioning. So when this model doesn’t return rows, the other model’s condition is being deactivated and that second model is then trying to bring in all rows.

5 replies

Forum|alt.badge.img+17

Some model conditions have a setting of “if no rows in source model, deactivate condition” or something along those lines. If you only have one condition on a model and it gets deactivated due to this setting, the model will try to load all records up to the record limit you are setting.
My guess is that you have a second model that is conditioned on the model you are questioning. So when this model doesn’t return rows, the other model’s condition is being deactivated and that second model is then trying to bring in all rows.


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

Yup - what the Skuidward said… That’s where I’d start.


Forum|alt.badge.img+7
  • Author
  • Rookie
  • July 12, 2024

Thanks Rob, I’ll give the advice a go and report back…


Forum|alt.badge.img+7
  • Author
  • Rookie
  • July 12, 2024

Thanks ST! I’ll let you know how it goes


Forum|alt.badge.img+7
  • Author
  • Rookie
  • July 12, 2024

Solved it - thank you! For anyone else, this is in Condition under the Model, then you click on the ‘value’ section and you’ll find the setting for ‘If no row in source model, then…’ and you select ‘Abort this model’s query’.