Hello, when running the report, it gives an error. There was an error on the server. Try again or contact site administrators.

[deadsploid]

Hello, when running the report, it gives an error. There was an error on the server. Try again or contact site administrators. (Error UID: 8e99966a-b426-41f3-aac6-04c0bdbcc4bd)

Perhaps the problem is in sql, but in jaspersoft everything works correctly

in jasperlogs shows this:
SecureExceptionHandlerImpl,pool-9-thread-4:125 - There was an error on the server. Try again or contact site administrators. (Error UID: 8e99966a-b426-41f3-aac6-04c0bdbcc4bd) com.jaspersoft.jasperserver.api.ErrorDescriptorException: There was an error on the server. Try again or contact site administrators. (Error UID: ce8c58eb-da9b-4668-9b91-edff922fb0bd)
at com.jaspersoft.jasperserver.remote.services.ReportExecution.getFinalReportUnitResult(ReportExecution.java:173)
at com.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl$2.run(RunReportServiceImpl.java:498)

 

update:

2023-02-17T12:42:11,218 ERROR Validator,pool-7-thread-15:541 - Validation unsuccessful. Failed evaluating default rule 'Validator.SQL_VALIDATION_PATTERN', no matches found 
2023-02-17T12:42:11,218 ERROR AsyncJasperPrintAccessor,pool-7-thread-15:321 - Error during report execution com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632)
Arguments: 
    at com.jaspersoft.jasperserver.api.security.validators.Validator.newSecurityException(Validator.java:553)
    at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:542)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.validateSQL(JRTimezoneJdbcQueryExecuter.java:211)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:157)
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1273)
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:734)
    at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:585)
    at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:972)
    at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:181)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:923)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1894)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1185)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1122)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:997)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)

2023-02-17T12:42:11,221 ERROR SecureExceptionHandlerImpl,pool-9-thread-32:125 - There was an error on the server. Try again or contact site administrators. (Error UID: 5a9e8664-b5c3-492c-90ec-18449a9de491) com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632)
Arguments: 
    at com.jaspersoft.jasperserver.api.security.validators.Validator.newSecurityException(Validator.java:553)
    at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:542)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.validateSQL(JRTimezoneJdbcQueryExecuter.java:211)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:157)
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1273)
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:734)
    at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:585)
    at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:972)
    at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:181)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:923)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1894)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1185)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1122)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:997)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)

at com.jaspersoft.jasperserver.api.logging.util.LoggableExecutorService$1.run(LoggableExecutorService.java:84)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

[Jivan Phadtare]

It looks like your report query validation is getting failed.

If you don't want to validate sql then you can set below property to 'false' in file "security-config.properties", restart JRS and then try to run the report.

security.validation.sql.on=false

if you would like to validate sql then Please check file "security-config.properties" for below property.

security.validation.sql.on=true

If this property set as true then make sure in "security.properties" file below property is also uncommented.

# sqlQueryExecutor=Alpha,ValidSQL,500000,true,SQL_Query_Executor_context

Also, plesae uncomment below property from "validation.properties" file.

# Validator.ValidSQL=(?is)^\s*(select|call)\b((?!\binto\b)[^;])*;?\s*$

If your report query using "with" keyword then you can use property below as you mentioend in description.

Validator.ValidSQL=(?is)^\s*(select|with|declare)\s+[^;]+;?\s*$

 

[deadsploid]

hi did not help. This error still stands, in similar questions I saw that they somehow change the type of the SQL language, but I don’t understand how. If you know please tell me

[Michael Bielkiewicz]

It might help to share the SQL statement that's causing the error. The answer provided above is correct - you can either disable validation altogether or enable it and update the regex shown to allow whatever your SQL is trying to call...

[deadsploid]

The solution may be correct, but for some reason it does not fit.
security.validation.sql.on=false.
But it still gives an error in the logs 6632