Failed to read zip entry source

[Anonymous]

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

[Anonymous]

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

[manodwhb]

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

[Anonymous]

Yes

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

[manodwhb · Accepted solution]

Can you use / instead of \?

[Anonymous]

Thanks, this works

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

Mick