Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Out of Memory despite setting adjustment

7 - Meteor

Hi All,


I am uploading a small volume of data (22 rows and 8 columns to be precise) into a SQL database.  I keep getting an 'out of memory' message.  I have already played around with the user settings and increased the memory limit to 1024 MB.  Has anyone else ever come across this and how did you resolve?


Many Thanks



10 - Fireball

@Bushra_Akhtar  What is your machine's memory? normally Alteryx will use 25% (1/4) of the memory limit.

8 - Asteroid

I have the same issue. Did you reach a solution for this yet?

8 - Asteroid

I actually was able to resolve this. The issue was that the Alteryx data types were bigger in size as compared to the database dtypes. So, just ensure they're the same size and re-upload. 

8 - Asteroid

I actually just encountered this error and resolved it.  The reason the error was popping up for me was that there was a join where records were null records were continually joining.  I didn't realize it until I saw how big the record count was getting.


Something to check just in case you have a data set that has null records potentially joining to other null records and creating a large Cartesian issue.

8 - Asteroid

This was the solution; not the other speculative garbage.


In SQL, look at your table you are "inserting into"; use script to create table statement to get the schema. Make sure in a preceding Select tool, you match the datatype and length exactly.


This worked for me!

8 - Asteroid

My problem was not using the select tool to align field width to the database field width. Thanks @fluteman