java - Apache POI works with .xls but not with .xlsx -
i'm creating export apache poi. when i'm using export xls, hssfrow , hssfcell, working perfect both locally , on server. when change xlsx, xssfcell , xssfrow, working locally not on server. giving me following error:
there unexpected error (type=internal server error, status=500). fail save: error occurs while saving package : part /docprops/core.xml fail saved in stream marshaller org.apache.poi.openxml4j.opc.internal.marshallers.zippackagepropertiesmarshaller@7621d6eb not sure why happening. ideas? poi version 3.11, have tried others same result.
here pf export component:
<p:commandlink styleclass="exportallpages" ajax="false"> <p:dataexporter type="xlsx" target="techdata" filename="tdam" pageonly="false" postprocessor="#{global.postprocessxls}"/> </p:commandlink> here exception have in logs:
fail save: error occurs while saving package : part /docprops/core.xml fail saved in stream marshaller org.apache.poi.openxml4j.opc.internal.marshallers.zippackagepropertiesmarshaller@6e7530ef org.apache.poi.openxml4j.exceptions.openxml4jruntimeexception: fail save: error occurs while saving package : part /docprops/core.xml fail saved in stream marshaller org.apache.poi.openxml4j.opc.internal.marshallers.zippackagepropertiesmarshaller@6e7530ef @ org.apache.poi.openxml4j.opc.zippackage.saveimpl(zippackage.java:503) ~[poi-ooxml-3.11.jar:3.11] @ org.apache.poi.openxml4j.opc.opcpackage.save(opcpackage.java:1425) ~[poi-ooxml-3.11.jar:3.11] @ org.apache.poi.poixmldocument.write(poixmldocument.java:201) ~[poi-ooxml-3.11.jar:3.11] @ org.primefaces.component.export.excelexporter.writeexceltoresponse(excelexporter.java:176) ~[primefaces-5.2.jar:5.2] @ org.primefaces.component.export.excelexporter.export(excelexporter.java:73) ~[primefaces-5.2.jar:5.2] @ org.primefaces.component.export.dataexporter.processaction(dataexporter.java:97) ~[primefaces-5.2.jar:5.2] @ javax.faces.event.actionevent.processlistener(actionevent.java:88) ~[jsf-api-2.2.10.jar:2.2] @ javax.faces.component.uicomponentbase.broadcast(uicomponentbase.java:813) ~[jsf-api-2.2.10.jar:2.2] @ javax.faces.component.uicommand.broadcast(uicommand.java:300) ~[jsf-api-2.2.10.jar:2.2] @ javax.faces.component.uidata.broadcast(uidata.java:1108) ~[jsf-api-2.2.10.jar:2.2] @ javax.faces.component.uiviewroot.broadcastevents(uiviewroot.java:790) ~[jsf-api-2.2.10.jar:2.2] @ javax.faces.component.uiviewroot.processapplication(uiviewroot.java:1282) ~[jsf-api-2.2.10.jar:2.2] @ com.sun.faces.lifecycle.invokeapplicationphase.execute(invokeapplicationphase.java:81) ~[jsf-impl-2.2.10.jar:2.2.10] @ com.sun.faces.lifecycle.phase.dophase(phase.java:101) [jsf-impl-2.2.10.jar:2.2.10] @ com.sun.faces.lifecycle.lifecycleimpl.execute(lifecycleimpl.java:198) [jsf-impl-2.2.10.jar:2.2.10] @ javax.faces.webapp.facesservlet.service(facesservlet.java:646) [jsf-api-2.2.10.jar:2.2] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:303) [catalina.jar:7.0.59.b] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208) [catalina.jar:7.0.59.b] @ org.springframework.web.filter.characterencodingfilter.dofilterinternal(characterencodingfilter.java:88) [spring-web-4.1.3.release.jar:4.1.3.release] @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) [spring-web-4.1.3.release.jar:4.1.3.release] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:241) [catalina.jar:7.0.59.b] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208) [catalina.jar:7.0.59.b] @ org.springframework.web.filter.hiddenhttpmethodfilter.dofilterinternal(hiddenhttpmethodfilter.java:77) [spring-web-4.1.3.release.jar:4.1.3.release] @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) [spring-web-4.1.3.release.jar:4.1.3.release] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:241) [catalina.jar:7.0.59.b] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208) [catalina.jar:7.0.59.b] @ com.planetj.servlet.filter.compression.compressingfilter.dofilter(compressingfilter.java:270) [pjl-comp-filter-1.7.jar:na] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:241) [catalina.jar:7.0.59.b] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208) [catalina.jar:7.0.59.b] @ org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:330) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.access.intercept.filtersecurityinterceptor.invoke(filtersecurityinterceptor.java:118) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.access.intercept.filtersecurityinterceptor.dofilter(filtersecurityinterceptor.java:84) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:342) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.access.exceptiontranslationfilter.dofilter(exceptiontranslationfilter.java:113) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:342) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.session.sessionmanagementfilter.dofilter(sessionmanagementfilter.java:103) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:342) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.authentication.anonymousauthenticationfilter.dofilter(anonymousauthenticationfilter.java:113) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:342) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.servletapi.securitycontextholderawarerequestfilter.dofilter(securitycontextholderawarerequestfilter.java:154) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:342) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.savedrequest.requestcacheawarefilter.dofilter(requestcacheawarefilter.java:45) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:342) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.authentication.abstractauthenticationprocessingfilter.dofilter(abstractauthenticationprocessingfilter.java:199) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:342) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.authentication.logout.logoutfilter.dofilter(logoutfilter.java:110) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:342) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.header.headerwriterfilter.dofilterinternal(headerwriterfilter.java:57) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) [spring-web-4.1.3.release.jar:4.1.3.release] @ org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:342) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.context.securitycontextpersistencefilter.dofilter(securitycontextpersistencefilter.java:87) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:342) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.context.request.async.webasyncmanagerintegrationfilter.dofilterinternal(webasyncmanagerintegrationfilter.java:50) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) [spring-web-4.1.3.release.jar:4.1.3.release] @ org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:342) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.filterchainproxy.dofilterinternal(filterchainproxy.java:192) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.springframework.security.web.filterchainproxy.dofilter(filterchainproxy.java:160) [spring-security-web-3.2.5.release.jar:3.2.5.release] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:241) [catalina.jar:7.0.59.b] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208) [catalina.jar:7.0.59.b] @ org.primefaces.webapp.filter.fileuploadfilter.dofilter(fileuploadfilter.java:100) [primefaces-5.2.jar:5.2] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:241) [catalina.jar:7.0.59.b] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208) [catalina.jar:7.0.59.b] @ org.springframework.boot.context.web.errorpagefilter.dofilter(errorpagefilter.java:108) [spring-boot-1.2.0.release.jar:1.2.0.release] @ org.springframework.boot.context.web.errorpagefilter.access$000(errorpagefilter.java:59) [spring-boot-1.2.0.release.jar:1.2.0.release] @ org.springframework.boot.context.web.errorpagefilter$1.dofilterinternal(errorpagefilter.java:88) [spring-boot-1.2.0.release.jar:1.2.0.release] @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) [spring-web-4.1.3.release.jar:4.1.3.release] @ org.springframework.boot.context.web.errorpagefilter.dofilter(errorpagefilter.java:101) [spring-boot-1.2.0.release.jar:1.2.0.release] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:241) [catalina.jar:7.0.59.b] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208) [catalina.jar:7.0.59.b] @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:220) [catalina.jar:7.0.59.b] @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:122) [catalina.jar:7.0.59.b] @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:504) [catalina.jar:7.0.59.b] @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:170) [catalina.jar:7.0.59.b] @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:103) [catalina.jar:7.0.59.b] @ org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:950) [catalina.jar:7.0.59.b] @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:116) [catalina.jar:7.0.59.b] @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:421) [catalina.jar:7.0.59.b] @ org.apache.coyote.ajp.ajpprocessor.process(ajpprocessor.java:190) [tomcat-coyote.jar:7.0.59.b] @ org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:611) [tomcat-coyote.jar:7.0.59.b] @ org.apache.tomcat.util.net.jioendpoint$socketprocessor.run(jioendpoint.java:314) [tomcat-coyote.jar:7.0.59.b] @ java.util.concurrent.threadpoolexecutor$worker.runtask(threadpoolexecutor.java:895) [na:1.6.0_45] @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:918) [na:1.6.0_45] @ org.apache.tomcat.util.threads.taskthread$wrappingrunnable.run(taskthread.java:61) [tomcat-coyote.jar:7.0.59.b] @ java.lang.thread.run(thread.java:662) [na:1.6.0_45] caused by: org.apache.poi.openxml4j.exceptions.openxml4jexception: part /docprops/core.xml fail saved in stream marshaller org.apache.poi.openxml4j.opc.internal.marshallers.zippackagepropertiesmarshaller@6e7530ef @ org.apache.poi.openxml4j.opc.zippackage.saveimpl(zippackage.java:486) ~[poi-ooxml-3.11.jar:3.11]
Comments
Post a Comment