2023-06-02T09:05:26,091 ERROR JSControlledJdbcQueryExecuter,http-nio-8080-exec-1:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:26,091 ERROR JSControlledJdbcQueryExecuter,http-nio-8080-exec-2:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:26,373 ERROR JSControlledJdbcQueryExecuter,http-nio-8080-exec-1:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:26,442 ERROR JSControlledJdbcQueryExecuter,http-nio-8080-exec-2:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:26,603 ERROR JSControlledJdbcQueryExecuter,http-nio-8080-exec-1:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:26,757 ERROR JSControlledJdbcQueryExecuter,http-nio-8080-exec-2:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:26,867 ERROR JSControlledJdbcQueryExecuter,http-nio-8080-exec-1:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:27,076 ERROR JSControlledJdbcQueryExecuter,http-nio-8080-exec-2:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:27,633 ERROR JSControlledJdbcQueryExecuter,http-nio-8080-exec-1:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:27,671 ERROR JSControlledJdbcQueryExecuter,http-nio-8080-exec-2:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:28,235 ERROR JSControlledJdbcQueryExecuter,http-nio-8080-exec-1:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:28,408 ERROR JSControlledJdbcQueryExecuter,http-nio-8080-exec-2:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:31,906 ERROR JSControlledJdbcQueryExecuter,pool-19-thread-1:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:32,049 ERROR JSControlledJdbcQueryExecuter,pool-19-thread-1:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:32,156 ERROR JSControlledJdbcQueryExecuter,pool-19-thread-1:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:32,284 ERROR JSControlledJdbcQueryExecuter,pool-19-thread-1:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:32,555 ERROR JSControlledJdbcQueryExecuter,pool-19-thread-1:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:32,692 ERROR JSControlledJdbcQueryExecuter,pool-19-thread-1:179 [] - exception occured while setting queries to reportContext net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONTEXT" does not exist.
2023-06-02T09:05:37,145 ERROR JRFillSubreport,pool-9-thread-1:961 [] - Fill 1: exception
net.sf.jasperreports.engine.JRException: Unable to get next record.
                at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneResultSetDataSource.next(JRTimezoneResultSetDataSource.java:54) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.commons.util.JSControlledResultSetDataSource.next(JSControlledResultSetDataSource.java:33) ~[ji-datarator-8.1.0.jar:?]
                at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1572) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1415) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1394) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1201) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:622) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:826) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
                at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: net.sf.jasperreports.engine.JRException: Unable to get next record from result set.
                at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:172) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneResultSetDataSource.next(JRTimezoneResultSetDataSource.java:52) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                ... 14 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid length parameter passed to the LEFT or SUBSTRING function.
                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) ~[mssql-jdbc-11.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5477) ~[mssql-jdbc-11.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1790) ~[mssql-jdbc-11.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1048) ~[mssql-jdbc-11.2.0.jre11.jar:?]
                at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:168) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneResultSetDataSource.next(JRTimezoneResultSetDataSource.java:52) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                ... 14 more
2023-06-02T09:05:37,198 ERROR AsyncJasperPrintAccessor,pool-9-thread-1:321 [] - Error during report execution
net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Unable to get next record.
                at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:969) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:542) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillFrame.prepare(JRFillFrame.java:271) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:542) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:453) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:428) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:461) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:420) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:269) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:119) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:622) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135) [jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:972) [jasperserver-api-engine-impl-8.1.0.jar:?]
                at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:181) [jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:923) [jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1894) [jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1185) [jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1122) [jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:997) [jasperserver-api-engine-impl-8.1.0.jar:?]
                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
                at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: net.sf.jasperreports.engine.JRException: Unable to get next record.
                at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneResultSetDataSource.next(JRTimezoneResultSetDataSource.java:54) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.commons.util.JSControlledResultSetDataSource.next(JSControlledResultSetDataSource.java:33) ~[ji-datarator-8.1.0.jar:?]
                at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1572) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1415) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1394) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1201) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:622) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:826) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                ... 3 more
