[
https://issues.apache.org/jira/browse/FINERACT-1478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adam Saghy closed FINERACT-1478.
--------------------------------
Resolution: Abandoned
> 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 '= 'datatable', 'ZZZ', entity_name), entity_name' at line 1
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: FINERACT-1478
> URL: https://issues.apache.org/jira/browse/FINERACT-1478
> Project: Apache Fineract
> Issue Type: Bug
> Affects Versions: 1.6.0
> Reporter: Michael Vorburger
> Priority: Blocker
> Attachments: LocalFineractDemoTest.postman_collection.json
>
>
> See FINERACT-932 for general background; I've found this in logs of
> 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 '= 'datatable', 'ZZZ', entity_name), entity_name' 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:256)
> at org.mariadb.jdbc.MariaDbStatement.executeInternal
> (MariaDbStatement.java:357)
> at org.mariadb.jdbc.MariaDbStatement.executeQuery (MariaDbStatement.java:612)
> at com.zaxxer.hikari.pool.ProxyStatement.executeQuery
> (ProxyStatement.java:110)
> at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery
> (HikariProxyStatement.java)
> at
> org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement
> (JdbcTemplate.java:452)
> at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:381)
> at org.springframework.jdbc.core.JdbcTemplate.query (JdbcTemplate.java:465)
> at org.springframework.jdbc.core.JdbcTemplate.query (JdbcTemplate.java:475)
> at
> org.apache.fineract.commands.service.AuditReadPlatformServiceImpl.retrieveSearchTemplate
> (AuditReadPlatformServiceImpl.java:452)
> at
> org.apache.fineract.commands.api.MakercheckersApiResource.retrieveAuditSearchTemplate
> (MakercheckersApiResource.java:133)
> 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. (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.10#820010)
