[FINERACT-1479] 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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.6.0
• Assignee: Unassigned
• Reporter: Michael Vorburger
• Created: 05/Jan/22 03:05
• Updated: 05/Jan/22 13:39

Description

See FINERACT-932 for general background; I've found this in logs of https://www.fineract.dev:

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)

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.)

Issue Links

• blocks: FINERACT-932 Parent Issue for Error Logs seeing during "normal" usage (e.g. on fineract.dev)