Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Extract Big Tables using tDBInput

Hi Guys, 

I need help to solve this problem I'am getting when I try to put data from a tDBInput to a tFileOutputDelimited.

I got this error:

Error: java.lang.OutOfMemoryError: Java heap space 

 

The table I'am trying to extract has about 50 millions of rows (postgresql), I've already tried giving the max to -Xmx but still don't work. Is there any workaround please? 

 

Thank you for your help

Labels (1)
  • v7.x

1 Reply
manodwhb
Champion II
Champion II

I suggest you that you need to try for different combination values and need to see is it giving error or not.

Increase to more and see and those values are based on your RAM size ,you need to set those.