Hello Sampath,
Please find below the details requested:
MySQL : 5.7.20-0ubuntu0.16.04.1Java: 1.8.0_144Tomcat: 7.0.68
Probably this log from tomcat may also help. On Tuesday, December 5, 2017,
10:55:41 AM GMT+4, Sampath Kumar G <[email protected]> wrote:
Hi Manuel,
Could you please provide the details of MySQL/Tomcat/Java version installed on
your machine. Also, the link you referred to set up the Mifos X v17.07.01.
Regards,Sampath
Conflux Technologies Pvt Ltd
#304, 2nd Floor, 7th Main Road
HRBR Layout 1st Block
Bengaluru, Karnataka, 560043 INDIA
Disclaimer: The information contained in this e-mail message and any
files/attachment transmitted with it is confidential and for the sole use of
the intended recipient(s) or entity identified. If you are not the intended
recipient, please email: [email protected] and destroy/delete all
copies and attachment thereto along with the original message. Any unauthorised
review, use, disclosure, dissemination, forwarding, printing or copying of this
email or any action taken in reliance on this e-mail is strictly prohibited and
is unlawful. The recipient acknowledges that Conflux Technologies Private
Limited or its subsidiaries and associated companies are unable to exercise
control or ensure or guarantee the integrity of/over the contents of the
information contained in e-mail transmissions. Before opening any attachments,
please check.
On Tue, Dec 5, 2017 at 12:12 PM, Manuel <[email protected]> wrote:
My loan report fields do not load and does not display any error message.
Please look at the two screenshot for context. The working one is from the demo
server.
nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
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 '{officeId}
and (l.currency_code = "${currencyId}" or "-1" = "${currencyId}")
a' at line 38
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:413)
~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:468)
~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:523)
~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
at
org.apache.fineract.infrastructure.dataqueries.service.GenericDataServiceImpl.fillGenericResultSet(GenericDataServiceImpl.java:59)
~[classes/:na]
at
org.apache.fineract.infrastructure.dataqueries.service.ReadReportingServiceImpl.retrieveGenericResultset(ReadReportingServiceImpl.java:175)
~[classes/:na]
at
org.apache.fineract.infrastructure.dataqueries.api.RunreportsApiResource.runReport(RunreportsApiResource.java:121)
~[classes/:na]
at sun.reflect.GeneratedMethodAccessor183.invoke(Unknown Source)
~[na:na]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_144]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_144]
at
com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
~[jersey-servlet-1.17.jar:1.17]
at
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
~[jersey-servlet-1.17.jar:1.17]
at
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
~[jersey-servlet-1.17.jar:1.17]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
~[tomcat-servlet-api-3.0.jar:na]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
~[tomcat7-websocket.jar:7.0.81]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:108)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
[spring-web-4.0.8.RELEASE.jar:4.0.8.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.apache.fineract.infrastructure.security.filter.TenantAwareBasicAuthenticationFilter.doFilter(TenantAwareBasicAuthenticationFilter.java:150)
~[classes/:na]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.springframework.boot.context.web.ErrorPageFilter.doFilter(ErrorPageFilter.java:108)
[spring-boot-1.1.6.RELEASE.jar:1.1.6.RELEASE]
at
org.springframework.boot.context.web.ErrorPageFilter.access$000(ErrorPageFilter.java:58)
[spring-boot-1.1.6.RELEASE.jar:1.1.6.RELEASE]
at
org.springframework.boot.context.web.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:87)
[spring-boot-1.1.6.RELEASE.jar:1.1.6.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
[spring-web-4.0.8.RELEASE.jar:4.0.8.RELEASE]
at
org.springframework.boot.context.web.ErrorPageFilter.doFilter(ErrorPageFilter.java:100)
[spring-boot-1.1.6.RELEASE.jar:1.1.6.RELEASE]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:221)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
[tomcat-catalina-7.0.68.jar:7.0.68]
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
[tomcat-coyote-7.0.68.jar:7.0.68]
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
[tomcat-coyote-7.0.68.jar:7.0.68]
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
[tomcat-coyote-7.0.68.jar:7.0.68]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[na:1.8.0_144]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[na:1.8.0_144]
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
[tomcat-coyote-7.0.68.jar:7.0.68]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_144]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '{officeId}
and (l.currency_code = "${currencyId}" or "-1" = "${currencyId}")
a' at line 38
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method) ~[na:1.8.0_144]
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
~[na:1.8.0_144]
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[na:1.8.0_144]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
~[na:1.8.0_144]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.Util.getInstance(Util.java:386)
~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
~[mysql-connector-java-5.1.27.jar:na]
at sun.reflect.GeneratedMethodAccessor139.invoke(Unknown Source)
~[na:na]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_144]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_144]
at
org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235)
~[tomcat-jdbc-7.0.55.jar:na]
at com.sun.proxy.$Proxy349.executeQuery(Unknown Source) ~[na:na]
at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:452)
~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:402)
~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
... 79 common frames omitted
23:01:56.569 [http-bio-443-exec-14] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457316557,"totalTime":12,"method":"POST","url":"https://10.1.13.25/fineract-provider/api/v1/authentication","parameters":{"username":["Ebenezer"]}}
23:02:10.831 [http-bio-443-exec-50] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457330784,"totalTime":47,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/makercheckers/searchtemplate","parameters":{}}
23:02:10.834 [http-bio-443-exec-52] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457330787,"totalTime":47,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/clients","parameters":{"limit":["1000"],"sqlSearch":["c.status_enum\u003d100"]}}
23:02:10.836 [http-bio-443-exec-45] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457330788,"totalTime":48,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/offices","parameters":{}}
23:02:10.837 [http-bio-443-exec-51] INFO
o.a.f.c.s.AuditReadPlatformServiceImpl - sql: select aud.id as id,
aud.action_name as actionName, aud.entity_name as entityName, aud.resource_id
as resourceId, aud.subresource_id as subresourceId,aud.client_id as clientId,
aud.loan_id as loanId, mk.username as maker, aud.made_on_date as madeOnDate,
aud.api_get_url as resourceGetUrl, ck.username as checker, aud.checked_on_date
as checkedOnDate, ev.enum_message_property as processingResult , o.name as
officeName, gl.level_name as groupLevelName, g.display_name as groupName,
c.display_name as clientName, l.account_no as loanAccountNo, s.account_no as
savingsAccountNo from m_portfolio_command_source aud left join m_appuser mk
on mk.id = aud.maker_id left join m_appuser ck on ck.id = aud.checker_id left
join m_office o on o.id = aud.office_id left join m_group g on g.id =
aud.group_id left join m_group_level gl on gl.id = g.level_id left join
m_client c on c.id = aud.client_id left join m_loan l on l.id = aud.loan_id
left join m_savings_account s on s.id = aud.savings_account_id left join
r_enum_value ev on ev.enum_name = 'processing_result_enum' and ev.enum_id =
aud.processing_result_enum where aud.processing_result_enum = 2 group by aud.id
order by aud.id
23:02:10.840 [http-bio-443-exec-51] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457330785,"totalTime":55,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/makercheckers","parameters":{}}
23:02:10.849 [http-bio-443-exec-14] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457330783,"totalTime":66,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/rescheduleloans","parameters":{"command":["pending"]}}
23:02:11.052 [http-bio-443-exec-48] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457331032,"totalTime":20,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/loans","parameters":{"limit":["1000"],"sqlSearch":["l.loan_status_id
in (100,200)"]}}
23:02:16.293 [http-bio-443-exec-34] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457336283,"totalTime":10,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/audits/188","parameters":{}}
23:02:19.392 [http-bio-443-exec-51] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457339054,"totalTime":338,"method":"POST","url":"https://10.1.13.25/fineract-provider/api/v1/makercheckers/188","parameters":{"command":["approve"]}}
23:02:22.100 [http-bio-443-exec-46] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457342079,"totalTime":21,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/clients","parameters":{"limit":["1000"],"sqlSearch":["c.status_enum\u003d100"]}}
23:02:22.102 [http-bio-443-exec-45] INFO
o.a.f.c.s.AuditReadPlatformServiceImpl - sql: select aud.id as id,
aud.action_name as actionName, aud.entity_name as entityName, aud.resource_id
as resourceId, aud.subresource_id as subresourceId,aud.client_id as clientId,
aud.loan_id as loanId, mk.username as maker, aud.made_on_date as madeOnDate,
aud.api_get_url as resourceGetUrl, ck.username as checker, aud.checked_on_date
as checkedOnDate, ev.enum_message_property as processingResult , o.name as
officeName, gl.level_name as groupLevelName, g.display_name as groupName,
c.display_name as clientName, l.account_no as loanAccountNo, s.account_no as
savingsAccountNo from m_portfolio_command_source aud left join m_appuser mk
on mk.id = aud.maker_id left join m_appuser ck on ck.id = aud.checker_id left
join m_office o on o.id = aud.office_id left join m_group g on g.id =
aud.group_id left join m_group_level gl on gl.id = g.level_id left join
m_client c on c.id = aud.client_id left join m_loan l on l.id = aud.loan_id
left join m_savings_account s on s.id = aud.savings_account_id left join
r_enum_value ev on ev.enum_name = 'processing_result_enum' and ev.enum_id =
aud.processing_result_enum where aud.processing_result_enum = 2 group by aud.id
order by aud.id
23:02:22.105 [http-bio-443-exec-45] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457342077,"totalTime":27,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/makercheckers","parameters":{}}
23:02:22.110 [http-bio-443-exec-14] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457342072,"totalTime":38,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/rescheduleloans","parameters":{"command":["pending"]}}
23:02:22.116 [http-bio-443-exec-29] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457342074,"totalTime":42,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/makercheckers/searchtemplate","parameters":{}}
23:02:22.117 [http-bio-443-exec-44] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457342078,"totalTime":39,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/offices","parameters":{}}
23:02:22.299 [http-bio-443-exec-44] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457342278,"totalTime":21,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/loans","parameters":{"limit":["1000"],"sqlSearch":["l.loan_status_id
in (100,200)"]}}
23:02:31.461 [http-bio-443-exec-52] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457351394,"totalTime":67,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/clients/1/charges","parameters":{"pendingPayment":["true"]}}
23:02:31.463 [http-bio-443-exec-48] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457351395,"totalTime":68,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/clients/1/notes","parameters":{}}
23:02:31.479 [http-bio-443-exec-41] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457351396,"totalTime":82,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/datatables","parameters":{"apptable":["m_client"]}}
23:02:31.480 [http-bio-443-exec-34] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457351394,"totalTime":86,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/clients/1/accounts","parameters":{}}
23:02:31.493 [http-bio-443-exec-51] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457351392,"totalTime":101,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/clients/1","parameters":{}}
23:02:31.501 [http-bio-443-exec-45] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457351392,"totalTime":109,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/clients/template","parameters":{}}
23:02:31.586 [http-bio-443-exec-29] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457351564,"totalTime":22,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/client/1/addresses","parameters":{}}
23:02:31.590 [http-bio-443-exec-46] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457351564,"totalTime":26,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/fieldconfiguration/ADDRESS","parameters":{}}
23:02:31.601 [http-bio-443-exec-52] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457351557,"totalTime":44,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/clients/1/documents","parameters":{}}
23:02:31.604 [http-bio-443-exec-50] INFO o.a.f.i.d.s.ReadReportingServiceImpl
- STARTING REPORT: ClientSummary Type: report
23:02:31.615 [http-bio-443-exec-50] INFO o.a.f.i.d.s.ReadReportingServiceImpl
- FINISHING Report/Request Name: ClientSummary - report Elapsed Time: 11
23:02:31.616 [http-bio-443-exec-50] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457351558,"totalTime":58,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/runreports/ClientSummary","parameters":{"genericResultSet":["false"],"R_clientId":["1"]}}
23:02:31.821 [http-bio-443-exec-48] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457351556,"totalTime":265,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/clients/1/images","parameters":{"maxHeight":["150"]}}
23:02:36.641 [http-bio-443-exec-34] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457356615,"totalTime":26,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/datatables","parameters":{"apptable":["m_loan"]}}
23:02:36.651 [http-bio-443-exec-50] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457356614,"totalTime":37,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/loans/5/notes","parameters":{}}
23:02:36.665 [http-bio-443-exec-29] DEBUG
o.a.f.p.a.s.AccountAssociationsReadPlatformServiceImpl - Linking account is not
configured
LoansApiResource.retrieveLoan() Time took: 27
LoansApiResource.retrieveLoan() Time took to Serialize: 1
23:02:36.672 [http-bio-443-exec-29] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457356614,"totalTime":57,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/loans/5","parameters":{"associations":["all"],"exclude":["guarantors,futureSchedule"]}}
23:02:36.800 [http-bio-443-exec-51] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457356788,"totalTime":12,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/standinginstructions/template","parameters":{"fromAccountType":["1"],"fromClientId":["1"],"fromAccountId":["5"]}}
23:02:52.069 [http-bio-443-exec-45] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457372008,"totalTime":61,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/loans/5/transactions/template","parameters":{"command":["prepayLoan"]}}
23:12:31.217 [http-bio-443-exec-46] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1512457951203,"totalTime":14,"method":"GET","url":"https://10.1.13.25/fineract-provider/api/v1/loans/10/documents","parameters":{}}
