java.lang.IllegalStateException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • XLSX file reading error
    via Stack Overflow by uttam patel
    ,
  • apache poi error zip file is closed
    via Stack Overflow by Douglas Johgn
    ,
  • 3D grphique: apache poi error zip file is closed
    via by Unknown author,
  • When EXCEL Input step is used with NON Local system location, in other words, with VFS paths it fails. 2 cases below When Streaming Mode is used, the most likely error is "Zip File is closed". This was tested with VFS: * ZIP * TMP * HDFS - SFTP Error for ZIP Closed: {code} 2016/07/06 13:02:11 - Spoon - Transformation opened. 2016/07/06 13:02:11 - Spoon - Launching transformation [excel]... 2016/07/06 13:02:11 - Spoon - Started the transformation execution. 2016/07/06 13:02:11 - excel - Dispatching started for transformation [excel] 2016/07/06 13:02:12 - Microsoft Excel Input.0 - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : Error processing row from Excel file [zip:file:///C:/tmp/DB/sample file.zip!/sample file.xlsx] : org.pentaho.di.core.exception.KettleException: 2016/07/06 13:02:12 - Microsoft Excel Input.0 - java.lang.IllegalStateException: Zip File is closed 2016/07/06 13:02:12 - Microsoft Excel Input.0 - Zip File is closed 2016/07/06 13:02:12 - Microsoft Excel Input.0 - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : org.pentaho.di.core.exception.KettleException: 2016/07/06 13:02:12 - Microsoft Excel Input.0 - java.lang.IllegalStateException: Zip File is closed 2016/07/06 13:02:12 - Microsoft Excel Input.0 - Zip File is closed 2016/07/06 13:02:12 - Microsoft Excel Input.0 - 2016/07/06 13:02:12 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.staxpoi.StaxPoiWorkbook.<init>(StaxPoiWorkbook.java:81) 2016/07/06 13:02:12 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:43) 2016/07/06 13:02:12 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:552) 2016/07/06 13:02:12 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:430) 2016/07/06 13:02:12 - Microsoft Excel Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2016/07/06 13:02:12 - Microsoft Excel Input.0 - at java.lang.Thread.run(Unknown Source) 2016/07/06 13:02:12 - Microsoft Excel Input.0 - Caused by: java.lang.IllegalStateException: Zip File is closed 2016/07/06 13:02:12 - Microsoft Excel Input.0 - at org.apache.poi.openxml4j.util.ZipFileZipEntrySource.getEntries(ZipFileZipEntrySource.java:45) 2016/07/06 13:02:12 - Microsoft Excel Input.0 - at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:186) 2016/07/06 13:02:12 - Microsoft Excel Input.0 - at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:684) 2016/07/06 13:02:12 - Microsoft Excel Input.0 - at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:227) 2016/07/06 13:02:12 - Microsoft Excel Input.0 - at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:187) 2016/07/06 13:02:12 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.staxpoi.StaxPoiWorkbook.<init>(StaxPoiWorkbook.java:78) 2016/07/06 13:02:12 - Microsoft Excel Input.0 - ... 5 more 2016/07/06 13:02:12 - Microsoft Excel Input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2016/07/06 13:02:12 - excel - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : Errors detected! 2016/07/06 13:02:12 - Spoon - The transformation has finished!! 2016/07/06 13:02:12 - excel - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : Errors detected! 2016/07/06 13:02:12 - excel - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : Errors detected! 2016/07/06 13:02:12 - excel - Transformation detected one or more steps with errors. 2016/07/06 13:02:12 - excel - Transformation is killing the other steps! {code} When Non Streaming Mode is used, the amount of MEMORY is SO HIGH that normally an OUT OF MEMORY ERROR is thrown. This happens on "LARGE" XML file over *15 Mb*. User case is about 80Mb files {code} 2016/07/06 13:13:32 - Spoon - Transformation opened. 2016/07/06 13:13:32 - Spoon - Launching transformation [excel]... 2016/07/06 13:13:32 - Spoon - Started the transformation execution. 2016/07/06 13:13:32 - excel - Dispatching started for transformation [excel] 2016/07/06 13:14:39 - Microsoft Excel Input.0 - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : UnexpectedError: 2016/07/06 13:14:39 - Microsoft Excel Input.0 - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : java.lang.OutOfMemoryError: GC overhead limit exceeded 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at java.lang.String.substring(Unknown Source) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.apache.poi.ss.util.CellReference.separateRefParts(CellReference.java:361) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.apache.poi.ss.util.CellReference.<init>(CellReference.java:92) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.apache.poi.xssf.usermodel.XSSFCell.<init>(XSSFCell.java:107) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.apache.poi.xssf.usermodel.XSSFRow.<init>(XSSFRow.java:68) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.apache.poi.xssf.usermodel.XSSFSheet.initRows(XSSFSheet.java:238) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:201) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:188) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:378) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:166) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:241) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:175) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:143) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:78) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:41) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:552) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:430) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - at java.lang.Thread.run(Unknown Source) 2016/07/06 13:14:39 - Microsoft Excel Input.0 - Finished processing (I=2193, O=0, R=0, W=2193, U=0, E=1) 2016/07/06 13:14:39 - Delay row.0 - Finished processing (I=0, O=0, R=2193, W=2193, U=0, E=0) 2016/07/06 13:14:39 - Dummy (do nothing).0 - Finished processing (I=0, O=0, R=2193, W=2193, U=0, E=0) 2016/07/06 13:14:39 - excel - Transformation detected one or more steps with errors. 2016/07/06 13:14:39 - excel - Transformation is killing the other steps! 2016/07/06 13:14:39 - excel - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : Errors detected! 2016/07/06 13:14:39 - Spoon - The transformation has finished!! 2016/07/06 13:14:39 - excel - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : Errors detected! 2016/07/06 13:14:40 - excel - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : Errors detected! {code}
    via by Alexander Schurman,
    • 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 cn.dfinder.dps.controller.uploadData.UploadController.readXlsx(UploadController.java:265) at cn.dfinder.dps.controller.uploadData.UploadController.uploadData(UploadController.java:198) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) at javax.servlet.http.HttpServlet.service(HttpServlet.java:644) at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at cn.dfinder.dps.controller.filter.FunctionControllFilter.doFilter(FunctionControllFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at cn.dfinder.dps.controller.filter.CrossDomainAccessFilter.doFilter(CrossDomainAccessFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at cn.dfinder.dps.controller.filter.EncodingFilter.doFilter(EncodingFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:136) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:526) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:655) at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1523) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,