Michael Vorburger created FINERACT-1479:
-------------------------------------------
Summary: java.sql.SQLException: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near 'of ON of.id = cl.office_id AND of.hierarchy like '.%'
LEFT JOIN m_product_loan ' at line 1
Key: FINERACT-1479
URL: https://issues.apache.org/jira/browse/FINERACT-1479
Project: Apache Fineract
Issue Type: Bug
Affects Versions: 1.6.0
Reporter: Michael Vorburger
See FINERACT-932 for general background; I've found this in logs of
[https://www.fineract.dev:|https://www.fineract.dev/]
{noformat}java.sql.SQLException: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right syntax
to use near 'of ON of.id = cl.office_id AND of.hierarchy like '.%' LEFT JOIN
m_product_loan ' at line 1
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket
(AbstractQueryProtocol.java:1694)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket
(AbstractQueryProtocol.java:1556)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult
(AbstractQueryProtocol.java:1519)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery
(AbstractQueryProtocol.java:318)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal
(ClientSidePreparedStatement.java:220)
at org.mariadb.jdbc.ClientSidePreparedStatement.execute
(ClientSidePreparedStatement.java:149)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery
(ClientSidePreparedStatement.java:163)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery
(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery
(HikariProxyPreparedStatement.java)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement
(JdbcTemplate.java:722)
at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.query (JdbcTemplate.java:713)
at org.springframework.jdbc.core.JdbcTemplate.query (JdbcTemplate.java:738)
at org.springframework.jdbc.core.JdbcTemplate.query (JdbcTemplate.java:794)
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query
(NamedParameterJdbcTemplate.java:209)
at
org.apache.fineract.portfolio.collectionsheet.service.CollectionSheetReadPlatformServiceImpl.generateIndividualCollectionSheet
(CollectionSheetReadPlatformServiceImpl.java:696)
at
org.apache.fineract.portfolio.collectionsheet.api.CollectionSheetApiResourse.generateCollectionSheet
(CollectionSheetApiResourse.java:102)
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:62)
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke (Method.java:566)
at
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0
(ResourceMethodInvocationHandlerFactory.java:52)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run
(AbstractJavaResourceMethodDispatcher.java:124)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke
(AbstractJavaResourceMethodDispatcher.java:167)
at
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch
(JavaResourceMethodDispatcherProvider.java:219)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch
(AbstractJavaResourceMethodDispatcher.java:79)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke
(ResourceMethodInvoker.java:475)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply
(ResourceMethodInvoker.java:397)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply
(ResourceMethodInvoker.java:81)
at org.glassfish.jersey.server.ServerRuntime$1.run (ServerRuntime.java:255)
at org.glassfish.jersey.internal.Errors$1.call (Errors.java:248)
at org.glassfish.jersey.internal.Errors$1.call (Errors.java:244)
at org.glassfish.jersey.internal.Errors.process (Errors.java:292)
at org.glassfish.jersey.internal.Errors.process (Errors.java:274)
at org.glassfish.jersey.internal.Errors.process (Errors.java:244)
at org.glassfish.jersey.process.internal.RequestScope.runInScope
(RequestScope.java:265)
at org.glassfish.jersey.server.ServerRuntime.process (ServerRuntime.java:234)
at org.glassfish.jersey.server.ApplicationHandler.handle
(ApplicationHandler.java:684)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl (WebComponent.java:394)
at org.glassfish.jersey.servlet.WebComponent.service (WebComponent.java:346)
at org.glassfish.jersey.servlet.ServletContainer.service
(ServletContainer.java:366)
at org.glassfish.jersey.servlet.ServletContainer.service
(ServletContainer.java:319)
at org.glassfish.jersey.servlet.ServletContainer.service
(ServletContainer.java:205)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter (WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:162)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal
(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter
(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:162)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:327)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke
(FilterSecurityInterceptor.java:115)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter
(FilterSecurityInterceptor.java:81)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter
(ExceptionTranslationFilter.java:122)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter
(ExceptionTranslationFilter.java:116)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at org.springframework.security.web.session.SessionManagementFilter.doFilter
(SessionManagementFilter.java:126)
at org.springframework.security.web.session.SessionManagementFilter.doFilter
(SessionManagementFilter.java:81)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter
(AnonymousAuthenticationFilter.java:109)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter
(SecurityContextHolderAwareRequestFilter.java:149)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter
(RequestCacheAwareFilter.java:63)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at
org.apache.fineract.infrastructure.security.filter.InsecureTwoFactorAuthenticationFilter.doFilter
(InsecureTwoFactorAuthenticationFilter.java:80)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal
(BasicAuthenticationFilter.java:181)
at org.springframework.web.filter.OncePerRequestFilter.doFilter
(OncePerRequestFilter.java:119)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter
(LogoutFilter.java:103)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter
(LogoutFilter.java:89)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter
(HeaderWriterFilter.java:90)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal
(HeaderWriterFilter.java:75)
at org.springframework.web.filter.OncePerRequestFilter.doFilter
(OncePerRequestFilter.java:119)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal
(BasicAuthenticationFilter.java:181)
at
org.apache.fineract.infrastructure.security.filter.TenantAwareBasicAuthenticationFilter.doFilterInternal
(TenantAwareBasicAuthenticationFilter.java:144)
at org.springframework.web.filter.OncePerRequestFilter.doFilter
(OncePerRequestFilter.java:119)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter
(SecurityContextPersistenceFilter.java:110)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter
(SecurityContextPersistenceFilter.java:80)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at
org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal
(WebAsyncManagerIntegrationFilter.java:55)
at org.springframework.web.filter.OncePerRequestFilter.doFilter
(OncePerRequestFilter.java:119)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at
org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter
(ChannelProcessingFilter.java:133)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy.java:336)
at org.springframework.security.web.FilterChainProxy.doFilterInternal
(FilterChainProxy.java:211)
at org.springframework.security.web.FilterChainProxy.doFilter
(FilterChainProxy.java:183)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate
(DelegatingFilterProxy.java:358)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter
(DelegatingFilterProxy.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:162)
at
org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal
(WebMvcMetricsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter
(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:162)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal
(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter
(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:162)
at org.springframework.web.filter.ForwardedHeaderFilter.doFilterInternal
(ForwardedHeaderFilter.java:156)
at org.springframework.web.filter.OncePerRequestFilter.doFilter
(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke
(AuthenticatorBase.java:540)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:357)
at org.apache.coyote.http11.Http11Processor.service (Http11Processor.java:382)
at org.apache.coyote.AbstractProcessorLight.process
(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process
(AbstractProtocol.java:895)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun
(NioEndpoint.java:1722)
at org.apache.tomcat.util.net.SocketProcessorBase.run
(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker
(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run
(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run
(TaskThread.java:61)
at java.lang.Thread.run (Thread.java:829){noformat}
[~ptuomola] or [~aleks] or [~awasum] perhaps digging into and finding a
solution for this interests you, or you want to point anyone at this issue. (I
won't be working on this, I'm just filing issues for what I find in the
Fineract.dev logs.)
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
