Sharepoint Output tool out of memory

Question

I recently installed the sharepoint output tool to alteryx and am getting error (Out of memory: malloc of size 16777216 failed). The sharepoint tool outputs to a csv file with around 11.5 million rows being outputted. I've increased the default memory in designer to 12,000mb and I've also noticed that my computer's memory usage gets up to around 97% at it's peak while running the workflow. Has anyone else encountered this issue?

Ean123 · Answer

I have one column that produces null values, did you replace nulls to fix the issue? I haven't replaced them yet, but I re-ran the workflow and am now getting this error: (SharePoint Output (84) Unable to allocate 3.94 GiB for an array with shape (46, 11499577) and data type object)

Aryasuta_Panda · Answer

Hi, Can you please check if your data contains huge null values or any join tools are used and they give null values.

Coz, I had faced same kind of issue .

Thanks