java.lang.IllegalStateException: Error in serialization of (org.zkoss.poi.hssf.record.AutoFilterRecord): Incorrect number of bytes written - expected 35 but got 6

ZK-Tracker | dennis | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    auto filter is not supported in 2003, however, If the file contains autofilter (create by excel). then I cann't save it. get exception when save this file. {code} : >>java.lang.IllegalStateException: Error in serialization of (org.zkoss.poi.hssf.record.AutoFilterRecord): Incorrect number of bytes written - expected 35 but got 6 >> at org.zkoss.poi.hssf.record.StandardRecord.serialize(StandardRecord.java:50) >> at org.zkoss.poi.hssf.usermodel.HSSFWorkbook$SheetRecordCollector.serialize(HSSFWorkbook.java:1281) >> at org.zkoss.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:1327) >> at org.zkoss.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1227) >> at org.zkoss.zss.model.sys.impl.ExcelExporter.export(ExcelExporter.java:35) >> at org.zkoss.zss.api.impl.ExporterImpl.export(ExporterImpl.java:48) >> at org.zkoss.zss.app.repository.impl.SimpleRepository.save(SimpleRepository.java:71) >> at org.zkoss.zss.app.repository.impl.SimpleRepository.saveAs(SimpleRepository.java:101) >> at org.zkoss.zss.app.ui.AppCtrl$7.onEvent(AppCtrl.java:283) >> at org.zkoss.zss.app.ui.AppCtrl$7.onEvent(AppCtrl.java:1) >> at org.zkoss.zss.app.ui.dlg.DlgCtrlBase$1.onEvent(DlgCtrlBase.java:57) >> at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2748) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2719) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2660) >> at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) >> at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) >> at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) >> at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:600) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:482) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:491) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) >> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) >> at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) >> at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) >> at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) >> at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) >> at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) >> at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) >> at org.mortbay.jetty.Server.handle(Server.java:326) >> at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) >> at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) >> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) >> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) >> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) >> at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) >> at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) {code}

    ZK-Tracker | 4 years ago | dennis
    java.lang.IllegalStateException: Error in serialization of (org.zkoss.poi.hssf.record.AutoFilterRecord): Incorrect number of bytes written - expected 35 but got 6
  2. 0

    auto filter is not supported in 2003, however, If the file contains autofilter (create by excel). then I cann't save it. get exception when save this file. {code} : >>java.lang.IllegalStateException: Error in serialization of (org.zkoss.poi.hssf.record.AutoFilterRecord): Incorrect number of bytes written - expected 35 but got 6 >> at org.zkoss.poi.hssf.record.StandardRecord.serialize(StandardRecord.java:50) >> at org.zkoss.poi.hssf.usermodel.HSSFWorkbook$SheetRecordCollector.serialize(HSSFWorkbook.java:1281) >> at org.zkoss.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:1327) >> at org.zkoss.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1227) >> at org.zkoss.zss.model.sys.impl.ExcelExporter.export(ExcelExporter.java:35) >> at org.zkoss.zss.api.impl.ExporterImpl.export(ExporterImpl.java:48) >> at org.zkoss.zss.app.repository.impl.SimpleRepository.save(SimpleRepository.java:71) >> at org.zkoss.zss.app.repository.impl.SimpleRepository.saveAs(SimpleRepository.java:101) >> at org.zkoss.zss.app.ui.AppCtrl$7.onEvent(AppCtrl.java:283) >> at org.zkoss.zss.app.ui.AppCtrl$7.onEvent(AppCtrl.java:1) >> at org.zkoss.zss.app.ui.dlg.DlgCtrlBase$1.onEvent(DlgCtrlBase.java:57) >> at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2748) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2719) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2660) >> at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) >> at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) >> at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) >> at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:600) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:482) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:491) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) >> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) >> at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) >> at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) >> at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) >> at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) >> at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) >> at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) >> at org.mortbay.jetty.Server.handle(Server.java:326) >> at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) >> at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) >> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) >> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) >> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) >> at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) >> at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) {code}

    ZK-Tracker | 4 years ago | dennis
    java.lang.IllegalStateException: Error in serialization of (org.zkoss.poi.hssf.record.AutoFilterRecord): Incorrect number of bytes written - expected 35 but got 6

    Root Cause Analysis

    1. java.lang.IllegalStateException

      Error in serialization of (org.zkoss.poi.hssf.record.AutoFilterRecord): Incorrect number of bytes written - expected 35 but got 6

      at org.zkoss.poi.hssf.record.StandardRecord.serialize()
    2. org.zkoss.poi
      HSSFWorkbook.write
      1. org.zkoss.poi.hssf.record.StandardRecord.serialize(StandardRecord.java:50)
      2. org.zkoss.poi.hssf.usermodel.HSSFWorkbook$SheetRecordCollector.serialize(HSSFWorkbook.java:1281)
      3. org.zkoss.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:1327)
      4. org.zkoss.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1227)
      4 frames
    3. org.zkoss.zss
      DlgCtrlBase$1.onEvent
      1. org.zkoss.zss.model.sys.impl.ExcelExporter.export(ExcelExporter.java:35)
      2. org.zkoss.zss.api.impl.ExporterImpl.export(ExporterImpl.java:48)
      3. org.zkoss.zss.app.repository.impl.SimpleRepository.save(SimpleRepository.java:71)
      4. org.zkoss.zss.app.repository.impl.SimpleRepository.saveAs(SimpleRepository.java:101)
      5. org.zkoss.zss.app.ui.AppCtrl$7.onEvent(AppCtrl.java:283)
      6. org.zkoss.zss.app.ui.AppCtrl$7.onEvent(AppCtrl.java:1)
      7. org.zkoss.zss.app.ui.dlg.DlgCtrlBase$1.onEvent(DlgCtrlBase.java:57)
      7 frames
    4. ZK Kernel
      DHtmlUpdateServlet.doPost
      1. org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2748)
      2. org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2719)
      3. org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2660)
      4. org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
      5. org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720)
      6. org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505)
      7. org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215)
      8. org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:600)
      9. org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:482)
      10. org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:491)
      10 frames
    5. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      2 frames
    6. Jetty Server
      SelectChannelEndPoint.run
      1. org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
      2. org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401)
      3. org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
      4. org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
      5. org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
      6. org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
      7. org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
      8. org.mortbay.jetty.Server.handle(Server.java:326)
      9. org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
      10. org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
      11. org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
      12. org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
      13. org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
      14. org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
      14 frames
    7. Jetty Util
      QueuedThreadPool$PoolThread.run
      1. org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
      1 frame