problem of memory with talend

[Anonymous]

Hi,

I have problem of memory with talend, in fact when I run the job , I have this error:

Exception in component tFileOutputExcel_1

java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 stream, nor an OOXML stream

at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:89)

at org.talend.ExcelTool.prepareXlsxFile(ExcelTool.java:110)

at customer_portal.kitting_prova_0_1.kitting_prova.tFileInputExcel_1Process(kitting_prova.java:15661)

at customer_portal.kitting_prova_0_1.kitting_prova.runJobInTOS(kitting_prova.java:20528)

at customer_portal.kitting_prova_0_1.kitting_prova.main(kitting_prova.java:20385)

[Anonymous]

Can you take a screenshot of the configuration of your tFileOutputExcel component please?

[Anonymous]

hi  @rhall , questo è uno screenshot del FileOutputExcel

[Anonymous]

Is there a zero byte version of that file by any  chance? I have seen similar issues when you try to append to an Excel file which appears to be there but isn't in reality an Excel file.

[Anonymous]

what do you mean by  a zero byte version of that file? I don't undestand

[Anonymous]

An empty version of the file with a file size of 0