Skip to main content
Question

Dear celopeers, "SAP HANA error: cannot allocate enough memory."How can I use the partition dropdown appropriately for CDHDR / CDPOS in the extraction interface?

  • July 29, 2021
  • 1 reply
  • 15 views

matthias.ertl11
Level 0
Forum|alt.badge.img+4

I am currently trying to extract a large amount of data (CDHDR, 50+ GB) 

I am receiving the following error response:

"SAP HANA error: cannot allocate enough memory!. SAP DBTech JDBC"

 

The troubleshooting manual tells me to use the partition dropdown in the extraction UI.

Unfortunately, applying some of the columns (e.g. Changenr or the primary keys) gives me another error response that distinct values cannot be found in the selected fields.

1 reply

Forum|alt.badge.img+8

Hello Matthias,

 

the way to go would be to partition by a timecolumn, e.g. by month.

 

Best,

Bernardo