Java heap space occurred with using tFileOutputExcel.

Highlighted
Five Stars

Java heap space occurred with using tFileOutputExcel.

Hi,
I am using V5.6.1 on Windows x86, and now clash job with Java heap space problem.
It occur?ed to use tFileOutputExcel with create new tab.
Real memory is free.
connecting to socket on port 3677
connected
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOf(Unknown Source)
at java.io.ByteArrayOutputStream.grow(Unknown Source)
at java.io.ByteArrayOutputStream.ensureCapacity(Unknown Source)
at java.io.ByteArrayOutputStream.write(Unknown Source)
at org.apache.poi.openxml4j.opc.internal.MemoryPackagePartOutputStream.write(MemoryPackagePartOutputStream.java:88)
at org.apache.xmlbeans.impl.store.Cursor._save(Cursor.java:590)
at org.apache.xmlbeans.impl.store.Cursor.save(Cursor.java:2544)
at org.apache.xmlbeans.impl.values.XmlObjectBase.save(XmlObjectBase.java:223)
at org.apache.poi.xssf.usermodel.XSSFSheet.write(XSSFSheet.java:2818)
at org.apache.poi.xssf.usermodel.XSSFSheet.commit(XSSFSheet.java:2773)
at org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:322)
at org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:326)
at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:173)
at org.talend.ExcelTool.writeExcel(ExcelTool.java:298)
disconnected
at cpc.job5b_marge_excelfile_0_1.Job5b_marge_excelfile.tFileInputDelimited_3Process(Job5b_marge_excelfile.java:4087)
at cpc.job5b_marge_excelfile_0_1.Job5b_marge_excelfile.runJobInTOS(Job5b_marge_excelfile.java:10400)
at cpc.job5b_marge_excelfile_0_1.Job5b_marge_excelfile.main(Job5b_marge_excelfile.java:10233)
I think heap size is specified in TOS_BD-win-x86_64.
-vmargs
-Xms512m
-Xmx1536m
-XX:MaxPermSize=512m
-Dfile.encoding=UTF-8

If I try to modify this file directly , heap size is extended?
or other action exist?
Thanks.
Miki
Moderator

Re: Java heap space occurred with using tFileOutputExcel.

Hi,
Please take a look at KB articles:TalendHelpCenter:Exception%3A Could not reserve enough space for object heap.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Java heap space occurred with using tFileOutputExcel.

Hi,
Thank you for your comment.
I checked advanced setting and solved this problem.
Thanks.
Miki
Moderator

Re: Java heap space occurred with using tFileOutputExcel.

Hi Miki,
Could you please mark this topic as resolved? You can click the "Set this topic as resolved" link which is right underneath your initial post? This way, other users will be informed that this thread has been resolved.

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now