Out of Join Memory

Question

Hi All,

I've been running a workflow regularly, with success, on an Alteryx server but last night it failed with the following message from the server.  Note that the "join" that exists, simply does a record position join, so I didn't think it would use much memory.  Can anyone recommend a setting that could correct this?

Mark

LordNeilLord · Answer

@MarqueeCrew I'm gonna look like such a legend when I quote this to the it guys on Monday

MarqueeCrew · Answer

@flipperdm,

general rule

for an appropriate setting is to be ½ the amount of system memory available,
divided by the number of simultaneous workflows allowed to run.

flipperdm · Answer

@MarqueeCrew they told me that they ave 4164MB of memory on the server.  I will suggest looking at the engine/sort/memory as I have not had an issue running this workflow locally on my laptop.