Out of Memory despite setting adjustment

Question

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

B

franc1s · Answer

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

fluteman · Answer

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!

Jon-Knepper · Answer

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.