ReportServer Forum

dwn

Member

Registered: 2024-02-06

Error running Jasper report after adding drivers for Oracle

- I had a jasper report connecting to MSSQL running fine.
- I then tried to connect to an Oracle Datasource. Connection was tested fine, but when trying to retrieve data, I got the error
  “500 The call failed on the server; see server log for details Statuscode: 500 EncodedResponse: The call failed on the server; see server log for details”
- when reviewing following forum links, have copied the jar files from oracle : orail8n.jar, xmlparserv2.jar, ojdbc11.jar, xdb.jar
https://forum.reportserver.net/viewtopic.php?id=1094
https://forum.reportserver.net/viewtopic.php?id=1499
- after update of the jar files, I can run reports against the Oracle datasource.
- However my existing jasper report which was working fine is now throwing the error

"javax.servlet.ServletException: Filter execution threw an exception

Root Cause

java.lang.NoClassDefFoundError: Could not initialize class net.sf.jasperreports.engine.util.JRStyledTextParser
    net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:115)
    net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:82)
    net.sf.jasperreports.engine.fill.JRFiller.createBandReportFiller(JRFiller.java:251)
    net.sf.jasperreports.engine.fill.JRFiller.createReportFiller(JRFiller.java:272)
    net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:114)
    net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:103)
    net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:530)
    net.datenwerke.rs.base.service.reportengines.jasper.JasperReportEngine.executeReport(JasperReportEngine.java:304)
    net.datenwerke.rs.base.service.reportengines.jasper.JasperReportEngine.doExecute(JasperReportEngine.java:108)
    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:444)
    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:529)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
    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)
"

I do have following flag configured to run :    -Djava.awt.headless=true

dwn

Member

Registered: 2024-02-06

Re: Error running Jasper report after adding drivers for Oracle

The problem is solved after moving the oracle jar files from the WEB-INF/lib path to the reportserver/lib

Last edited by dwn (2024-02-14 13:51:00)

Tobias F

Administrator

Registered: 2020-02-07

Re: Error running Jasper report after adding drivers for Oracle

Hi dwn,

thanks for sharing this tip. I'm sure others will have encountered this problem too.

Greetings Tobias