Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Out of Memory

Hi Everybody

I have a issue with  HANA when I try to load 300,000,000 of rows from Sybase with smart connection, the process starts and it is taking 3 hours  when it got all the rows it doesnt insert the rows to the table  and  it creates other process with the same select to the  table and  makes that hana  memory goes uncontrollably upward.

I kill the first process and the second is closed too.

When I try again the console throw me this error

Could not execute 'insert into "HN_DWHEXP_PF"."FACT_PF_CUENTA_HIST" select * from ...' in 3:48:13.393 hours .

[129]: transaction rolled back by an internal error: exception 1000002: Allocation failed ; $size$=2048; $name$=Pool/RowEngine/QueryExecution; $type$=pool; $inuse_count$=3527478; $allocated_size$=3668626752; $alignment$=16

Please anyone that could help me


Not what you were looking for? View more on this topic or Ask a question