Hi Njoku, It's customary to provide links to your errors from a paste service like https://pastebin.com .
Cheers, Isaac Kamga. On Thu, Jul 12, 2018 at 10:19 AM Emmanuel Njoku <[email protected]> wrote: > 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 > > >
