Failed to read zip entry source

Highlighted
Six Stars

Failed to read zip entry source

It was working but after a minor change to a TFileOutputExcel component I got this message and reverting doesn't help

 

Starting job RDH_Inpatient_Count at 10:25 04/05/2018.
[statistics] connecting to socket on port 3525
[statistics] connected
The system cannot find the path specified.
Exception in component tFileOutputExcel_2 (RDH_Inpatient_Count)
java.io.IOException: Failed to read zip entry source
    at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:103)
    at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:324)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:185)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:144)
    at org.talend.ExcelTool.prepareXlsxFile(ExcelTool.java:112)
    at bedextractmunging.rdh_inpatient_count_0_1.RDH_Inpatient_Count.tFileInputDelimited_3Process(RDH_Inpatient_Count.java:7703)
    at bedextractmunging.rdh_inpatient_count_0_1.RDH_Inpatient_Count.tMsgBox_1Process(RDH_Inpatient_Count.java:6598)
    at bedextractmunging.rdh_inpatient_count_0_1.RDH_Inpatient_Count.tFileInputDelimited_2Process(RDH_Inpatient_Count.java:6459)
    at bedextractmunging.rdh_inpatient_count_0_1.RDH_Inpatient_Count.tSystem_7Process(RDH_Inpatient_Count.java:5514)
    at bedextractmunging.rdh_inpatient_count_0_1.RDH_Inpatient_Count.tFileList_2Process(RDH_Inpatient_Count.java:5254)
[statistics] disconnected
    at bedextractmunging.rdh_inpatient_count_0_1.RDH_Inpatient_Count.tSystem_6Process(RDH_Inpatient_Count.java:957)
    at bedextractmunging.rdh_inpatient_count_0_1.RDH_Inpatient_Count.runJobInTOS(RDH_Inpatient_Count.java:8349)
    at bedextractmunging.rdh_inpatient_count_0_1.RDH_Inpatient_Count.main(RDH_Inpatient_Count.java:8185)
Caused by: java.io.EOFException: Unexpected end of ZLIB input stream
    at java.util.zip.InflaterInputStream.fill(Unknown Source)
    at java.util.zip.InflaterInputStream.read(Unknown Source)
    at java.util.zip.ZipInputStream.read(Unknown Source)
    at org.apache.poi.openxml4j.util.ZipSecureFile$ThresholdInputStream.read(ZipSecureFile.java:219)
    at java.io.FilterInputStream.read(Unknown Source)
    at org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource$FakeZipEntry.<init>(ZipInputStreamZipEntrySource.java:132)
    at org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource.<init>(ZipInputStreamZipEntrySource.java:56)
    at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:100)
    ... 12 more
Job RDH_Inpatient_Count ended at 10:25 04/05/2018. [exit code=1]

Have I corrupted my installation? What should I do to repair/fix this problem?

 

Thanks for all of your help todate

 

Mick

 

 

 

 

Tags (1)

Accepted Solutions
Forteen Stars

Re: Failed to read zip entry source

Can you use / instead of \?
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: Failed to read zip entry source

Thanks, this works

"F:/TEHS Informatics/REPORTS/Count_patients/"

Mick


All Replies
Six Stars

Re: Failed to read zip entry source

Fault only occurs when I use fully qualified filename like

"\\\\prod.main.ntgov\\ntg\\dhf\\crh\\groups\\data\\TEHS Informatics\\REPORTS\\Count_patients\\Patient_Count"

 

Thanks for taking the time to read this

 

Mick

Forteen Stars

Re: Failed to read zip entry source

@mikcaau,is this "\\\\prod.main.ntgov\\ntg\\dhf\\crh\\groups\\data\\TEHS Informatics\\REPORTS\\Count_patients\\Patient_Count" your output Excelfile location?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: Failed to read zip entry source

Yes

It also fails when I try to save to any network, including mapped drives.

Forteen Stars

Re: Failed to read zip entry source

Can you use / instead of \?
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: Failed to read zip entry source

Thanks, this works

"F:/TEHS Informatics/REPORTS/Count_patients/"

Mick

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads