topic problem of memory with talend in Talend Studio

problem of memory with talend

Anonymous — Wed, 17 May 2017 12:57:36 GMT

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)

Re: problem of memory with talend

Anonymous — Wed, 17 May 2017 13:10:33 GMT

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

Re: problem of memory with talend

Anonymous — Wed, 17 May 2017 14:10:59 GMT

hi @rhall , questo è uno screenshot del FileOutputExcel

Re: problem of memory with talend

Anonymous — Wed, 17 May 2017 14:26:28 GMT

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.

Re: problem of memory with talend

Anonymous — Wed, 17 May 2017 14:55:35 GMT

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

Re: problem of memory with talend

Anonymous — Wed, 17 May 2017 15:20:11 GMT

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