You are not logged in.
- 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
Offline
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)
Offline
Hi dwn,
thanks for sharing this tip. I'm sure others will have encountered this problem too.
Greetings Tobias
Offline