Skip to Content
0
Former Member
Nov 15, 2012 at 05:02 PM

SAP HANA (AWS) 'OUT OF MEMORY'

118 Views

Loading a few million rows into a table. Get :-

Could not execute 'CALL PUBS3.POPULATE_DAILY_SALES_BOOK (36500)'

[129]: transaction rolled back by an internal error: [129] PUBS3.POPULATE_DAILY_SALES_BOOK: line 39 col 2 (at pos 641): GenericFailure exception: transaction rolled back by an internal error: Out of memory $REASON$

I'm guess this is due to trying to generate 40 millon rows in one transaction. I guess if I break it up into multiple transactions I'll be OK.

However I'd have thought than HANA had plenty of space in memory for this table.

So my questions are :-

(1) How can I check what is consuming memory in HANA

(2) Dos HANA attempt to write data out to disk - i.e. free up memory - so that active transactions will NOT be rolled back? Is this configurable?

Cheers,

Chris