Can't figure out what's wrong with report.

[ama.macoh]

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
 

[mahadiosb]

Describe More

[Michael Bielkiewicz]

Your SQL is bad. The important line is: ERROR: operator does not exist: timestamp with time zone <= integer

You likely are passing perhaps a parameter with an incorrect type to your SQL statement - doublecheck all parameters in your SQL and ensure that their type as defined in the jrxml match the type as defined in the database. Good luck!

-Mike