topic Re: ZIP_Read: error reading zip file in Talend Studio

ZIP_Read: error reading zip file

Anonymous — Sat, 16 Nov 2024 10:17:24 GMT

I am getting below error message and dont know why. This file is not a zip file, it is .xlsx file.
Exception in component tFileInputExcel_4
org.apache.poi.POIXMLException: java.util.zip.ZipException: ZIP_Read: error reading zip file
    at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:182)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:300)
    at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:159)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:200)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:263)
Thank you.

Re: ZIP_Read: error reading zip file

Anonymous — Mon, 31 Oct 2016 02:59:50 GMT

Hi,
Could you please indicate what's the build version you are using? Would you mind sending your input file to us for testing?
Best regards
Sabrina

Re: ZIP_Read: error reading zip file

Anonymous — Tue, 01 Nov 2016 17:13:31 GMT

Talend Studio 5.6.1
Its an excel file, its not letting paste that file here.
Please help.

Re: ZIP_Read: error reading zip file

Anonymous — Tue, 01 Nov 2016 17:21:24 GMT

Talend Studio 5.6.1
Its an excel file, its not letting paste that file here.
Please help.

Re: ZIP_Read: error reading zip file

JR1 — Tue, 01 Nov 2016 19:51:52 GMT

Actually, all xlsx files are zip files (try opening one with e.g. 7zip). The error message from Apache POI indicates that it cannot open the file. Apache POI is a Java library for handling MS documents which is used in all Talend Excel components. Can you open the file in question with MS Excel?

Re: ZIP_Read: error reading zip file

JR1 — Tue, 01 Nov 2016 19:55:49 GMT

One more thing: is it really an xlsx file or an xls file? If it is an xlsx, you will have to check "Read excel2007 file format(xlsx)" in the tFileInputExcel component. If not, uncheck it.

Re: ZIP_Read: error reading zip file

Anonymous — Wed, 02 Nov 2016 07:34:22 GMT

Hello spatel,
You can send your excel file to us by email directly. Is there any update for your issue?
Best regards
Sabrina

Re: ZIP_Read: error reading zip file

Anonymous — Wed, 02 Nov 2016 18:00:51 GMT

File is xlsx.
I can open this file in excel without any issues.
"Read excel2007" is checked.
what email address should I used to send file?
Thanks

Re: ZIP_Read: error reading zip file

Anonymous — Thu, 03 Nov 2016 05:05:30 GMT

Also which component are you using to read the file?

Re: ZIP_Read: error reading zip file

Anonymous — Thu, 03 Nov 2016 07:07:48 GMT

Hi,
We have sent an email to you('sangita.patel@optum.com'). Could you please check it?
Best regards
Sabrina

Re: ZIP_Read: error reading zip file

Anonymous — Fri, 04 Nov 2016 03:16:18 GMT

Hi,
We can create file excel metadata for your input excel file. It works well on my side. Could you please take a look at my screenshots?
Best regards
Sabrina

Re: ZIP_Read: error reading zip file

Anonymous — Fri, 04 Nov 2016 16:11:06 GMT

Hi Sankalp,
I am using "tFileInputExcel" to read the file.
THanks

Re: ZIP_Read: error reading zip file

Anonymous — Mon, 07 Nov 2016 08:11:29 GMT

Hi spatel,
Can you successfully read the excel file by a simple job: tfileinputexcel-->tlogrow?
Best regards
Sabrina

Re: ZIP_Read: error reading zip file

Anonymous — Tue, 08 Nov 2016 16:35:43 GMT

Yes, without any issues.
Thanks

Re: ZIP_Read: error reading zip file

Anonymous — Wed, 09 Nov 2016 03:52:01 GMT

Hi,

Exception in component tFileInputExcel_4
org.apache.poi.POIXMLException: java.util.zip.ZipException: ZIP_Read: error reading zip file

What does your whole job design look like? Does this issue only repro on a specific job?
Best regards
Sabrina

Re: ZIP_Read: error reading zip file

Anonymous — Tue, 15 Nov 2016 15:55:35 GMT

I have highlighted the component that errors out.

Re: ZIP_Read: error reading zip file

Anonymous — Wed, 16 Nov 2016 08:38:06 GMT

Hi,
What's talend product solution you are using? open source or subscription solution? Your have a big job, which is a little hard for us to address your issue from screenshot.
Best regards
Sabrina

Re: ZIP_Read: error reading zip file

Anonymous — Fri, 07 Feb 2020 18:56:55 GMT

Belated feedback: I've found this can be equivalent to a "file not found" error. Mine were caused by mis-named input files.