ReportServer Forum

nikolajoder

Member

Registered: 2020-01-10

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

nikolajoder

Member

Registered: 2020-01-10

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.

nikolajoder

Member

Registered: 2020-01-10

Re: Excel-Export not working

We fixed the problem by copying jar files poi-ooxml-4.1.2.jar and depended jars to lib.

Looks like RS 4.6., after upgrade from RS 4.3., still uses some jars from 4.3.

eduardo

Administrator

Registered: 2016-11-01

Website

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

nikolajoder

Member

Registered: 2020-01-10

Re: Excel-Export not working

Yes, we completely removed the old maps and replace them with new ones.

The problem was, that the RS 4.6. had problems with missing poi-ooxml-4.1.2.jar, in the lib map was newer version poi-ooxml-5.2.3.jar.

After copying the missing poi-ooxml-4.1.2.jar to lib, excel export started working.