Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Memory allocation error when creating Tableau hyper file

ningwu
6 - Meteoroid

Hi community and happy new year

 

I have come across following error when I was trying to create a hyper file for Tableau. 

 

My machine has a 32MB RAM and I have tried all user settings, eg. setting memory limit to 200MB, but it still doesn't work.

 

Anyone has a fix on it?

 

Thanks 

 

Capture.PNG

 

6 REPLIES 6
Qiu
20 - Arcturus
20 - Arcturus

@ningwu 
How about check the 1855 warnings as a start?

AkimasaKajitani
17 - Castor
17 - Castor

Hi @ningwu 

 

I don't know how large of a file you have on your workflow, so I cannot determine if it is really a memory problem.

For example, you can set the "Connection Progress = Show" at the workflow configuration, so you will know the data quantity.

 

AkimasaKajitani_0-1609603672237.png

 

 

Please check these discussions.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Memory-allocation-error-when-publishin...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-when-quot-Output-Tableau-Hyper-f...

 

At there, two things are mentioned.

1. String type to change V_String( or V_WString)

2. long column name or really long strings problem

 

ningwu
6 - Meteoroid

 

 

Thanks for your reply.

 

I have tried to change all string types to v_string or v_wstring. But I still got the same error message.

 

the same workflow works fine on my colleague's machines, which they only have 16MB RAMs.

 

Is there any way for this problem?

 

Thanks 

AkimasaKajitani
17 - Castor
17 - Castor

Hi @ningwu 

 

If you consumption much memory by another application, Designer can't allocate enough memory.

When Designer allocate the enough memory, it show the below message.

 

AkimasaKajitani_0-1609648100351.png

 

Are you running a lot of applications or that consume a lot of memory ( like my Google Chrome ) on your computer?

 

 

ningwu
6 - Meteoroid

I have tried to close all other applications while I was running Alteryx.

But it did not work for me 😞

 

I have spent heaps of time trying to find a solution, but so far nothing works

AkimasaKajitani
17 - Castor
17 - Castor

Hi @ningwu 

 

I found the similar case. But the problem was not resolved.

As a workaround it seems to have been made to work by dividing to several separate chunks and create and add them.

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Memory-Allocation-error-writing-to-Tab...

 

Labels