Report errors out on run in Jaspersoft Sever. Stack Trace: 2022-11-11T16:08:12,634 ERROR SecureExceptionHandlerImpl,http-nio-80-exec-141:116 - There was an error on the server. Try again or contact site administrators. (Error UID: d5ef463e-3dc0-4656-a789-7f797856d51d) 2022-11-11T16:08:12,634 ERROR ErrorPageHandlerAction,http-nio-80-exec-141:118 - Error UID d5ef463e-3dc0-4656-a789-7f797856d51d com.jaspersoft.jasperserver.api.JSException: Error filling report at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1339) ~[jasperserver-api-engine-impl-7.8.0.jar:?] at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:228) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:150) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:959) ~[jasperserver-api-engine-impl-7.8.0.jar:?] at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:181) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:910) ~[jasperserver-api-engine-impl-7.8.0.jar:?] at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1857) ~[jasperserver-api-engine-impl-7.8.0.jar:?] at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1162) ~[jasperserver-api-engine-impl-7.8.0.jar:?] at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1103) ~[jasperserver-api-engine-impl-7.8.0.jar:?] at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:981) ~[jasperserver-api-engine-impl-7.8.0.jar:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_282] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_282] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_282] Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: report name. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:357) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:181) ~[jasperserver-api-engine-impl-7.8.0.jar:?] at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:115) ~[ji-datarator-7.8.0.jar:?] at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:584) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] ... 10 more Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: timestamp with time zone <= integer Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 505 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.18.jar:42.2.18] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.18.jar:42.2.18] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.18.jar:42.2.18] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) ~[postgresql-42.2.18.jar:42.2.18] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) ~[postgresql-42.2.18.jar:42.2.18] at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.18.jar:42.2.18] at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114) ~[postgresql-42.2.18.jar:42.2.18] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4] at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:312) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:181) ~[jasperserver-api-engine-impl-7.8.0.jar:?] at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:115) ~[ji-datarator-7.8.0.jar:?] at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:584) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f] ... 10 more
