tFileOutputExcel : issue with "big" files in format xlsx

[lennelei]

Hi all,
I try to make a quite simple job :
tOralceInput --> tFileOutputExcel
the tFileOutputExcel should write a xlsx file, and I've something like 100'000 or 200'000 rows only.
However, I couldn't find a way to make this work!
Without any specific settings, I've heap space errors :

 disconnected
Exception in thread "main" java.lang.Error: java.lang.OutOfMemoryError: Java heap space
	at ....tOracleInput_1Process(....java:1780)
	at ....runJobInTOS(....java:5109)
	at ....main(....java:4854)
Caused by: java.lang.OutOfMemoryError: Java heap space
	at java.util.Arrays.copyOf(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:180)
	at org.apache.poi.xssf.usermodel.XSSFSheet.write(XSSFSheet.java:2480)
	at org.apache.poi.xssf.usermodel.XSSFSheet.commit(XSSFSheet.java:2439)
	at org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:196)
	at org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:200)
	at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:204)
	at org.talend.ExcelTool.writeExcel(ExcelTool.java:271)
	at ....tOracleInput_1Process(....java:1738)
	... 2 more

And when I try to use an output stream, job never ends...
I also try to use cursor on the tOracleInput but it crashes as well.
Any idea I could try to make this works?
Thanks
Regards
Alexis

[lennelei]

ok, thanks for your time...
I think I'll try with v5.1.1 and if it still fails, I'll try to open a bug