Error : Java heap Space

I have 98 columns/fields and 250,000 rows, every time I run it always error, what i'm doing now is to reduce the :
Max Batch Size (Records) = 10
Max Clob Size (Characters) = 10
Max Blob Size (Bytes) = 10
Fetch Size = 10
because the default is 1000 and an error will occur. How to handle that problem?


Best answer by Pradeep 30 May 2023, 15:30

View original

2 replies

@Pradeep I have up the memory from 1024mb to 8192mb and it works very well, thank you

Userlevel 3
Badge +1

@realmatcha You can either reduce the batch size which you are currently working around with or increase the heap memory given to the related streamsets engine.