osdir.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Mifos-developer] ERROR ON LOAN OPENING


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 <einjoku@xxxxxxxxx> wrote:

> Shruthi thank you.
>
> On Thu, Jul 12, 2018 at 9:14 AM, Shruthi M R <
> shruthi@xxxxxxxxxxxxxxxxxxxxxxx> 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
> > shruhti@xxxxxxxxxxxxxxxxxxxxxxx | Skype: Shruthi Rajaram | Mobile:
> > +91-8277012716
> >
> > On Thu, Jul 12, 2018 at 1:07 PM, Emmanuel Njoku <einjoku@xxxxxxxxx>
> 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 <sanyam.bvcoe96@xxxxxxxxx>
> >> 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 <edcable@xxxxxxxxx> 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 <
> >> >> anweshknayak@xxxxxxxxx> 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
> >> >> edcable@xxxxxxxxx | 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
> >> > mifos-developer@xxxxxxxxxxxxxxxxxxxxx
> >> > 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
> > mifos-developer@xxxxxxxxxxxxxxxxxxxxx
> > Unsubscribe or change settings at:
> > https://lists.sourceforge.net/lists/listinfo/mifos-developer
> >
>