Forum Discussion

powerEDCE's avatar
powerEDCE
Frequent Visitor
4 years ago
Solved

Importing data from SAP database -> cannot allocate enough memory

Dear all,   I have frequent problems when trying to import larger data sets from an SAP data base with Power BI.   I get this message:   DataSource.Error: ODBC: ERROR [S1000] [SAP AG][LIBODBCHD...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi powerEDCE ,

It seems related to the memory requirements, generally, to satisfied the memory requirements you should double the amount of data. That means I would provision a server with 128 GB if I have the 64GB instance.

 

You can refer to the blog about sizing HANA databases: https://blogs.sap.com/2017/03/07/the-ultimate-guide-to-effective-sizing-of-sap-hana/

 

Also, here’s another case similar with yours for your reference: https://answers.sap.com/questions/11364223/sap-dbtech-jdbc-4-cannot-allocate-enough-memory-ou.html

 

Tips for avoid the error: https://blogs.sap.com/2014/01/05/6-tips-to-avoid-hana-out-of-memory-oom-errors/

 

And you could test  "Get data" -> "SAP HAHA database" -> Type your server name -> open "Advance options" and type SQL statements to filter data.

 

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien