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.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:91)
~[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.support.AbstractFallbackSQLExceptionTranslator.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.LoanReadPlatformServiceImpl.retrieveLoanDisbursementDetails(LoanReadPlatformServiceImpl.java:1534)
~[classes/:na]
at
org.apache.fineract.portfolio.loanaccount.api.LoansApiResource.retrieveLoan(LoansApiResource.java:470)
~[classes/:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_171]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_171]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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.invoke(JavaMethodInvokerFactory.java:60)
~[jersey-server-1.17.jar:1.17]
at
com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
~[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]
On Tue, Jul 10, 2018 at 4:44 PM, Sanyam Goel <sanyam.bvco...@gmail.com>
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 <edca...@mifos.org> 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 <
>> anweshkna...@gmail.com> 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
>> edca...@mifos.org | 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-develo...@lists.sourceforge.net
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>
