Four Stars

problem of memory with talend

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)

 

5 REPLIES
Eleven Stars

Re: problem of memory with talend

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

Rilhia Solutions
Four Stars

Re: problem of memory with talend

hi  rhall_2_0 , questo è uno screenshot del FileOutputExcelCattura.PNG

Eleven Stars

Re: problem of memory with talend

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.

Rilhia Solutions
Four Stars

Re: problem of memory with talend

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

Eleven Stars

Re: problem of memory with talend

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

Rilhia Solutions