The World’s Largest Online Community for Developers

'; jasperserver - An error has occurred. Please contact your system administrator. (6632) error in Jasper server 6.2 - LavOzs.Com

I am using Jasper report :- TIBCO Jaspersoft Jasper server :- JasperReports Server Community Edition (v6.2.0)

I published Report book template Jasper report into Jasper Server. But when I am running report from Jasper Server, I am getting below error

Error Message An error has occurred. Please contact your system administrator. (6632) Error Trace com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632) Arguments: at 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.JRFillDatasetRun.evaluate( at net.sf.jasperreports.engine.fill.JRFillElementDataset.evaluateDatasetRun( at net.sf.jasperreports.engine.fill.JRFillCrosstab.evaluate( at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate( at net.sf.jasperreports.engine.fill.JRFillBand.evaluate( at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand( at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail( at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart( at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport( at net.sf.jasperreports.engine.fill.JRBaseFiller.fill( at net.sf.jasperreports.engine.fill.BaseReportFiller.fill( at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport( at at at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$ Source) at Source)

I already updated security.validation.sql.on=false in file.

But still I am getting this error.

How to resolve this issue?

You might be using some special keywords in your SQL query (such as "with" clause). You may need to edit the jasperserver-pro/WEB-INF/classes/esapi/ file. And edit the line, Validator.ValidSQL=(?is)^\s*(select|ADD_NEW_CLAUSE_HERE)\s+^;+$.

And restart the server.

Proving the queries you use will be helpful for a more comprehensive answer.

for security reasons(!) I personally would recommend (using it is quite insecure as described below!) to

  1. set this to


    or even better


    so there is no validity check actually done. Why? Because the previous (standard regexp) is a quite weak (and immature - as e.g. preventing with ... select ... clauses) check and may suggest that SQL injection would be prevented in a higher degree.

A) if I am NOT concerned about security/SQL injection in my environment or the cost-value-factor is inefficient (take non-IT budget-responsible people into the boat to decide here!), I would leave it like this for now

B) if I am concerned about security/SQL injection in my environment, I would recommend to

How to solve this nullPointer Exception in jasper report?
Jasper sub report error
Jasper reports: getting errors of class not found
Jasper Reports Breaks on Build (no edits)
Jasper reports List as Parameter
JasperReport: How to get date from the "oracle.sql.TIMESTAMP' field?
Barcode creation in Jasper report: n is not a valid character for Standard 2 of 5 encoding
Jasperreport problem wtih subreport using javaflow