Excel-Export not working / ReportServer (EN) / ReportServer Forum

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

Excel-Export not working

Dear,

after upgrade from RS 4.3. to 4.6., Excel-Export is not working: New window in Browser is opened, and error is displayed:

Hmmm… can't reach this page

It looks like the webpage at http://tvrtvita03/reportserver/reportserver/reportexport?nonce=0.02529831315268627&tid=7235063-10- 1701260869089-862232534&download=true might be having issues, or it may have moved permanently to a new web address.

ERR_INVALID_RESPONSE

Other exports are working fine (CSV, HTML, PDF).

Here is an example url which does not work:
http://tvrtvita03/reportserver/reportserver/reportexport?nonce=0.02529831315268627&tid=7235063-10-1701260869089-862232534&download=true

And an URL for HTML, which works:
http://tvrtvita03/reportserver/reportserver/reportexport?nonce=0.17690389478716728&tid=3388485-10-1701261022846-941938498&download=true

Re: Excel-Export not working

Type Exception Report

Message Filter execution threw an exception

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

javax.servlet.ServletException: Filter execution threw an exception
Root Cause

java.lang.NoClassDefFoundError: Could not initialize class org.apache.poi.xssf.model.SharedStringsTable
org.apache.poi.ooxml.POIXMLFactory.newDocumentPart(POIXMLFactory.java:94)
org.apache.poi.ooxml.POIXMLDocumentPart.createRelationship(POIXMLDocumentPart.java:593)
org.apache.poi.ooxml.POIXMLDocumentPart.createRelationship(POIXMLDocumentPart.java:502)
org.apache.poi.xssf.usermodel.XSSFWorkbook.onWorkbookCreate(XSSFWorkbook.java:488)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:233)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:227)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:215)
org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:264)
org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:234)
org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:209)
org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:296)
net.datenwerke.rs.base.service.reportengines.table.output.generator.XLSStreamOutputGenerator.initialize(XLSStreamOutputGenerator.java:172)
net.datenwerke.rs.base.service.reportengines.table.TableReportEngine.createReport(TableReportEngine.java:292)
net.datenwerke.rs.base.service.reportengines.table.TableReportEngine.doExecuteNormal(TableReportEngine.java:200)
net.datenwerke.rs.base.service.reportengines.table.TableReportEngine.doExecuteNormal(TableReportEngine.java:155)
net.datenwerke.rs.base.service.reportengines.table.TableReportEngine.doExecute(TableReportEngine.java:86)
net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.execute(ReportEngine.java:146)
net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:246)
net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:161)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.executeReport(ReportExportServlet.java:563)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doExportReport(ReportExportServlet.java:439)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:367)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportViaSession(ReportExportServlet.java:358)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:162)
com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:64)
net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)
javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)
com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:290)
com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:280)
com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:184)
com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:89)
com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:94)
com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:121)
com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:133)
Note The full stack trace of the root cause is available in the server logs.

Re: Excel-Export not working

Hi nikolajoder,

did you completely replace the 4.3 binaries, especially the completely web-inf/lib with the new 4.6 binaries? The old reportserver binaries should be completely deleted before you copy the new reportserver binaries. If not, you may have old libraries that may cause problems, as in this case.

You seem to be mixing poi-ooxml-4.1.2.jar with the (provided) poi-ooxml-5.2.3.jar, which will probably cause problems.

Regards,
Eduardo