Caused by: net.sf.jasperreports.engine.JRException: Unable to get next record from result set.
                at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:172) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneResultSetDataSource.next(JRTimezoneResultSetDataSource.java:52) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.commons.util.JSControlledResultSetDataSource.next(JSControlledResultSetDataSource.java:33) ~[ji-datarator-8.1.0.jar:?]
                at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1572) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1415) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1394) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1201) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:622) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:826) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                ... 3 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid length parameter passed to the LEFT or SUBSTRING function.
                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) ~[mssql-jdbc-11.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5477) ~[mssql-jdbc-11.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1790) ~[mssql-jdbc-11.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1048) ~[mssql-jdbc-11.2.0.jre11.jar:?]
                at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:168) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneResultSetDataSource.next(JRTimezoneResultSetDataSource.java:52) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.commons.util.JSControlledResultSetDataSource.next(JSControlledResultSetDataSource.java:33) ~[ji-datarator-8.1.0.jar:?]
                at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1572) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1415) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1394) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1201) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:622) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:826) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                ... 3 more
2023-06-02T09:05:37,207 ERROR SecureExceptionHandlerImpl,pool-19-thread-1:125 [] - Auf dem Server ist ein Fehler aufgetreten. Versuchen Sie es erneut, oder wenden Sie sich an die Siteadministratoren.. Unable to get next record.
net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Unable to get next record.
                at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:969) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:542) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillFrame.prepare(JRFillFrame.java:271) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:542) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:453) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:428) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:461) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:420) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:269) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:119) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:622) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:972) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:181) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:923) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1894) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1185) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1122) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:997) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
                at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: net.sf.jasperreports.engine.JRException: Unable to get next record.
                at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneResultSetDataSource.next(JRTimezoneResultSetDataSource.java:54) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.commons.util.JSControlledResultSetDataSource.next(JSControlledResultSetDataSource.java:33) ~[ji-datarator-8.1.0.jar:?]
                at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1572) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1415) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1394) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1201) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:622) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:826) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                ... 3 more
Caused by: net.sf.jasperreports.engine.JRException: Unable to get next record from result set.
                at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:172) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneResultSetDataSource.next(JRTimezoneResultSetDataSource.java:52) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.commons.util.JSControlledResultSetDataSource.next(JSControlledResultSetDataSource.java:33) ~[ji-datarator-8.1.0.jar:?]
                at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1572) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1415) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1394) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1201) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:622) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:826) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                ... 3 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid length parameter passed to the LEFT or SUBSTRING function.
                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) ~[mssql-jdbc-11.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5477) ~[mssql-jdbc-11.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1790) ~[mssql-jdbc-11.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1048) ~[mssql-jdbc-11.2.0.jre11.jar:?]
                at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:168) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneResultSetDataSource.next(JRTimezoneResultSetDataSource.java:52) ~[jasperserver-api-engine-impl-8.1.0.jar:?]
                at com.jaspersoft.commons.util.JSControlledResultSetDataSource.next(JSControlledResultSetDataSource.java:33) ~[ji-datarator-8.1.0.jar:?]
                at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1572) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1415) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1394) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1201) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:622) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:826) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]
                ... 3 more
2023-06-02T09:05:37,214 ERROR SecureExceptionHandlerImpl,pool-19-thread-2:125 [] - Auf dem Server ist ein Fehler aufgetreten. Versuchen Sie es erneut, oder wenden Sie sich an die Siteadministratoren.
com.jaspersoft.jasperserver.api.ErrorDescriptorException: Auf dem Server ist ein Fehler aufgetreten. Versuchen Sie es erneut, oder wenden Sie sich an die Siteadministratoren.
                at com.jaspersoft.jasperserver.remote.services.ReportExecution.getFinalReportUnitResult(ReportExecution.java:173) ~[jasperserver-remote-services-8.1.0.jar:?]
                at com.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl$2.run(RunReportServiceImpl.java:498) [jasperserver-remote-services-8.1.0.jar:?]
                at com.jaspersoft.jasperserver.api.logging.util.LoggableExecutorService$1.run(LoggableExecutorService.java:84) [jasperserver-api-metadata-impl-8.1.0.jar:?]
                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
                at java.lang.Thread.run(Thread.java:829) [?:?]