Report works in JasperReports Studio but not in JasperReports Server

Error in the stacktrace:

    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(
    at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(
    at net.sf.jasperreports.engine.fill.BaseFillHandle$
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(
    at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$
    at java.util.concurrent.ThreadPoolExecutor.runWorker(
    at java.util.concurrent.ThreadPoolExecutor$

laggybuggy's picture
Joined: May 3 2018 - 5:40am
Last seen: 4 years 5 months ago

3 Answers:

I found the solution to my problem. It was caused by my update in the file in $TOMCAT/webapps/jasperserver/WEB-INF/classes/esapi/. I updated security.validation.sql.on to true. It was defaulted to false.


After setting it back, my query successfully run in JasperReports Server.

laggybuggy's picture
Joined: May 3 2018 - 5:40am
Last seen: 4 years 5 months ago

There should be a "caused by" clause little bit further down in the log that usually offer clue to the cause of the problem.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago

@hozawa, there's really no succeeding logs. That's the end of the logs. Before it is the sql command but it is prefixed by the following text:

2018-09-22 10:06:52,622 ERROR Validator,pool-4-thread-12:499 - Invalid SQL:An error has occurred. Please contact your system administrator. (6632),

This is what confused me because it is running as expected in JasperReports Studio 6.6.0. I'm able to successfully generate reports there.

laggybuggy's picture
Joined: May 3 2018 - 5:40am
Last seen: 4 years 5 months ago