JAVA heap space error

[Anonymous]

Hi,

I'm trying to copy 12lacs - 15lacs records from one mysql database table to another mysql database table  using talend, then I'm getting java heap space error.

Please guide me how to resolve this (I can't increase my java heap space)

Thanks,

P.Nehru.

[Anonymous]

Hello,

Are you able to allocate more memory for your studio?

Could you please take a look at this article:https://community.talend.com/t5/Migration-Configuration-and/Allocating-more-memory-to-Talend-Studio/...?

Best regards

Sabrina

[Anonymous]

Hi,

we build all these jobs in our local machines and will deploy or setup the same in another remote machine (There is no studio in the remote machine)

Thanks,

P.Nehru.

[ThWabi]

Hi Nehru,

maybe one or more of these suggestions can be useful for you.

- Enable streaming in your database input component.

- Enable extent insert and set extent size and commit size in your database output component.

- If you use a tMap component, try to adjust the buffer size.

Best regards,

Thomas

[Anonymous]

Thanks Thomas, will try this.