Forum Discussion

ramkula123's avatar
ramkula123
Icon for Helper I rankHelper I
7 years ago
Solved

Error - Out of memory

Hi All ,   I am trying to connect to SAP HANA source from PBI desktop and I am getting the following error :     I am able to preview the data , but it throws error while loading it . Plea...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    Hi ramkula123 ,

     

    If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

     

    Best regards,

    Dina Ye

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi ramkula123 

 

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/

 

Best regards,

Dina Ye