HANA SQL Alteryx Workflow execution Error

[RAHULMISHRA]

I am running a Alteryx workflow with data retrieval from HANA using SQL and ALteryx tool. The error I am getting is as follows:-

Error: Data Stream Out (9): Error SQLExecute: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: column store error: search table error:  [9] Memory allocation failed (please check lines: 7)

What is this error due to? What is the reason for this error? How can I rectify it?

[RAHULMISHRA]

I am running a Alteryx workflow with data retrieval from HANA using SQL and ALteryx tool. The error I am getting is as follows:-

Error: Data Stream Out (9): Error SQLExecute: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: column store error: search table error:  [9] Memory allocation failed (please check lines: 7)

What is this error due to? What is the reason for this error? How can I rectify it?

[afv2688 · Accepted solution]

Hello @RAHULMISHRA ,

The fact that it says memory allocation issue makes me thing there is a problem with the RAM allocation of your computer.

Are you running multiple workflows at once? You have to remember that the total amount you should use for Alteryx is at max half of your pcs RAM.

For example: 16GB Total then 8GB at max

Regards

[RAHULMISHRA]

Please advise what needs to be doe as errror is in Data stream out? @VitekZ  Please suggest what needs to be done?

[RAHULMISHRA]

Hi @afv2688 ,

In Task manager, The alteryx memory consuption is less. Please advise what needs to be done?

Thanks,

Rahul Mishra

[afv2688 · Accepted solution]

Hello @RAHULMISHRA,

How many rows are you trying to download to the alteryx designer?

Once you stream out data is stored in your machine. I would recommend you to try to reduce the amount of rows by filtering out as many rows as possible. Reducing the total size that you want to stream out should do it.

Regards

[danilang · Accepted solution]

Hi @RAHULMISHRA 

From the text of this message, it looks like it could be an error in the SAP HANA database as opposed to Alteryx.  If you search for "General error;2048 column store error: search table error: column store error: search table error:  [9] Memory allocation failed (please check lines: 7)" you'll find a series of responses on the SAP site dealing with this.  This one suggests ways to limit your search sizes 

Dan