Hi all,
I created job and Job flow is below.
tFileInputExcel-->> tMap-->>tPostgresqlOutput
Excel File location is D:\File\Rerun.xls and Postgresql DB is located in different host(Ex 10.10.20.20)
Job is running in local machine.
I exported job in Linux and unzip the job.I tried to run shell script, I'm getting error.
Exception in component tFileInputExcel_1
java.lang.IllegalStateException: Zip File is closed
at org.apache.poi.openxml4j.util.ZipFileZipEntrySource.getEntries(ZipFil eZipEntrySource.java:45)
at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java: 182)
at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:665)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:226)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:186)
at org.apache.poi.POIXMLDocument.openPackage(POIXMLDocument.java:67)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:2 63)
at reruns.test_rerun_alert_2014_0_1.Test_Rerun_Alert_2014.tFileInputExce l_1Process(Test_Rerun_Alert_2014.java:2871)
at reruns.test_rerun_alert_2014_0_1.Test_Rerun_Alert_2014.runJobInTOS(Te st_Rerun_Alert_2014.java:5076)
at reruns.test_rerun_alert_2014_0_1.Test_Rerun_Alert_2014.main(Test_Reru
Please give your inputs.
Thanks,
Kumar
Hi Sabrina,
I too am getting a similar kind of error when trying to read an Excel file from a local directory. I have created a job called load_Sheet which reads a sheet from a Excel file (.xlsx) and dumps it into a database table. The path of the Excel file is passed using context parameters (context.file_path+context.mapping_file) that are are populated after querying another database table.
This job executes successfully when executed individually. But when I invoke this job through another job, I see the below exception message in the console:
Exception in component tFileInputExcel_2
java.lang.IllegalStateException: Zip File is closed
at org.apache.poi.openxml4j.util.ZipFileZipEntrySource.getEntries(ZipFileZipEntrySource.java:45)
at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:186)
at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:673)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:226)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:186)
at org.apache.poi.POIXMLDocument.openPackage(POIXMLDocument.java:74)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:296)
at ...
The only difference between these two executions is that when run as a sub job, the code to set the context parameter's values in invoked in the main job instead of the sub job.
What can be the possible issue with this?
