Memory Allocation failure_HANA

[Anonymous]

Hi Guys,

I am getting below error while trying to connect to HANA database.

I tried with direct query and Import mode but still it is failing with memory allocation error.

Can anyone suggest what can be done from Power BI to improve the performance.

Error

DataSource.Error: ODBC: ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error:  [1000002] exception 1000002:
ltt/impl/memory.cpp:89
Allocation failed ; $size$=65536; $name$=compactcol; $type$=pool; $inuse_count$=440987; $allocated_size$=30420727512
exception 1000002:
ltt/impl/memory.cpp:89
Allocation failed ; $size$=65536; $name$=compactcol; $type$=pool; $inuse_count$=440986; $allocated_size$=30419547864

Details:
    DataSourceKind=SapHana
    OdbcErrors=[Table]

Thank you in advance

[amitchandak]

Refer

https://community.powerbi.com/t5/Desktop/Memory-Error-Allocation-Faliure/m-p/126494

https://community.powerbi.com/t5/Service/Memory-error-Memory-Allocation-failure/m-p/229420

Appreciate your Kudos.

[Anonymous]

I tried increasing memory of PBI but got below error message.

DataSource.Error: ODBC: ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error:  [2724] Olap temporary data size exceeded 31/32 bit limit
Details:
    DataSourceKind=SapHana

Any suggestion.

[rajendraongole1]

Try to allocate more memory in the Data Load tab. From Power BI dashboard, open Option > Data Load. Now increase the maximum allowed memory.

Kindly refer the below links.

https://windowsreport.com/memory-error-allocation-failure/