Loading a few million rows into a table. Get :-
Could not execute 'CALL PUBS3.POPULATE_DAILY_SALES_BOOK (36500)'
: transaction rolled back by an internal error:  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?