Forum Discussion
Memory Allocation failure_HANA
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
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]
DataSourceKind=SapHana
OdbcErrors=[Table]
Thank you in advance
3 Replies
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.
