Hi,
I am checking out mifosx reporting and seems like after clicking export in the customer transactions the report does not load. The other reports load well. I have narrowed it downs to an issue with subreport parameters. I have read the documentation on pentaho about the subreport parameters and they all look correct. This is the log May 11 19:16:38 fincbs java[12081]: 2023-05-11 19:16:38.284 INFO 12081 --- [o-8443-exec-100] i.r.s.PentahoReportingProcessServiceImpl : Report path: /root/.mifosx/pentahoReports/Client Loan Account Schedule.prpt May 11 19:16:38 fincbs java[12081]: 2023-05-11 19:16:38.549 INFO 12081 --- [o-8443-exec-100] i.r.s.PentahoReportingProcessServiceImpl : paramName:selectLoan May 11 19:16:38 fincbs java[12081]: 2023-05-11 19:16:38.550 INFO 12081 --- [o-8443-exec-100] i.r.s.PentahoReportingProcessServiceImpl : addParametersToReport(selectLoan : 0000582 : java.lang.String) May 11 19:16:38 fincbs java[12081]: 2023-05-11 19:16:38.550 INFO 12081 --- [o-8443-exec-100] i.r.s.PentahoReportingProcessServiceImpl : paramName:startDate May 11 19:16:38 fincbs java[12081]: 2023-05-11 19:16:38.550 INFO 12081 --- [o-8443-exec-100] i.r.s.PentahoReportingProcessServiceImpl : addParametersToReport(startDate : 2023-05-01 : java.sql.Date) May 11 19:16:38 fincbs java[12081]: 2023-05-11 19:16:38.550 INFO 12081 --- [o-8443-exec-100] i.r.s.PentahoReportingProcessServiceImpl : paramName:endDate May 11 19:16:38 fincbs java[12081]: 2023-05-11 19:16:38.550 INFO 12081 --- [o-8443-exec-100] i.r.s.PentahoReportingProcessServiceImpl : addParametersToReport(endDate : 2023-05-25 : java.sql.Date) May 11 19:16:38 fincbs java[12081]: 2023-05-11 19:16:38.550 INFO 12081 --- [o-8443-exec-100] i.r.s.PentahoReportingProcessServiceImpl : db URL:jdbc:mysql:thin://localhost:3306/fineract_default userhierarchy:. May 11 19:16:38 fincbs java[12081]: 2023-05-11 19:16:38.550 INFO 12081 --- [o-8443-exec-100] i.r.s.PentahoReportingProcessServiceImpl : db URL:jdbc:mysql:thin://localhost:3306/fineract_default userid:1 May 11 19:16:38 fincbs java[12081]: 2023-05-11 19:16:38.556 INFO 12081 --- [o-8443-exec-100] .p.r.e.c.c.l.o.PerformanceProgressLogger : [https-jsse-nio-8443-exec-100] Report Processing started. Free: 108118184; Total: 251396096 May 11 19:16:38 fincbs java[12081]: Warning: Nashorn engine is planned to be removed from a future JDK release May 11 19:16:38 fincbs java[12081]: message repeated 3 times: [ Warning: Nashorn engine is planned to be removed from a future JDK release] May 11 19:16:38 fincbs java[12081]: 2023-05-11 19:16:38.670 WARN 12081 --- [o-8443-exec-100] r.e.c.c.m.m.d.s.DriverConnectionProvider : Unable to load specified driver class: org.gjt.mm.mysql.Driver. See ObjectUtilities logger for error details. May 11 19:16:38 fincbs java[12081]: 2023-05-11 19:16:38.748 ERROR 12081 --- [o-8443-exec-100] o.p.r.e.c.c.l.o.AbstractReportProcessor : 1941212347: Report processing failed. May 11 19:16:38 fincbs java[12081]: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT May 11 19:16:38 fincbs java[12081]: det.id, May 11 19:16:38 fincbs java[12081]: det.dates as 'Date', May 11 19:16:38 fincbs java[12081]: ifnull(comments.Note,'-') as 'Note', May 11 19:16:38 fincbs java[12081]: det.Principle, May 11 19:16:38 fincbs java[12081]: det.Interest, May 11 19:16:38 fincbs java[12081]: det.Fees, May 11 19:16:38 fincbs java[12081]: det.Penalty, May 11 19:16:38 fincbs java[12081]: det.Total_Paid, May 11 19:16:38 fincbs java[12081]: det.Outstanding_Amount, May 11 19:16:38 fincbs java[12081]: det.Transaction_Type, May 11 19:16:38 fincbs java[12081]: det.Reversed, May 11 19:16:38 fincbs java[12081]: det.enu, May 11 19:16:38 fincbs java[12081]: det.account_no May 11 19:16:38 fincbs java[12081]: FROM ( May 11 19:16:38 fincbs java[12081]: select May 11 19:16:38 fincbs java[12081]: mtx.id, May 11 19:16:38 fincbs java[12081]: mtx.transaction_type_enum as 'enu', May 11 19:16:38 fincbs java[12081]: mtx.transaction_date as 'dates', May 11 19:16:38 fincbs java[12081]: case mtx.transaction_type_enum May 11 19:16:38 fincbs java[12081]: when 1 May 11 19:16:38 fincbs java[12081]: then IFNULL(mtx.amount,0) May 11 19:16:38 fincbs java[12081]: else ifnull(mtx.principal_portion_derived,0) May 11 19:16:38 fincbs java[12081]: end 'Principle', May 11 19:16:38 fincbs java[12081]: IFNULL(mtx.interest_portion_derived,0) as 'Interest', May 11 19:16:38 fincbs java[12081]: IFNULL(mtx.fee_charges_portion_derived,0) as 'Fees', May 11 19:16:38 fincbs java[12081]: IFNULL(mtx.penalty_charges_portion_derived,0) as "Penalty", May 11 19:16:38 fincbs java[12081]: IF(mtx.transaction_type_enum = 1,0, IFNULL(mtx.amount,0)) as "Total_Paid", May 11 19:16:38 fincbs java[12081]: (ml.principal_disbursed_derived + ml.interest_charged_derived + May 11 19:16:38 fincbs java[12081]: ml.fee_charges_charged_derived + May 11 19:16:38 fincbs java[12081]: ml.penalty_charges_charged_derived) as "Outstanding_Amount", May 11 19:16:38 fincbs java[12081]: ev.enum_value as "Transaction_Type", May 11 19:16:38 fincbs java[12081]: ml.account_no as "account_no", May 11 19:16:38 fincbs java[12081]: case mtx.is_reversed when 1 then 'Yes' else 'No' end Reversed May 11 19:16:38 fincbs java[12081]: from m_loan ml May 11 19:16:38 fincbs java[12081]: inner join m_loan_transaction mtx ON mtx.loan_id = ml.id May 11 19:16:38 fincbs java[12081]: inner join r_enum_value ev on ev.enum_id=mtx.transaction_type_enum and ev.enum_name="transaction_type_enum" May 11 19:16:38 fincbs java[12081]: where mtx.loan_id = (select ml.id from m_loan ml where ml.account_no=${SelectLoan}) May 11 19:16:38 fincbs java[12081]: and mtx.transaction_type_enum in (1,3,5,2,4) May 11 19:16:38 fincbs java[12081]: and mtx.is_reversed=0 May 11 19:16:38 fincbs java[12081]: #group by 1 May 11 19:16:38 fincbs java[12081]: ) det May 11 19:16:38 fincbs java[12081]: LEFT JOIN May 11 19:16:38 fincbs java[12081]: (SELECT a.id as comment_id, IFNULL(a.tid,( May 11 19:16:38 fincbs java[12081]: SELECT MIN(mtx.id) May 11 19:16:38 fincbs java[12081]: FROM m_loan_transaction mtx May 11 19:16:38 fincbs java[12081]: WHERE mtx.loan_id=(select ml.id from m_loan ml where ml.account_no=${selectLoan}))) as trx_id, May 11 19:16:38 fincbs java[12081]: a.note as "note" May 11 19:16:38 fincbs java[12081]: FROM ( May 11 19:16:38 fincbs java[12081]: SELECT mn.id as "id", May 11 19:16:38 fincbs java[12081]: mn.loan_transaction_id as "tid", May 11 19:16:38 fincbs java[12081]: #011#011mn.loan_id as "lid", May 11 19:16:38 fincbs java[12081]: #011#011mn.note as "Note" May 11 19:16:38 fincbs java[12081]: FROM m_note mn May 11 19:16:38 fincbs java[12081]: WHERE mn.id IN ( May 11 19:16:38 fincbs java[12081]: SELECT MAX(mn.id) May 11 19:16:38 fincbs java[12081]: FROM m_note mn May 11 19:16:38 fincbs java[12081]: WHERE mn.note_type_enum=200 May 11 19:16:38 fincbs java[12081]: GROUP BY mn.loan_id) UNION May 11 19:16:38 fincbs java[12081]: SELECT mn2.id, May 11 19:16:38 fincbs java[12081]: mn2.loan_transaction_id, May 11 19:16:38 fincbs java[12081]: mn2.loan_id, May 11 19:16:38 fincbs java[12081]: mn2.note May 11 19:16:38 fincbs java[12081]: FROM m_note mn2 May 11 19:16:38 fincbs java[12081]: WHERE mn2.note_type_enum=300) a May 11 19:16:38 fincbs java[12081]: WHERE a.lid=(select ml.id from m_loan ml where ml.account_no=${selectLoan}) May 11 19:16:38 fincbs java[12081]: ORDER BY a.lid,a.id) May 11 19:16:38 fincbs java[12081]: comments ON comments.trx_id=det.id May 11 19:16:38 fincbs java[12081]: WHERE det.dates between ${startDate} and ${endDate} May 11 19:16:38 fincbs java[12081]: ORDER BY CASE WHEN det.enu = 1 THEN 1 May 11 19:16:38 fincbs java[12081]: WHEN det.enu = 5 THEN 2 May 11 19:16:38 fincbs java[12081]: WHEN det.enu = 2 THEN 3 END,1,2 May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.Simpl eSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:183) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLRe portDataFactory.queryData(SQLReportDataFactory.java:142) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInt ernal(CompoundDataFactory.java:172) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(Co mpoundDataFactory.java:154) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInte rnal(CachingDataFactory.java:408) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStat ic(CachingDataFactory.java:151) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInt ernal(CompoundDataFactory.java:168) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(Co mpoundDataFactory.java:154) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInt ernal(CompoundDataFactory.java:168) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(Co mpoundDataFactory.java:154) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(Comp oundDataFactory.java:67) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowControll er.performQueryData(DefaultFlowController.java:251) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowControll er.performSubReportQuery(DefaultFlowController.java:311) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initia lizeForSubreport(ProcessState.java:560) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.states.process.InlineSubreportProc essor.processBandedSubReports(InlineSubreportProcessor.java:106) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.states.process.EndGroupHandler.com mit(EndGroupHandler.java:48) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.commit (ProcessState.java:946) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProces sor.processPrepareLevels(AbstractReportProcessor.java:407) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProces sor.performStructuralPreprocessing(AbstractReportProcessor.java:553) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProces sor.prepareReportProcessing(AbstractReportProcessor.java:467) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProces sor.processReport(AbstractReportProcessor.java:1433) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.modules.output.table.xls.ExcelRepo rtUtil.doProcess(ExcelReportUtil.java:210) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.modules.output.table.xls.ExcelRepo rtUtil.createXLS(ExcelReportUtil.java:184) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.modules.output.table.xls.ExcelRepo rtUtil.createXLS(ExcelReportUtil.java:163) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.mifosplatform.infrastructure.report.service.PentahoReportingProcessServi ceImpl.processRequest(PentahoReportingProcessServiceImpl.java:116) ~[classes!/:na] May 11 19:16:38 fincbs java[12081]: #011at org.apache.fineract.infrastructure.dataqueries.api.RunreportsApiResource.run Report(RunreportsApiResource.java:128) ~[classes!/:na] May 11 19:16:38 fincbs java[12081]: #011at jdk.internal.reflect.GeneratedMethodAccessor156.invoke(Unknown Source) ~[na:na] May 11 19:16:38 fincbs java[12081]: #011at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Delegatin gMethodAccessorImpl.java:43) ~[na:na] May 11 19:16:38 fincbs java[12081]: #011at java.base/java.lang.reflect.Method.invoke(Method.java:564) ~[na:na] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInv okerFactory.java:60) ~[jersey-server-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispa tchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvi der.java:205) ~[jersey-server-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatche r.dispatch(ResourceJavaMethodDispatcher.java:75) ~[jersey-server-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.ja va:302) ~[jersey-server-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathR ule.java:147) ~[jersey-server-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassR ule.java:108) ~[jersey-server-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathR ule.java:147) ~[jersey-server-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootReso urceClassesRule.java:84) ~[jersey-server-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(Web ApplicationImpl.java:1542) ~[jersey-server-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(Web ApplicationImpl.java:1473) ~[jersey-server-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebA pplicationImpl.java:1419) ~[jersey-server-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebA pplicationImpl.java:1409) ~[jersey-server-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java: 409) ~[jersey-servlet-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContain er.java:558) ~[jersey-servlet-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContain er.java:733) ~[jersey-servlet-1.19.4.jar!/:1.19.4] May 11 19:16:38 fincbs java[12081]: #011at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:231) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:166) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:193) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:166) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.access.intercept.FilterSecurityInterceptor. invoke(FilterSecurityInterceptor.java:115) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.access.intercept.FilterSecurityInterceptor. doFilter(FilterSecurityInterceptor.java:90) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:193) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:166) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:320) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.access.intercept.FilterSecurityInterceptor. invoke(FilterSecurityInterceptor.java:115) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.access.intercept.FilterSecurityInterceptor. doFilter(FilterSecurityInterceptor.java:90) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter( ExceptionTranslationFilter.java:118) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.authentication.AnonymousAuthenticationFilte r.doFilter(AnonymousAuthenticationFilter.java:111) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.servletapi.SecurityContextHolderAwareReques tFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.apache.fineract.infrastructure.security.filter.InsecureTwoFactorAuthenti cationFilter.doFilter(InsecureTwoFactorAuthenticationFilter.java:75) ~[classes!/:na] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF ilter.java:113) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF ilter.java:113) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF ilter.java:113) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.context.SecurityContextPersistenceFilter.do Filter(SecurityContextPersistenceFilter.java:82) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFi lter(ChannelProcessingFilter.java:157) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterCha inProxy.java:215) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy. java:186) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:193) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:166) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:320) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.access.intercept.FilterSecurityInterceptor. invoke(FilterSecurityInterceptor.java:126) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.access.intercept.FilterSecurityInterceptor. doFilter(FilterSecurityInterceptor.java:90) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter( ExceptionTranslationFilter.java:118) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.authentication.AnonymousAuthenticationFilte r.doFilter(AnonymousAuthenticationFilter.java:111) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.servletapi.SecurityContextHolderAwareReques tFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.apache.fineract.infrastructure.security.filter.InsecureTwoFactorAuthenti cationFilter.doFilter(InsecureTwoFactorAuthenticationFilter.java:75) ~[classes!/:na] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(He aderWriterFilter.java:92) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal( HeaderWriterFilter.java:77) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF ilter.java:119) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.context.request.async.WebAsyncManagerIntegr ationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF ilter.java:119) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.authentication.www.BasicAuthenticationFilte r.doFilterInternal(BasicAuthenticationFilter.java:204) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.apache.fineract.infrastructure.security.filter.TenantAwareBasicAuthentic ationFilter.doFilterInternal(TenantAwareBasicAuthenticationFilter.java:144) ~[classes!/:na] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF ilter.java:119) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.context.SecurityContextPersistenceFilter.do Filter(SecurityContextPersistenceFilter.java:105) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFi lter(ChannelProcessingFilter.java:157) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte r(FilterChainProxy.java:334) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterCha inProxy.java:215) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy. java:178) ~[spring-security-web-5.3.3.RELEASE.jar!/:5.3.3.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(Delegati ngFilterProxy.java:358) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilt erProxy.java:271) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:193) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:166) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doF ilterInternal(WebMvcMetricsFilter.java:93) ~[spring-boot-actuator-2.3.1.RELEASE.jar!/:2.3.1.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF ilter.java:119) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:193) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:166) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(Char acterEncodingFilter.java:201) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF ilter.java:119) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:193) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:166) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.ForwardedHeaderFilter.doFilterInternal(Forwar dedHeaderFilter.java:158) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF ilter.java:119) ~[spring-web-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:193) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:166) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:202) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:96) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase .java:541) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139 ) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :74) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java :65) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtoco l.java:868) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.jav a:1590) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java: 49) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecut or.java:1130) ~[na:na] May 11 19:16:38 fincbs java[12081]: #011at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecu tor.java:630) ~[na:na] May 11 19:16:38 fincbs java[12081]: #011at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.ja va:61) ~[tomcat-embed-core-9.0.36.jar!/:9.0.36] May 11 19:16:38 fincbs java[12081]: #011at java.base/java.lang.Thread.run(Thread.java:832) ~[na:na] May 11 19:16:38 fincbs java[12081]: Caused by: java.sql.SQLException: Could not set parameter May 11 19:16:38 fincbs java[12081]: #011at org.drizzle.jdbc.internal.SQLExceptionMapper.getSQLException(SQLExceptionMap per.java:116) ~[drizzle-jdbc-1.4.jar!/:na] May 11 19:16:38 fincbs java[12081]: #011at org.drizzle.jdbc.DrizzlePreparedStatement.setParameter(DrizzlePreparedStatem ent.java:449) ~[drizzle-jdbc-1.4.jar!/:na] May 11 19:16:38 fincbs java[12081]: #011at org.drizzle.jdbc.DrizzlePreparedStatement.setString(DrizzlePreparedStatement .java:1096) ~[drizzle-jdbc-1.4.jar!/:na] May 11 19:16:38 fincbs java[12081]: #011at org.drizzle.jdbc.DrizzlePreparedStatement.setObject(DrizzlePreparedStatement .java:1502) ~[drizzle-jdbc-1.4.jar!/:na] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.Simpl eSQLReportDataFactory.parametrize(SimpleSQLReportDataFactory.java:379) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.Simpl eSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:27 6) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.Simpl eSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:178) ~[pentaho-reporting-engine-classic-core-7.0.0.6-95.jar!/:7.0.0.6-95.-1] May 11 19:16:38 fincbs java[12081]: #011... 140 common frames omitted May 11 19:16:38 fincbs java[12081]: Caused by: org.drizzle.jdbc.internal.common.query.IllegalParameterException: No '?' on that position May 11 19:16:38 fincbs java[12081]: #011at org.drizzle.jdbc.internal.common.query.DrizzleParameterizedQuery.setParamete r(DrizzleParameterizedQuery.java:74) ~[drizzle-jdbc-1.4.jar!/:na] May 11 19:16:38 fincbs java[12081]: #011at org.drizzle.jdbc.DrizzlePreparedStatement.setParameter(DrizzlePreparedStatem ent.java:447) ~[drizzle-jdbc-1.4.jar!/:na] May 11 19:16:38 fincbs java[12081]: #011... 145 common frames omitted