Shruthi thank you. On Thu, Jul 12, 2018 at 9:14 AM, Shruthi M R < [email protected]> wrote:
> Hi Emmanuel, > > It looks like *'**sql_mode=only_full_group_by' is set. * > Change the SQL mode as per your requirement or set it to to null. > > Regards, > > *Shruthi M R* > Senior Software Engineer - Conflux Technologies > [email protected] | Skype: Shruthi Rajaram | Mobile: > +91-8277012716 > > On Thu, Jul 12, 2018 at 1:07 PM, Emmanuel Njoku <[email protected]> wrote: > >> Dear Team >> >> Please assist on the below error message on trying to open a disbursed >> loan. see below >> >> v1/loans/4","parameters":{"associations":["all"],"exclude":[ >> "guarantors,futureSchedule"]}} >> 373873 [http-bio-443-exec-3] ERROR o.s.b.context.web.ErrorPageFilter - >> Forwarding to error page from request [/api/v1/loans/4] due to exception >> [PreparedStatementCallback; bad SQL grammar [select dd.id as >> id,dd.expected_disburse_date as expectedDisbursementdate, >> dd.disbursedon_date as actualDisbursementdate,dd.principal as >> principal,sum(lc.amount) chargeAmount, lc.amount_waived_derived >> waivedAmount,group_concat(lc.id) loanChargeId from m_loan l inner join >> m_loan_disbursement_detail dd on dd.loan_id = l.id left join >> m_loan_tranche_disbursement_charge tdc on tdc.disbursement_detail_id=dd. >> id >> left join m_loan_charge lc on lc.id=tdc.loan_charge_id and >> lc.is_active=1 >> where dd.loan_id=? group by dd.id order by dd.expected_disburse_date]; >> nested exception is >> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #6 >> of >> SELECT list is not in GROUP BY clause and contains nonaggregated column >> 'mifostenant-default.lc.amount_waived_derived' which is not functionally >> dependent on columns in GROUP BY clause; this is incompatible with >> sql_mode=only_full_group_by] >> org.springframework.jdbc.BadSqlGrammarException: >> PreparedStatementCallback; >> bad SQL grammar [select dd.id as id,dd.expected_disburse_date as >> expectedDisbursementdate, dd.disbursedon_date as >> actualDisbursementdate,dd.principal as principal,sum(lc.amount) >> chargeAmount, lc.amount_waived_derived waivedAmount,group_concat(lc.id) >> loanChargeId from m_loan l inner join m_loan_disbursement_detail dd on >> dd.loan_id = l.id left join m_loan_tranche_disbursement_charge tdc on >> tdc.disbursement_detail_id=dd.id left join m_loan_charge lc on >> lc.id=tdc.loan_charge_id >> and lc.is_active=1 where dd.loan_id=? group by dd.id order by >> dd.expected_disburse_date]; nested exception is >> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #6 >> of >> SELECT list is not in GROUP BY clause and contains nonaggregated column >> 'mifostenant-default.lc.amount_waived_derived' which is not functionally >> dependent on columns in GROUP BY clause; this is incompatible with >> sql_mode=only_full_group_by >> at >> org.springframework.jdbc.support.SQLExceptionSubclassTransla >> tor.doTranslate(SQLExceptionSubclassTranslator.java:91) >> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] >> at >> org.springframework.jdbc.support.AbstractFallbackSQLExceptio >> nTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) >> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] >> at >> org.springframework.jdbc.support.AbstractFallbackSQLExceptio >> nTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) >> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] >> at >> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660) >> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] >> at >> org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695) >> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] >> at >> org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727) >> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] >> at >> org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737) >> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] >> at >> org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:792) >> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] >> at >> org.apache.fineract.portfolio.loanaccount.service.LoanReadPl >> atformServiceImpl.retrieveLoanDisbursementDetails( >> LoanReadPlatformServiceImpl.java:1534) >> ~[classes/:na] >> at >> org.apache.fineract.portfolio.loanaccount.api.LoansApiResour >> ce.retrieveLoan(LoansApiResource.java:470) >> ~[classes/:na] >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> ~[na:1.8.0_171] >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce >> ssorImpl.java:62) >> ~[na:1.8.0_171] >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe >> thodAccessorImpl.java:43) >> ~[na:1.8.0_171] >> at java.lang.reflect.Method.invoke(Method.java:498) >> ~[na:1.8.0_171] >> at >> com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invo >> ke(JavaMethodInvokerFactory.java:60) >> ~[jersey-server-1.17.jar:1.17] >> at >> com.sun.jersey.server.impl.model.method.dispatch.AbstractRes >> ourceMethodDispatchProvider$TypeOutInvoker._dispatch(Abstr >> actResourceMethodDispatchProvider.java:185) >> ~[jersey-server-1.17.jar:1.17] >> at >> com.sun.jersey.server.impl.model.method.dispatch.ResourceJav >> aMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) >> ~[jersey-server-1.17.jar:1.17] >> >> >> On Tue, Jul 10, 2018 at 4:44 PM, Sanyam Goel <[email protected]> >> wrote: >> >> > Hi Anwesh, >> > >> > For checking the swagger documentation, you have to setup the Fineract >> PR >> > #409, https://github.com/apache/fineract/pull/409 >> > You can also check out the report of the swagger project, for accessing >> > the swagger JSON and Swagger UI. >> > Swagger Report: https://goo.gl/8RMMhN >> > >> > I will also provide you the swagger JSON, which can be easily used in >> swagger >> > Editor <https://editor.swagger.io/> for UI in a day or two >> > >> > Let me know if you face any problems in the setup of swagger docs. >> > >> > Thanks, >> > Sanyam >> > >> > On Tue, Jul 10, 2018 at 6:18 AM Ed Cable <[email protected]> wrote: >> > >> >> Including Fineract Dev list too. >> >> >> >> Anwesh, >> >> >> >> Those should be mostly up to date except for some of the new >> self-service >> >> APIs. I'll let others reply. Sanyam - can you provide link to you >> Swagger >> >> docs too? >> >> >> >> On Mon, Jul 9, 2018 at 3:49 PM Anwesh Krishna Nayak < >> >> [email protected]> wrote: >> >> >> >>> Hi Community, >> >>> >> >>> While working with Fineract API docs[1] I found most of the relevant >> >>> APIs are not documented or missing. Or information in certain >> sections is >> >>> incomplete. >> >>> >> >>> Could anyone guide me to the repository from where API docs are >> hosted? >> >>> So I could make the respective changes. >> >>> >> >>> Thanks >> >>> >> >>> >> >>> [1] . https://demo.openmf.org/api-docs/apiLive.htm >> >>> >> >> >> >> >> >> -- >> >> *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> >> >> >> >> >> > >> > -- >> > SANYAM GOEL >> > Profile: plu.us/sanyam96 >> > LinkedIn: https://goo.gl/NkmHkf >> > Github: https://goo.gl/STw1Rq >> > Hackerrank: https://goo.gl/va9Npm >> > +91-9818060934 >> > >> > ------------------------------------------------------------ >> > ------------------ >> > Check out the vibrant tech community on one of the world's most >> > engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> > Mifos-developer mailing list >> > [email protected] >> > Unsubscribe or change settings at: >> > https://lists.sourceforge.net/lists/listinfo/mifos-developer >> > >> > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > Mifos-developer mailing list > [email protected] > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer >
