Dear All I tried to incorporate a pentaho report to my fineract local repository based on the PR sent by Francis Guchie . Having run the fineract engine, I tried to open trial balance from community app. I got the following error stacktrace. I am looking for help
org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: select -1 as id,'All' as name union select id,name from m_office at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:258) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:171) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:434) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:326) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.parameters.DefaultListParameter.getValues(DefaultListParameter.java:119) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator.computeValidListValue(DefaultReportParameterValidator.java:318) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator.validateSingleParameter(DefaultReportParameterValidator.java:256) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator.validate(DefaultReportParameterValidator.java:140) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:183) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:477) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1647) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.modules.output.table.html.HtmlReportUtil.createStreamHTML(HtmlReportUtil.java:111) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.apache.fineract.infrastructure.report.service.PentahoReportingProcessServiceImpl.processRequest(PentahoReportingProcessServiceImpl.java:149) ~[main/:na] at org.apache.fineract.infrastructure.dataqueries.api.RunreportsApiResource.runReport(RunreportsApiResource.java:128) ~[main/:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na] at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na] at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) ~[jersey-servlet-1.19.4.jar:1.19.4] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558) ~[jersey-servlet-1.19.4.jar:1.19.4] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733) ~[jersey-servlet-1.19.4.jar:1.19.4] at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[tomcat-embed-core-9.0.37.jar:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.apache.fineract.infrastructure.security.filter.InsecureTwoFactorAuthenticationFilter.doFilter(InsecureTwoFactorAuthenticationFilter.java:75) ~[main/:na] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113) ~[spring-web-5.2.6.RELEASE.jar:5.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113) ~[spring-web-5.2.6.RELEASE.jar:5.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113) ~[spring-web-5.2.6.RELEASE.jar:5.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:82) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:157) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:186) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.apache.fineract.infrastructure.security.filter.InsecureTwoFactorAuthenticationFilter.doFilter(InsecureTwoFactorAuthenticationFilter.java:75) ~[main/:na] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.6.RELEASE.jar:5.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.6.RELEASE.jar:5.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:204) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.apache.fineract.infrastructure.security.filter.TenantAwareBasicAuthenticationFilter.doFilterInternal(TenantAwareBasicAuthenticationFilter.java:144) ~[main/:na] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.6.RELEASE.jar:5.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:157) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) ~[spring-security-web-5.3.4.RELEASE.jar:5.3.4.RELEASE] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358) ~[spring-web-5.2.6.RELEASE.jar:5.2.6.RELEASE] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271) ~[spring-web-5.2.6.RELEASE.jar:5.2.6.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93) ~[spring-boot-actuator-2.3.3.RELEASE.jar:2.3.3.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.6.RELEASE.jar:5.2.6.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.6.RELEASE.jar:5.2.6.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.6.RELEASE.jar:5.2.6.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:103) ~[spring-web-5.2.6.RELEASE.jar:5.2.6.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[na:na] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[na:na] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.37.jar:9.0.37] at java.base/java.lang.Thread.run(Thread.java:834) ~[na:na] On Thu, Aug 20, 2020 at 9:22 PM kaitesi maureen <[email protected]> wrote: > Well done and thank you for sharing @Francis > > On Thu, 20 Aug 2020 at 21:21, Francis Guchie <[email protected]> > wrote: > >> Dear Ed, >> >> I think this thread has reached its peaceful end. Thank you for the >> support >> >> >> My Kind Regards >> >> Francis Guchie Kirago >> *Skype:* francisguchie >> *Whatsapp: *232 79 19 44 07 >> *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >> twitter: @FrancisGuchie >> >> >> >> >> >> >> >> >> >> On Thu, Aug 20, 2020 at 6:19 PM Francis Guchie <[email protected]> >> wrote: >> >>> Dear All, >>> >>> For all those interested in using pentaho reports in the latest build, >>> please note the following >>> >>> 1. follow the discussion here >>> >>> >>> >>> https://github.com/apache/fineract/pull/1262 >>> 2. Fineract will not ship with Pentaho reports and thus whoever >>> wants to use them can add them on their own you can use the branch >>> https://github.com/francisguchie/fineract/tree/pentahoReports at an >>> individual Basis (I hope i am not violating any rules by sharing this) >>> 3. If you choose to go Pentaho, below are my findings >>> 1. tomcat 9.0.37 or above will be your best choice as i tried >>> 9.036 and 9.035 and i was having errors displaying the reports >>> 2. if you have tomcat 9.0.3x and you do not wish to redo your >>> work, you can simply use the jar files in the lib folder of tomcat >>> 9.0.37 >>> it worked for me on a tomcat9.0.35 >>> 4. I have test this on a windows PC and Ubuntu 18.04 Lts and i am >>> happy with the results >>> 1. Pentaho Reports with names that have no SQL keys words, >>> special characters and operands work well >>> 1. Examples of these are words like Select, AND, characters >>> like -, * ( will display and sql inject error when a user is >>> trying to add >>> the report >>> >>> Enjoy >>> >>> >>> My Kind Regards >>> >>> Francis Guchie Kirago >>> *Skype:* francisguchie >>> *Whatsapp: *232 79 19 44 07 >>> *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >>> twitter: @FrancisGuchie >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> On Thu, Aug 20, 2020 at 12:36 AM Francis Guchie <[email protected]> >>> wrote: >>> >>>> Petri, Luis and all >>>> >>>> Thank you for the advise, I have managed to Raise the PR here >>>> https://github.com/apache/fineract/pull/1262 >>>> >>>> Next Steps >>>> >>>> - Making sure the reports with no errors load ( *When i use my >>>> Windows PC, this works very well - reports with "non-bad Names" and >>>> those >>>> with no data integrity issues are displayed *) I am still trying >>>> to figure out why this is not the same for Ubuntu 18.04 LTS >>>> - Making Corrections of the Names and editing errors in all / a >>>> good number of Pentaho Reports >>>> >>>> For now i can gladly wait for reviewers of the PR i have raised - as i >>>> see -- All checks have passed >>>> >>>> >>>> >>>> My Kind Regards >>>> >>>> Francis Guchie Kirago >>>> *Skype:* francisguchie >>>> *Whatsapp: *232 79 19 44 07 >>>> *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >>>> twitter: @FrancisGuchie >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> On Tue, Aug 18, 2020 at 8:22 PM Francis Guchie <[email protected]> >>>> wrote: >>>> >>>>> Petri, >>>>> >>>>> No I have not tried this. Let me try it and let you know. >>>>> >>>>> >>>>> >>>>> >>>>> My Kind Regards >>>>> >>>>> Francis Guchie Kirago >>>>> >>>>> Skype: francisguchie >>>>> Whatsapp: 232 79 19 44 07 >>>>> LINKEDIN: https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >>>>> twitter: @FrancisGuchie >>>>> >>>>> >>>>> >>>>> >>>>> On Tue, Aug 18, 2020, 15:18 Ed Cable <[email protected]> wrote: >>>>> >>>>>> Thanks Petri. Sorry that I had duplicated Francis' thread. >>>>>> >>>>>> Ed >>>>>> >>>>>> On Tue, Aug 18, 2020 at 8:13 AM Petri Tuomola <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> Hi Francis >>>>>>> >>>>>>> If this is a valid and harmless duplicate (i.e. all the JARs include >>>>>>> "overview.html" but that doesn't affect the functionality), you can >>>>>>> exclude >>>>>>> the relevant files from the duplicate check by adding them to the >>>>>>> function >>>>>>> org.apache.fineract.infrastructure.classdupes. >>>>>>> ClasspathHellDuplicatesChecker.isHarmlessDuplicate() >>>>>>> >>>>>>> Have you tried this to resolve your issue? >>>>>>> >>>>>>> Regards >>>>>>> Petri >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Tue, Aug 18, 2020 at 1:09 PM Francis Guchie < >>>>>>> [email protected]> wrote: >>>>>>> >>>>>>>> Dear All, >>>>>>>> >>>>>>>> We would like to see Pentaho Reports available in the next release. >>>>>>>> Support for Pentaho was discontinued due to License issues (Personally >>>>>>>> i >>>>>>>> don't know how the license issues affect as no details where provided >>>>>>>> where >>>>>>>> i read this note) >>>>>>>> >>>>>>>> At the moment MifosX is compatible with Pentaho 3.9.1-GA / 3.9.1.1 >>>>>>>> >>>>>>>> Luis and I have tried to add Pentaho Reports into the latest build >>>>>>>> and here are our branches mine >>>>>>>> https://github.com/francisguchie/fineract/tree/supportPentahoReports >>>>>>>> and >>>>>>>> that of Luis >>>>>>>> https://github.com/luisalegria/fineract-1/tree/19.14Pentaho >>>>>>>> >>>>>>>> In both cases, using the following environments on a Windows 10 >>>>>>>> Ent- 64bit PC >>>>>>>> >>>>>>>> 1. gradle 6.5.1 >>>>>>>> 2. Jdk 11.0.8 >>>>>>>> 3. node v14.4.0 >>>>>>>> 4. npm v 6.14.5 >>>>>>>> 5. kotlin 1.3.72 >>>>>>>> 6. groovy 2.5.11 >>>>>>>> >>>>>>>> >>>>>>>> when i run ./gradlew clean build (one of the conditions to be >>>>>>>> checked before a PR is raised) I do get the error below >>>>>>>> >>>>>>>> org.opentest4j.AssertionFailedError: 3 Classpath duplicates detected: >>>>>>>> >>>>>>>> overview.html >>>>>>>> >>>>>>>> >>>>>>>> jar:file:/C:/Users/..../org.mnode.ical4j/ical4j/3.0.19/5aa648ce509674af21b3a46ce1efb5aa3300b651/ical4j-3.0.19.jar!/overview.html >>>>>>>> >>>>>>>> >>>>>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-classic-core/3.9.1.1/77036efc94f1bab8dfe07bfdcf28cb4cdc4dcc46/pentaho-reporting-engine-classic-core-3.9.1.1.jar!/overview.html >>>>>>>> >>>>>>>> >>>>>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-classic-extensions/3.9.1-GA/24114228757a9325f4b4e4899471413f6ae90d2c/pentaho-reporting-engine-classic-extensions-3.9.1-GA.jar!/overview.html >>>>>>>> >>>>>>>> >>>>>>>> jar:file:/C:/Users/..../pentaho-library/libfonts/1.2.8/8d20d16c7b4022480df8fb8aa7c51f6357ff1817/libfonts-1.2.8.jar!/overview.html >>>>>>>> >>>>>>>> >>>>>>>> jar:file:/C:/Users/..../pentaho-library/libserializer/1.2.8/52d4ccad3fa757ec040a3da34314d08c4a071332/libserializer-1.2.8.jar!/overview.html >>>>>>>> >>>>>>>> classic-engine.properties >>>>>>>> >>>>>>>> >>>>>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-classic-extensions/3.9.1-GA/24114228757a9325f4b4e4899471413f6ae90d2c/pentaho-reporting-engine-classic-extensions-3.9.1-GA.jar!/classic-engine.properties >>>>>>>> >>>>>>>> >>>>>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-classic-extensions-scripting/3.9.1-GA/174cce581a247680f24404e9ed6ef1fbfb53ae29/pentaho-reporting-engine-classic-extensions-scripting-3.9.1-GA.jar!/classic-engine.properties >>>>>>>> >>>>>>>> >>>>>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-wizard-core/3.9.1-GA/671508e5f7b038b19ddbdf34914eab87bbb646ee/pentaho-reporting-engine-wizard-core-3.9.1-GA.jar!/classic-engine.properties >>>>>>>> >>>>>>>> loader.properties >>>>>>>> >>>>>>>> >>>>>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-classic-core/3.9.1.1/77036efc94f1bab8dfe07bfdcf28cb4cdc4dcc46/pentaho-reporting-engine-classic-core-3.9.1.1.jar!/loader.properties >>>>>>>> >>>>>>>> >>>>>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-wizard-core/3.9.1-GA/671508e5f7b038b19ddbdf34914eab87bbb646ee/pentaho-reporting-engine-wizard-core-3.9.1-GA.jar!/loader.properties >>>>>>>> >>>>>>>> >>>>>>>> jar:file:/C:/Users/..../pentaho-library/libdocbundle/1.2.8/9bde3c7aa2154a08e6c7bfdfd6d35dc3b18d05aa/libdocbundle-1.2.8.jar!/loader.properties >>>>>>>> >>>>>>>> >>>>>>>> jar:file:/C:/Users/..../pentaho-library/libxml/1.2.8/60a57221b2f5b3ac5e8822bf14001640738a6ab/libxml-1.2.8.jar!/loader.properties >>>>>>>> >>>>>>>> >>>>>>>> I need help on this jarHell error >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> My Kind Regards >>>>>>>> >>>>>>>> Francis Guchie Kirago >>>>>>>> *Skype:* francisguchie >>>>>>>> *Whatsapp: *232 79 19 44 07 >>>>>>>> *LINKEDIN:* >>>>>>>> https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >>>>>>>> twitter: @FrancisGuchie >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>>> *Ed Cable* >>>>>> President/CEO, Mifos Initiative >>>>>> [email protected] | Skype: edcable | Mobile: +1.484.477.8649 >>>>>> >>>>>> *Collectively Creating a World of 3 Billion Maries | * >>>>>> http://mifos.org <http://facebook.com/mifos> >>>>>> <http://www.twitter.com/mifos> >>>>>> >>>>>> >>>>>> >>>>>> Mifos-developer mailing list >>>>>> >>>>>> >>>>>> [email protected] >>>>>> >>>>>> >>>>>> Unsubscribe or change settings at: >>>>>> >>>>>> >>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> Mifos-developer mailing list >> >> [email protected] >> >> Unsubscribe or change settings at: >> >> https://lists.sourceforge.net/lists/listinfo/mifos-developer > >
