HANA SQL Alteryx Workflow execution Error

Question

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 Answer

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

afv2688 · Accepted Answer

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 Answer

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