You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Mexina Daniel <me...@singo.africa> on 2019/07/18 12:27:48 UTC
Re: [Mifos-developer] Some of the loan reports of pentaho are not
displaying
Hello
I have tried to continue following up on this,
My finds so far are,
-- Some of the Pentaho reports which include some parameters do not work.eg Pentaho loan reports
-- Some of Stretchy reports which have those parameters also do not work eg Aging Summary (Arrears in Months)
-- There is no any error logged on error log files.
-- When i inspect on the browser is see error 400 ( Bad Request) of the url that trying to fetch the parameters, and when i navigate further it shows the error is
{"developerMessage":"The request was invalid. This typically will happen due to validation errors which are provided.","httpStatusCode":"400","defaultUserMessage":"Unexpected SQL Commands found","userMessageGlobalisationCode":"error.msg.found.sql.injection"}
I have seen in some files in fineract source codes they have instructed to through error "error.msg.found.sql.injection" incase of some sql injection issues but i don't understand the relation to these reports and why they were okay in previous release.
Can some one help? This is real headache to us.
Thanks in advance.
> On June 4, 2019 at 5:41 PM Mua Rachmann <mu...@gmail.com> wrote:
>
> Hi Awasum, all
>
> I was suspecting this but haven't tried any front end methods yet. I followed the steps you mentioned here
> in order to solve the problem -
> https://mail.google.com/mail/u/0/#search/pentaho/FMfcgxwCgpfcktkcPtVchptTwsxlZwQZ
>
> And all seemed to work fine the backend loading some slow query, starting report and finishing report
> with no errors nor 404 response returned.
>
> On Tue, Jun 4, 2019 at 1:06 PM Awasum Yannick <awasum@apache.org mailto:awasum@apache.org > wrote:
>
> > > Hi All,
> >
> > Is it possible this is a front end error as I see a 4xx error on the console?
> >
> > On Tue, Jun 4, 2019 at 12:49 PM Mexina Daniel <me...@singo.africa> wrote:
> >
> > > > >
> > > Hello Sifiso and Shruthi
> > >
> > > From the response of Steve, i tried to return the parameter sql that was changed by the V345 script to the initial one ( The one without the condition of self_service_user_report) but still the report was not showing data.
> > >
> > > Seems there is something else which causing this.
> > >
> > > Regards
> > >
> > > > > > > On June 4, 2019 at 4:11 PM Shruthi M R <shruthi@confluxtechnologies.com mailto:shruthi@confluxtechnologies.com > wrote:
> > > >
> > > > Hi Mexina and Sifiso,
> > > >
> > > > I am not sure about the issues being faced, but w.r.t V345 please use below details,
> > > >
> > > > 1. Reason for adding the script - We have implemented self service user reports, in this if a report is marked true for `self_service_user_report' column in `stretchy_report` table, then only it should be displayed for self service user.
> > > > 2. Queries updated in the V345 script have extra condition r.self_service_user_report = \'${isSelfServiceUser}\' added, other than that no changes are made to existing queries. I don't think that will be the cause for the issue mentioned above, but if you think so kindly remove the condition and try.
> > > >
> > > > Thank you,
> > > >
> > > > Shruthi
> > > > Senior Software Engineer
> > > >
> > > > 91-8277012716 https://mail.google.com/mail/u/0/#m_-1768572932182586981_SignatureSanitizer_
> > > > www.finflux.co https://www.finflux.co/ | Banking Made Easy
> > > > [https://www.facebook.com/finflux/] https://www.facebook.com/finflux/ https://www.finflux.co/ https://www.linkedin.com/company/finfluxtoo/ [https://twitter.com/finflux_?lang=en] https://twitter.com/finflux_?lang=en
> > > >
> > > >
> > > > On Tue, Jun 4, 2019 at 3:38 PM <sifiso@skyburgsystems.org mailto:sifiso@skyburgsystems.org > wrote:
> > > >
> > > > > > > > >
> > > > > Mexina,
> > > > >
> > > > >
> > > > >
> > > > > This was Steve Conrad’s response to the issue
> > > > >
> > > > >
> > > > >
> > > > > I am attaching the dev list as well. I was working with another user who was having an issue with the stretchy reports this weekend. It appears that there is an issue with the V345__reports_for_self_service_user.sql migration script, but I haven't had a chance to look at it fully. I am not sure what issue that this migration script was written to fix, but it appears that it is usinghttp://stretchy_parameters.id instead of strechy_parameters.parameter_id andhttp://stretchy_report.id instead of stretchy_report.report_id.
> > > > >
> > > > >
> > > > >
> > > > > Hope it helps
> > > > >
> > > > >
> > > > >
> > > > > Sifiso
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > From: Mexina Daniel [mailto:mexina@singo.africa mailto:mexina@singo.africa ]
> > > > > Sent: Tuesday, 04 June 2019 12:00 PM
> > > > > To: sifiso@skyburgsystems.org mailto:sifiso@skyburgsystems.org ; Mifos software development <mifos-developer@lists.sourceforge.net mailto:mifos-developer@lists.sourceforge.net >
> > > > > Subject: RE: [Mifos-developer] Some of the loan reports of pentaho are not displaying
> > > > >
> > > > >
> > > > >
> > > > > Hello Sifiso
> > > > >
> > > > > Thank you for the response.
> > > > >
> > > > > I have checked the threads you mentions but there was no solution given.
> > > > >
> > > > > Community
> > > > >
> > > > > Had anyone found a solution to this critical issue?
> > > > >
> > > > > Regards
> > > > >
> > > > > > > > > > >
> > > > > > On May 31, 2019 at 2:48 PM sifiso@skyburgsystems.org mailto:sifiso@skyburgsystems.org wrote:
> > > > > >
> > > > > > Hi Mexina,
> > > > > >
> > > > > >
> > > > > >
> > > > > > This issue began in 18.03.01 and more reports are not showing with every new upgrade of the system.
> > > > > >
> > > > > >
> > > > > >
> > > > > > Aging and Arrears reports are also affected and it’s to do with the parameters. Check the emails Titled
> > > > > >
> > > > > > Reports not working in 18.03.01 and another one titled
> > > > > >
> > > > > > Hello, I have a problem with the creation of a new report. in fact when I create the report and I execute it there is no result. Has anyone come across this problem before
> > > > > >
> > > > > >
> > > > > >
> > > > > > Steve Conrad identified the issue on that and the source of the problem being the self service reports.sql migration script.
> > > > > >
> > > > > >
> > > > > >
> > > > > > Regards,
> > > > > >
> > > > > > Sifiso
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > From: Mexina Daniel [mailto:mexina@singo.africa]
> > > > > > Sent: Thursday, 30 May 2019 6:49 AM
> > > > > > To: dev@fineract.apache.org mailto:dev@fineract.apache.org ; Nazeer Hussain Shaik <nazeerhussain.shaik@gmail.com mailto:nazeerhussain.shaik@gmail.com >
> > > > > > Cc: Mifos software development <mifos-developer@lists.sourceforge.net mailto:mifos-developer@lists.sourceforge.net >
> > > > > > Subject: Re: [Mifos-developer] Some of the loan reports of pentaho are not displaying
> > > > > >
> > > > > >
> > > > > >
> > > > > > Hello Nazeer
> > > > > >
> > > > > > The mifos distribution is deployed, i think that's why other pentaho report are displayed.
> > > > > >
> > > > > > Regards
> > > > > >
> > > > > > > > > > > > >
> > > > > > > On May 29, 2019 at 7:59 PM Nazeer Hussain Shaik <nazeerhussain.shaik@gmail.com mailto:nazeerhussain.shaik@gmail.com > wrote:
> > > > > > >
> > > > > > > Can you verify whether mifos distribution is deployed or fineract distribution is deployed? I see the following error for pentaho reports.
> > > > > > >
> > > > > > > {
> > > > > > >
> > > > > > > 1. developerMessage: "The requested resource is not available.", httpStatusCode: "404",…}
> > > > > > >
> > > > > > > 1. defaultUserMessage: "The requested resource is not available."
> > > > > > >
> > > > > > > 2. developerMessage: "The requested resource is not available."
> > > > > > >
> > > > > > > 3. errors: [{developerMessage: "Reporting meta-data entry not found.",…}]
> > > > > > >
> > > > > > > 4. httpStatusCode: "404"
> > > > > > >
> > > > > > > 5. userMessageGlobalisationCode: "error.msg.resource.not.found"
> > > > > > >
> > > > > > > 6.
> > > > > > >
> > > > > > > 7. Regards,
> > > > > > >
> > > > > > > 8. Nazeer
> > > > > > >
> > > > > > > 9.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > On Wed, May 29, 2019 at 7:46 PM Mexina Daniel <mexina@singo.africa mailto:mexina@singo.africa > wrote:
> > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > Hello
> > > > > > > >
> > > > > > > > It seems there are changes done in fineract that brought effect to display of some of the pentaho loan reports ( seems it has to do with parameters)
> > > > > > > >
> > > > > > > > I have tried with the same community app, to run platform of Fineract 1.1.0 and Fineract 1.2.0 and found those reports was displayed when using 1.1.0 and not displayed when using 1.2.0.
> > > > > > > >
> > > > > > > > I checked on https://staging.openmf.org too since it fineract 1.2.0 and found the same issue.
> > > > > > > >
> > > > > > > > Can someone check and help what could be the change and how to solve it.
> > > > > > > >
> > > > > > > > Some of the reports are :
> > > > > > > >
> > > > > > > > Active Loans - Details(Pentaho)
> > > > > > > >
> > > > > > > > Active Loans - Summary(Pentaho)
> > > > > > > >
> > > > > > > > Active Loans by Disbursal Period(Pentaho)
> > > > > > > >
> > > > > > > > etc
> > > > > > > >
> > > > > > > > Quick response will be appreciated as our live servers are running fineract 1.2.0.
> > > > > > > >
> > > > > > > > Thanks in advance.
> > > > > > > >
> > > > > > > > Mexina Daniel
> > > > > > > >
> > > > > > > > Singo Africa Limited
> > > > > > > >
> > > > > > > > Mbezi Beach "B" | Mwai Kibaki Road | 6 Wasafi Str.
> > > > > > > > P.O BOX 78908 | 14121 Dar es salaam
> > > > > > > >
> > > > > > > > +255 71 211 0791 | +255 22 261 8511
> > > > > > > >
> > > > > > > > amala.co.tz https://amala.co.tz/ | singo.africa https://singo.africa
> > > > > > > >
> > > > > > > > [cid:16b03fd15aa6ec876941] [cid:16b03fd15aa3607e8062]
> > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > >
> > > > > >
> > > > > > Mexina Daniel
> > > > > >
> > > > > > Singo Africa Limited
> > > > > >
> > > > > > Mbezi Beach "B" | Mwai Kibaki Road | 6 Wasafi Str.
> > > > > > P.O BOX 78908 | 14121 Dar es salaam
> > > > > >
> > > > > > +255 71 211 0791 | +255 22 261 8511
> > > > > >
> > > > > > amala.co.tz https://amala.co.tz/ | singo.africa https://singo.africa
> > > > > >
> > > > > > [cid:0336cb04-3ad9-41be-be3a-d9d3f7290849] [cid:81f2508c-ff18-4a40-bac8-46a3fe184615]
> > > > > >
> > > > > > > > > > >
> > > > >
> > > > >
> > > > > Mexina Daniel
> > > > >
> > > > > Singo Africa Limited
> > > > >
> > > > > Mbezi Beach "B" | Mwai Kibaki Road | 6 Wasafi Str.
> > > > > P.O BOX 78908 | 14121 Dar es salaam
> > > > >
> > > > > +255 71 211 0791 | +255 22 261 8511
> > > > >
> > > > > amala.co.tz https://amala.co.tz/ | singo.africa https://singo.africa
> > > > >
> > > > >
> > > > >
> > > > > Mifos-developer mailing list
> > > > > mifos-developer@lists.sourceforge.net mailto:mifos-developer@lists.sourceforge.net
> > > > > Unsubscribe or change settings at:
> > > > > https://lists.sourceforge.net/lists/listinfo/mifos-developer
> > > > >
> > > > > > > > >
> > > > > > >
> > >
> > > Mexina Daniel
> > >
> > > Singo Africa Limited
> > >
> > > Mbezi Beach "B" | Mwai Kibaki Road | 6 Wasafi Str.
> > > P.O BOX 78908 | 14121 Dar es salaam
> > >
> > > +255 71 211 0791 | +255 22 261 8511
> > >
> > > amala.co.tz https://amala.co.tz/ | singo.africa https://singo.africa
> > >
> > >
> > >
> > > Mifos-developer mailing list
> > > mifos-developer@lists.sourceforge.net mailto:mifos-developer@lists.sourceforge.net
> > > Unsubscribe or change settings at:
> > > https://lists.sourceforge.net/lists/listinfo/mifos-developer
> > >
> > > > > Mifos-developer mailing list
> > mifos-developer@lists.sourceforge.net mailto:mifos-developer@lists.sourceforge.net
> > Unsubscribe or change settings at:
> > https://lists.sourceforge.net/lists/listinfo/mifos-developer
> >
> > > Mifos-developer mailing list
> mifos-developer@lists.sourceforge.net
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>
Mexina Daniel
Singo Africa Limited
Mbezi Beach "B" | Mwai Kibaki Road | 6 Wasafi Str.
P.O BOX 78908 | 14121 Dar es salaam
+255 71 211 0791 | +255 22 261 8511
amala.co.tz https://amala.co.tz/ | singo.africa https://singo.africa