Just giving this issue a +1 This is now connected to https://issues.apache.org/jira/browse/FINERACT-1127 Plugable reporting jar file https://github.com/vorburger/fineract-pentaho
@jdailey On Thu, Aug 13, 2020 at 12:30 PM Ed Cable <edca...@mifos.org> wrote: > Luis and Francis, I wanted to check in to see if you had made any progress > with the issues being faced. I want to ensure this Fineract-level fix gets > included in the release as it's a show-stopper for Mifos X release which > must support Pentaho reports. > > On Mon, Aug 10, 2020, 09:33 Petri Tuomola <pe...@tuomola.org> wrote: > >> Hi >> >> You can list classes / files to exclude from the ClasspathHell check in >> the following method: >> >> >> org.apache.fineract.infrastructure.classdupes.ClasspathHellDuplicatesChecker.isHarmlessDuplicate() >> >> Have you tried adding e.g. endsWith(“overview.html”) to that? >> >> Regards >> Petri >> >> >> On 10 Aug 2020, at 7:02 PM, Francis Guchie <francisguc...@gmail.com> >> wrote: >> >> Yes Petri, >> >> I agree with you but i am limited a little on how gradle effectively does >> the exclusions >> in the following branches, i still get the same error even if i think in >> one of them the pentaho reports have completely different path (in my view) >> >> This one below is my approach to adding pentaho >> https://github.com/francisguchie/fineract/tree/supportPentahoReports >> >> And this one below is how i copied it from Luis' repo (he had some RAT >> (license issue on the pentaho files- which i can address once and out of >> the jar Hell) >> https://github.com/francisguchie/fineract/tree/addingPentaho >> >> But for both, i get the same jar hell >> >> >> >> >> My Kind Regards >> >> Francis Guchie Kirago >> *Skype:* francisguchie >> *Whatsapp: *232 79 19 44 07 >> *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >> twitter: @FrancisGuchie >> >> >> >> >> >> >> >> >> >> On Mon, Aug 10, 2020 at 3:30 PM Petri Tuomola <pe...@tuomola.org> wrote: >> >>> Hi >>> >>> At least based on the error message, it seems that the different jar >>> files from Pentaho contain the same files (eg overview.html). If all these >>> jar files are needed and there is no version available that would not have >>> these duplicate files, then the only solution I can see is to add these to >>> the files excluded from the classpath hell check. >>> >>> Regards >>> Petri >>> >>> >>> On Mon, 10 Aug 2020, 6:07 pm Bharath Gowda, <bgo...@mifos.org> wrote: >>> >>>> Hi Luis and Francis, >>>> >>>> @Luis Alberto Alegría de los Santos <luis.aleg...@innovar.app> Thank >>>> you for your great effort in fixing the issue and narrowing down the other >>>> related issues. >>>> >>>> @Francis Guchie <francisguc...@gmail.com> Appreciate your assistance >>>> in taking this issue forward and Providing all the details of the issue >>>> which you are facing. >>>> >>>> @Devs: Requesting any of our Devs to help out Francis with his issue. >>>> >>>> >>>> >>>> Regards, >>>> Bharath >>>> Lead Implementation Analyst | Mifos Initiative >>>> Skype: live:cbharath4| Mobile: +91.7019636073 >>>> http://mifos.org <http://facebook.com/mifos> >>>> <http://www.twitter.com/mifos> >>>> >>>> >>>> On Mon, Aug 10, 2020 at 4:53 PM Francis Guchie <francisguc...@gmail.com> >>>> wrote: >>>> >>>>> Dear Luis, >>>>> >>>>> I am still getting the Jar Hell error. Yet my gradle is 6.5.1 Also >>>>> you have the following error below >>>>> Apache Rat audit failure - 51 unapproved licenses >>>>> See file:///D:/0a/fineract-1/build/reports/rat/index.html >>>>> 51 Unknown Licenses - or files without a license. >>>>> ------------------------------ >>>>> Unapproved >>>>> Licenses:D:/0a/fineract-1/fineract-provider/src/main/pentahoReports/Active >>>>> Loans - Details.properties >>>>> D:/0a/fineract-1/fineract-provider/src/main/pentahoReports/Active >>>>> Loans - Summary.properties >>>>> the list goes on >>>>> >>>>> this i will address but only after i solve this below >>>>> >>>>> >>>>> org.opentest4j.AssertionFailedError: 3 Classpath duplicates detected: >>>>> overview.html ......... >>>>> >>>>> >>>>> >>>>> >>>>> My Kind Regards >>>>> >>>>> Francis Guchie Kirago >>>>> *Skype:* francisguchie >>>>> *Whatsapp: *232 79 19 44 07 >>>>> *LINKEDIN:* >>>>> https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >>>>> twitter: @FrancisGuchie >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Mon, Aug 10, 2020 at 10:12 AM Francis Guchie < >>>>> francisguc...@gmail.com> wrote: >>>>> >>>>>> Thanks Luis, >>>>>> >>>>>> I have just noticed that i had gradle 4.x changed it to 6.5.1 and i >>>>>> will run the build again >>>>>> >>>>>> My Kind Regards >>>>>> >>>>>> Francis Guchie Kirago >>>>>> *Skype:* francisguchie >>>>>> *Whatsapp: *232 79 19 44 07 >>>>>> *LINKEDIN:* >>>>>> https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >>>>>> twitter: @FrancisGuchie >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On Mon, Aug 10, 2020 at 12:04 AM Luis Alberto Alegría de los Santos < >>>>>> luis.aleg...@innovar.app> wrote: >>>>>> >>>>>>> Hi Francis >>>>>>> Maybe you need upgrade gradle versión, Im think 5 or later. >>>>>>> >>>>>>> Please could you try it? >>>>>>> >>>>>>> Best regards >>>>>>> >>>>>>> El dom., 9 ago 2020 5:47 p. m., Francis Guchie < >>>>>>> francisguc...@gmail.com> escribió: >>>>>>> >>>>>>>> Dear Luis, >>>>>>>> >>>>>>>> I still get this error >>>>>>>> >>>>>>>> ClasspathHellDuplicatesCheckRuleTest > >>>>>>>> testIfThereAreAnyDuplicatesOnTheClasspath() FAILED >>>>>>>> org.opentest4j.AssertionFailedError: 3 Classpath duplicates >>>>>>>> detected: >>>>>>>> overview.html >>>>>>>> >>>>>>>> jar:file:/C:/Users/Guchie/.gradle/caches/modules-2/files-2.1/org.mnode.ical4j/ical4j/3.0.19/5aa648ce509674af21b3a46ce1efb5aa3300b651/ical4j-3.0.19.jar!/overview.html >>>>>>>> >>>>>>>> jar:file:/C:/Users/Guchie/.gradle/caches/modules-2/files-2.1/pentaho-reporting-engine/pentaho-reporting-engine-classic-core/ >>>>>>>> 3.9.1.1/77036efc94f1bab8dfe07bfdcf28cb4cdc4dcc46/pentaho-reporting-engine-classic-core-3.9.1.1.jar!/overview.html >>>>>>>> >>>>>>>> jar:file:/C:/Users/Guchie/.gradle/caches/modules-2/files-2.1/pentaho-reporting-engine/pentaho-reporting-engine-classic-extensions/3.9.1-GA/24114228757a9325f4b4e4899471413f6ae90d2c/pentaho-reporting-engine-classic-extensions-3.9.1-GA.jar!/overview.html >>>>>>>> >>>>>>>> jar:file:/C:/Users/Guchie/.gradle/caches/modules-2/files-2.1/pentaho-library/libfonts/1.2.8/8d20d16c7b4022480df8fb8aa7c51f6357ff1817/libfonts-1.2.8.jar!/overview.html >>>>>>>> >>>>>>>> jar:file:/C:/Users/Guchie/.gradle/caches/modules-2/files-2.1/pentaho-library/libserializer/1.2.8/52d4ccad3fa757ec040a3da34314d08c4a071332/libserializer-1.2.8.jar!/overview.html >>>>>>>> classic-engine.properties >>>>>>>> >>>>>>>> jar:file:/C:/Users/Guchie/.gradle/caches/modules-2/files-2.1/pentaho-reporting-engine/pentaho-reporting-engine-classic-extensions/3.9.1-GA/24114228757a9325f4b4e4899471413f6ae90d2c/pentaho-reporting-engine-classic-extensions-3.9.1-GA.jar!/classic-engine.properties >>>>>>>> >>>>>>>> jar:file:/C:/Users/Guchie/.gradle/caches/modules-2/files-2.1/pentaho-reporting-engine/pentaho-reporting-engine-classic-extensions-scripting/3.9.1-GA/174cce581a247680f24404e9ed6ef1fbfb53ae29/pentaho-reporting-engine-classic-extensions-scripting-3.9.1-GA.jar!/classic-engine.properties >>>>>>>> >>>>>>>> jar:file:/C:/Users/Guchie/.gradle/caches/modules-2/files-2.1/pentaho-reporting-engine/pentaho-reporting-engine-wizard-core/3.9.1-GA/671508e5f7b038b19ddbdf34914eab87bbb646ee/pentaho-reporting-engine-wizard-core-3.9.1-GA.jar!/classic-engine.properties >>>>>>>> loader.properties >>>>>>>> >>>>>>>> jar:file:/C:/Users/Guchie/.gradle/caches/modules-2/files-2.1/pentaho-reporting-engine/pentaho-reporting-engine-classic-core/ >>>>>>>> 3.9.1.1/77036efc94f1bab8dfe07bfdcf28cb4cdc4dcc46/pentaho-reporting-engine-classic-core-3.9.1.1.jar!/loader.properties >>>>>>>> >>>>>>>> jar:file:/C:/Users/Guchie/.gradle/caches/modules-2/files-2.1/pentaho-reporting-engine/pentaho-reporting-engine-wizard-core/3.9.1-GA/671508e5f7b038b19ddbdf34914eab87bbb646ee/pentaho-reporting-engine-wizard-core-3.9.1-GA.jar!/loader.properties >>>>>>>> >>>>>>>> should i asume its by cache files? am left with deleting them and >>>>>>>> running the >>>>>>>> ./gradlew clean build becuase this is where everything fails >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> My Kind Regards >>>>>>>> >>>>>>>> Francis Guchie Kirago >>>>>>>> *Skype:* francisguchie >>>>>>>> *Whatsapp: *232 79 19 44 07 >>>>>>>> *LINKEDIN:* >>>>>>>> https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >>>>>>>> twitter: @FrancisGuchie >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Sun, Aug 9, 2020 at 1:21 AM Luis Alberto Alegría de los Santos < >>>>>>>> luis.aleg...@innovar.app> wrote: >>>>>>>> >>>>>>>>> Hi all >>>>>>>>> >>>>>>>>> Sorry for the delay reply, I've finally had a chance to work on >>>>>>>>> integrating pentaho on the develop branch. >>>>>>>>> >>>>>>>>> Here you can find it >>>>>>>>> https://github.com/luisalegria/fineract-1/tree/19.14Pentaho >>>>>>>>> >>>>>>>>> Please, Bharath/Francis or anyone could help to test it. I only >>>>>>>>> tested the war file (bootWar option) and it partially works, I'm not >>>>>>>>> experienced on pentaho reports and I'm unsure if this gonna work like >>>>>>>>> 19.12. version. >>>>>>>>> >>>>>>>>> I would be able to view a pentaho file on this fork version, but: >>>>>>>>> >>>>>>>>> - I create a couple of new reports: >>>>>>>>> - One with a simple query >>>>>>>>> >>>>>>>>> <https://drive.google.com/file/d/1CU6fzHtDm7K4VQAHXFc34DpJMT3gCcJu/view?usp=sharing>: >>>>>>>>> fails >>>>>>>>> - Another without querys >>>>>>>>> >>>>>>>>> <https://drive.google.com/file/d/14C9VghUT8B86GgSKKF9frgi9rwSMhCH6/view?usp=sharing>: >>>>>>>>> it works <image.png> >>>>>>>>> >>>>>>>>> >>>>>>>>> - With existing reports, there are issues: >>>>>>>>> >>>>>>>>> >>>>>>>>> - Database name's were changed ( mifostenant-default => >>>>>>>>> fineract_default) and all reports need to be updated >>>>>>>>> - And looks like passing parameters on API "run_report" >>>>>>>>> option, works differently and pentaho files didn't get that >>>>>>>>> - I got this message sent by pentaho engine report: >>>>>>>>> - {"developerMessage":"The request caused a data >>>>>>>>> integrity issue to be fired by the >>>>>>>>> >>>>>>>>> database.","httpStatusCode":"403","defaultUserMessage":"Failed at >>>>>>>>> query: >>>>>>>>> \n\n\n\n\n\n\nselect \nid, >>>>>>>>> >>>>>>>>> \nconcat(substring(\"........................................\", 1, >>>>>>>>> \n((LENGTH(`hierarchy`) - LENGTH(REPLACE(`hierarchy`, '.', >>>>>>>>> '')) - 1) * >>>>>>>>> 4)),`name`) as tc \nfrom m_office \norder by hierarchy >>>>>>>>> >>>>>>>>> >>>>>>>>> ","userMessageGlobalisationCode":"error.msg.reporting.error","errors":[{"developerMessage":"Failed >>>>>>>>> at query: \n\n\n\n\n\n\nselect \nid, >>>>>>>>> >>>>>>>>> \nconcat(substring(\"........................................\", 1, >>>>>>>>> \n((LENGTH(`hierarchy`) - LENGTH(REPLACE(`hierarchy`, '.', >>>>>>>>> '')) - 1) * >>>>>>>>> 4)),`name`) as tc \nfrom m_office \norder by hierarchy >>>>>>>>> >>>>>>>>> ","defaultUserMessage":"Failed at query: >>>>>>>>> \n\n\n\n\n\n\nselect \nid, >>>>>>>>> >>>>>>>>> \nconcat(substring(\"........................................\", 1, >>>>>>>>> \n((LENGTH(`hierarchy`) - LENGTH(REPLACE(`hierarchy`, '.', >>>>>>>>> '')) - 1) * >>>>>>>>> 4)),`name`) as tc \nfrom m_office \norder by hierarchy >>>>>>>>> >>>>>>>>> >>>>>>>>> ","userMessageGlobalisationCode":"error.msg.reporting.error","parameterName":null,"value":null,"args":[]}]} >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> Remember: >>>>>>>>> >>>>>>>>> - To avoid error on SQL INJECTION, its necessary replace ")" >>>>>>>>> "(" characters on database: >>>>>>>>> - >>>>>>>>> - UPDATE stretcy_report SET report_name = >>>>>>>>> replace(report_name,"("," " WHERE report_type="Pentaho"; >>>>>>>>> - UPDATE stretchy_report SET report_name = >>>>>>>>> replace(report_name,")","") WHERE report_type="Pentaho"; >>>>>>>>> - 90+ reports are here >>>>>>>>> >>>>>>>>> <https://drive.google.com/drive/folders/1AMEc6RQnidid69iTvbi5L0PIJGr-XZqq?usp=sharing>, >>>>>>>>> and I replaced "(" ")" characters on them. >>>>>>>>> - These files goes on ~/.mifosx/ folder >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> Thank you a lot >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> El vie., 7 ago. 2020 a las 5:11, Francis Guchie (< >>>>>>>>> francisguc...@gmail.com>) escribió: >>>>>>>>> >>>>>>>>>> Dear Bharath, >>>>>>>>>> >>>>>>>>>> My branch is >>>>>>>>>> >>>>>>>>>> https://github.com/francisguchie/fineract/tree/supportPentahoReports >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> My Kind Regards >>>>>>>>>> >>>>>>>>>> Francis Guchie Kirago >>>>>>>>>> *Skype:* francisguchie >>>>>>>>>> *Whatsapp: *232 79 19 44 07 >>>>>>>>>> *LINKEDIN:* >>>>>>>>>> https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >>>>>>>>>> twitter: @FrancisGuchie >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Fri, Aug 7, 2020 at 10:04 AM Bharath Gowda <bgo...@mifos.org> >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>>> Hi Ed, >>>>>>>>>>> >>>>>>>>>>> Francis tried, and he was not able to do so due to the following >>>>>>>>>>> reason. >>>>>>>>>>> >>>>>>>>>>> In 19.2, they are using the compile command >>>>>>>>>>> In 19.4 its implementation command >>>>>>>>>>> I have tried to implement Pentaho in the latest build, but i am >>>>>>>>>>> getting an assertion error duplicate classpaths found. >>>>>>>>>>> >>>>>>>>>>> Any help from other contributors would be appreciated. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> Regards, >>>>>>>>>>> Bharath >>>>>>>>>>> Lead Implementation Analyst | Mifos Initiative >>>>>>>>>>> Skype: live:cbharath4| Mobile: +91.7019636073 >>>>>>>>>>> http://mifos.org <http://facebook.com/mifos> >>>>>>>>>>> <http://www.twitter.com/mifos> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Fri, Aug 7, 2020 at 4:21 AM Ed Cable <edca...@mifos.org> >>>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>>> Luis/Bharath >>>>>>>>>>>> >>>>>>>>>>>> Are one of you going to merge this into the upstream Fineract >>>>>>>>>>>> codebase? We need to ensure it makes it into the 1.4 release. >>>>>>>>>>>> >>>>>>>>>>>> Please make sure there's a Fineract JIRA ticket (Please insert >>>>>>>>>>>> slightly more detail than is at >>>>>>>>>>>> https://github.com/bharathcgowda/Fineract/issues/1) >>>>>>>>>>>> corresponding to this pull request: >>>>>>>>>>>> https://github.com/bharathcgowda/Fineract/pull/2 >>>>>>>>>>>> >>>>>>>>>>>> Ed >>>>>>>>>>>> >>>>>>>>>>>> On Mon, Jul 20, 2020 at 10:47 AM Moses Gitonga Ntiritu < >>>>>>>>>>>> ntiritum...@gmail.com> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Thanks so much, Congratulations Luis >>>>>>>>>>>>> Moses >>>>>>>>>>>>> >>>>>>>>>>>>> On Mon, Jul 20, 2020 at 4:05 PM Bharath Gowda < >>>>>>>>>>>>> bgo...@mifos.org> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Hi All, >>>>>>>>>>>>>> >>>>>>>>>>>>>> Thanks to Luis Efforts in fixing the issue, 19.12 source code >>>>>>>>>>>>>> is now updated with the Pentaho support. >>>>>>>>>>>>>> Kindly check the updated source code here >>>>>>>>>>>>>> <https://github.com/bharathcgowda/Fineract> >>>>>>>>>>>>>> And updated war file here >>>>>>>>>>>>>> <https://drive.google.com/file/d/19MrW8DQDzVYtfFQ7H7aamfsqPSCI-q8r/view?usp=sharing> >>>>>>>>>>>>>> >>>>>>>>>>>>>> Thanks @francisguc...@gmail.com <francisguc...@gmail.com> for >>>>>>>>>>>>>> your initiative in testing the issue. >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> Regards, >>>>>>>>>>>>>> Bharath >>>>>>>>>>>>>> Lead Implementation Analyst | Mifos Initiative >>>>>>>>>>>>>> Skype: live:cbharath4| Mobile: +91.7019636073 >>>>>>>>>>>>>> http://mifos.org <http://facebook.com/mifos> >>>>>>>>>>>>>> <http://www.twitter.com/mifos> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Fri, Jul 17, 2020 at 3:28 AM Luis Alberto Alegría de los >>>>>>>>>>>>>> Santos <luis.aleg...@innovar.app> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hi Francis >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Thank you very much for your email and your help offer. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> I'm working with Bharath, He's helping me. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Really, thank you so much >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Best regards >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> El jue., 16 jul. 2020 a las 15:24, Francis Guchie (< >>>>>>>>>>>>>>> francisguc...@gmail.com>) escribió: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Luis, >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Thanks for this good work. >>>>>>>>>>>>>>>> NB: >>>>>>>>>>>>>>>> if you need help on getting started on how to use git. Just >>>>>>>>>>>>>>>> pv me, i will be happy to help >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> My Kind Regards >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Francis Guchie Kirago >>>>>>>>>>>>>>>> *Skype:* francisguchie >>>>>>>>>>>>>>>> *Whatsapp: *232 79 19 44 07 >>>>>>>>>>>>>>>> *LINKEDIN:* >>>>>>>>>>>>>>>> https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >>>>>>>>>>>>>>>> twitter: @FrancisGuchie >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> On Thu, Jul 16, 2020 at 4:19 AM Luis Alberto Alegría de los >>>>>>>>>>>>>>>> Santos <luis.aleg...@innovar.app> wrote: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Hello Bharath, Yurie >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> I was able to fix pentaho support into version 1.2 of >>>>>>>>>>>>>>>>> fineract, I still haven't had a chance to test in the latest >>>>>>>>>>>>>>>>> fineract >>>>>>>>>>>>>>>>> develop branch. As soon as possible I will test for the >>>>>>>>>>>>>>>>> latest version of >>>>>>>>>>>>>>>>> fineract and as soon as I make sure that everything works >>>>>>>>>>>>>>>>> correctly I will >>>>>>>>>>>>>>>>> create the PR. >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> However I just did a test with version 19.12 of MifosX( >>>>>>>>>>>>>>>>> https://github.com/bharathcgowda/Fineract , Bharath's >>>>>>>>>>>>>>>>> fork ) and it was successful, the reports work without >>>>>>>>>>>>>>>>> problems. There are >>>>>>>>>>>>>>>>> more changes that I have already identified and solved, such >>>>>>>>>>>>>>>>> as an >>>>>>>>>>>>>>>>> exception regarding error.msg.found.sql.injection and changes >>>>>>>>>>>>>>>>> in report >>>>>>>>>>>>>>>>> names. >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> And I agree with you Bharath, we could get the 19.12 >>>>>>>>>>>>>>>>> updated first. >>>>>>>>>>>>>>>>> Could you help me please create a branch so I can add the >>>>>>>>>>>>>>>>> PR on the 19.12 version? Thank you very much. >>>>>>>>>>>>>>>>> I am not familiar with git, I tried to create it, however >>>>>>>>>>>>>>>>> it was not possible for me. I understand that it is necessary >>>>>>>>>>>>>>>>> to have >>>>>>>>>>>>>>>>> another branch to be able to submit a PR. >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> And I hope these changes help users of pentaho reports >>>>>>>>>>>>>>>>> without licensing issues. >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Best regards >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> El lun., 13 jul. 2020 a las 5:39, yurie walter (< >>>>>>>>>>>>>>>>> yuwa...@gmail.com>) escribió: >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> This is great, looking foward to this update. >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> On Mon, Jul 13, 2020, 13:16 Bharath Gowda < >>>>>>>>>>>>>>>>>> bgo...@mifos.org> wrote: >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> Hi Airsay, >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> There was no branch out or tag made for the RC 19.12 at >>>>>>>>>>>>>>>>>>> that time, however, I have Forked out the code base and it >>>>>>>>>>>>>>>>>>> is available in >>>>>>>>>>>>>>>>>>> my Git account. >>>>>>>>>>>>>>>>>>> You can refer to the source code of 19.12 here >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> https://github.com/bharathcgowda/Community-app >>>>>>>>>>>>>>>>>>> https://github.com/bharathcgowda/Fineract >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> @yurie >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> Fineract has removed the Support for Pentaho report due >>>>>>>>>>>>>>>>>>> to some licensing issues, Hence the reports don't run on >>>>>>>>>>>>>>>>>>> the Fineract >>>>>>>>>>>>>>>>>>> recent releases. >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> However, @Luis Alberto Alegría de los Santos >>>>>>>>>>>>>>>>>>> <luis.aleg...@innovar.app> has done a great job on >>>>>>>>>>>>>>>>>>> fixing the Pentaho reports locally on the latest Develop >>>>>>>>>>>>>>>>>>> Branch and he will >>>>>>>>>>>>>>>>>>> soon Send a PR along with a Discussion thread with the >>>>>>>>>>>>>>>>>>> community on the Fix >>>>>>>>>>>>>>>>>>> he has done. >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> @Luis Alberto Alegría de los Santos >>>>>>>>>>>>>>>>>>> <luis.aleg...@innovar.app> could you please send the PR >>>>>>>>>>>>>>>>>>> to the 19.12 codebase as well to the Repos listed above? >>>>>>>>>>>>>>>>>>> We can get the 19.12 updated first, which will help all >>>>>>>>>>>>>>>>>>> the users who are running on 19.12 release now. >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> Regards, >>>>>>>>>>>>>>>>>>> Bharath >>>>>>>>>>>>>>>>>>> Lead Implementation Analyst | Mifos Initiative >>>>>>>>>>>>>>>>>>> Skype: live:cbharath4| Mobile: +91.7019636073 >>>>>>>>>>>>>>>>>>> http://mifos.org <http://facebook.com/mifos> >>>>>>>>>>>>>>>>>>> <http://www.twitter.com/mifos> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> On Fri, Jul 10, 2020 at 7:04 PM yurie walter < >>>>>>>>>>>>>>>>>>> yuwa...@gmail.com> wrote: >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Hi Bharath, >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> I'm experiencing a small problem. After upgrade to >>>>>>>>>>>>>>>>>>>> Mifos 19.02 all Pentaho reports are displaying a black >>>>>>>>>>>>>>>>>>>> page when we run a >>>>>>>>>>>>>>>>>>>> report. Might you know why? >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Walter >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> On Wed, Jul 8, 2020, 09:04 Airsay Longcon < >>>>>>>>>>>>>>>>>>>> airsaylong...@gmail.com> wrote: >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Hello Bharath >>>>>>>>>>>>>>>>>>>>> Please are the source code from which the war file of >>>>>>>>>>>>>>>>>>>>> v19.12 available? >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Sent from my iPhone >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> On 7 Jul 2020, at 14:50, Bharath Gowda < >>>>>>>>>>>>>>>>>>>>> bgo...@mifos.org> wrote: >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Hi Edwin, >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> That is a known issue on the 18.03 version of Mifos. >>>>>>>>>>>>>>>>>>>>> you can either upgrade to the latest Develop branch or >>>>>>>>>>>>>>>>>>>>> you can upgrade to >>>>>>>>>>>>>>>>>>>>> 19.12 Branch(which is more stable than 18.03 and was the >>>>>>>>>>>>>>>>>>>>> release candidate >>>>>>>>>>>>>>>>>>>>> version previously) >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Following war file and root folder are of our initial >>>>>>>>>>>>>>>>>>>>> RC Which is currently the stable codebase - the code >>>>>>>>>>>>>>>>>>>>> version >>>>>>>>>>>>>>>>>>>>> 19.12.01 where these issues have been fixed. >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> You can download from below links >>>>>>>>>>>>>>>>>>>>> ROOT: >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> https://drive.google.com/file/d/1EFvVAz_5d-7Q0v3IfoG_DWUwCAaSmLmx/view?usp=drivesdk >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> WAR: >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> https://drive.google.com/file/d/1Vz_OSttAG8TxWA0sa6kv_4bJE_bThETT/view?usp=drivesdk >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Following are simple steps to update the server >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> 1. Replace these files in your tomcat webapp folder >>>>>>>>>>>>>>>>>>>>> 2. Unzip the root which is downloaded from the above >>>>>>>>>>>>>>>>>>>>> link >>>>>>>>>>>>>>>>>>>>> 3. Remove the existing fineract-provider folder inside >>>>>>>>>>>>>>>>>>>>> the webapp folder and restart the tomcat server. >>>>>>>>>>>>>>>>>>>>> 4. Take a backup of your existing DB, war file and >>>>>>>>>>>>>>>>>>>>> root folder before performing an update Incase if you >>>>>>>>>>>>>>>>>>>>> have to roll back to the existing setup if you encounter >>>>>>>>>>>>>>>>>>>>> any issue. >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> You can also contact me on skype if you have any >>>>>>>>>>>>>>>>>>>>> questions or concerns. >>>>>>>>>>>>>>>>>>>>> My skype handle is live:cbharath4 >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Regards, >>>>>>>>>>>>>>>>>>>>> Bharath >>>>>>>>>>>>>>>>>>>>> Lead Implementation Analyst | Mifos Initiative >>>>>>>>>>>>>>>>>>>>> Skype: live:cbharath4| Mobile: +91.7019636073 >>>>>>>>>>>>>>>>>>>>> http://mifos.org <http://facebook.com/mifos> >>>>>>>>>>>>>>>>>>>>> <http://www.twitter.com/mifos> >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> On Tue, Jul 7, 2020 at 7:06 PM Edwin Nchia < >>>>>>>>>>>>>>>>>>>>> edwingudfri...@gmail.com> wrote: >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Sure, here it is. >>>>>>>>>>>>>>>>>>>>>> 18.03.01 >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> On Tue, 7 Jul 2020 16:35 Bharath Gowda, < >>>>>>>>>>>>>>>>>>>>>> bgo...@mifos.org> wrote: >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> Hi Edwin, >>>>>>>>>>>>>>>>>>>>>>> Could you let me know the Release version you are >>>>>>>>>>>>>>>>>>>>>>> working on? >>>>>>>>>>>>>>>>>>>>>>> Regards, >>>>>>>>>>>>>>>>>>>>>>> Bharath >>>>>>>>>>>>>>>>>>>>>>> Lead Implementation Analyst | Mifos Initiative >>>>>>>>>>>>>>>>>>>>>>> Skype: live:cbharath4| Mobile: +91.7019636073 >>>>>>>>>>>>>>>>>>>>>>> http://mifos.org <http://facebook.com/mifos> >>>>>>>>>>>>>>>>>>>>>>> <http://www.twitter.com/mifos> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> On Thu, Jul 2, 2020 at 7:06 PM Edwin Nchia < >>>>>>>>>>>>>>>>>>>>>>> edwingudfri...@gmail.com> wrote: >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>>> Hello! I have created a table but the field is not >>>>>>>>>>>>>>>>>>>>>>>> active, where I wrong? >>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list >>>>>>>>>>>>>>>>>>>>> mifos-us...@lists.sourceforge.net >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>>>>>>>> Mifos-users mailing list >>>>>>>>>>>>>>>>>>>> mifos-us...@lists.sourceforge.net >>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>>>>>>> Mifos-users mailing list >>>>>>>>>>>>>>>>>>> mifos-us...@lists.sourceforge.net >>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>>> LSC. Luis Alegría >>>>>>>>>>>>>>>>> INNOVARAPP >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> *La información contenida en este correo electrónico y >>>>>>>>>>>>>>>>> anexos es confidencial. Ésta dirigida únicamente para el uso >>>>>>>>>>>>>>>>> del individuo >>>>>>>>>>>>>>>>> o entidad a la que fue dirigida y puede contener información >>>>>>>>>>>>>>>>> propietaria >>>>>>>>>>>>>>>>> que no es del dominio público. Si has recibido este correo >>>>>>>>>>>>>>>>> por error o no >>>>>>>>>>>>>>>>> eres el destinatario, por favor notificar al remitente de >>>>>>>>>>>>>>>>> inmediato y borra >>>>>>>>>>>>>>>>> este mensaje de la computadora o dispositivo. Cualquier uso, >>>>>>>>>>>>>>>>> distribución o >>>>>>>>>>>>>>>>> reproducción de este correo que no sea por el destinatario de >>>>>>>>>>>>>>>>> intención >>>>>>>>>>>>>>>>> queda prohibido.* >>>>>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>>>>> Mifos-users mailing list >>>>>>>>>>>>>>>>> mifos-us...@lists.sourceforge.net >>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> LSC. Luis Alegría >>>>>>>>>>>>>>> INNOVARAPP >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> *La información contenida en este correo electrónico y >>>>>>>>>>>>>>> anexos es confidencial. Ésta dirigida únicamente para el uso >>>>>>>>>>>>>>> del individuo >>>>>>>>>>>>>>> o entidad a la que fue dirigida y puede contener información >>>>>>>>>>>>>>> propietaria >>>>>>>>>>>>>>> que no es del dominio público. Si has recibido este correo por >>>>>>>>>>>>>>> error o no >>>>>>>>>>>>>>> eres el destinatario, por favor notificar al remitente de >>>>>>>>>>>>>>> inmediato y borra >>>>>>>>>>>>>>> este mensaje de la computadora o dispositivo. Cualquier uso, >>>>>>>>>>>>>>> distribución o >>>>>>>>>>>>>>> reproducción de este correo que no sea por el destinatario de >>>>>>>>>>>>>>> intención >>>>>>>>>>>>>>> queda prohibido.* >>>>>>>>>>>>>>> Mifos-developer mailing list >>>>>>>>>>>>>>> mifos-develo...@lists.sourceforge.net >>>>>>>>>>>>>>> Unsubscribe or change settings at: >>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer >>>>>>>>>>>>>> >>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>> Mifos-users mailing list >>>>>>>>>>>>>> mifos-us...@lists.sourceforge.net >>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> Moses Gitonga Ntiritu >>>>>>>>>>>>> Director >>>>>>>>>>>>> Digital Oasis Limited >>>>>>>>>>>>> Po. Box 5221-00200 >>>>>>>>>>>>> Nairobi. >>>>>>>>>>>>> Tel: 0700 773 038 >>>>>>>>>>>>> www.digitaloasisltd.com >>>>>>>>>>>>> >>>>>>>>>>>>> -------------------------------------------------------------------------------- >>>>>>>>>>>>> *CMA AWARDS* >>>>>>>>>>>>> PLATINUM/ OVERALL WINNER: Citi Micro Entrepreneurship Awards >>>>>>>>>>>>> 2014-2015. >>>>>>>>>>>>> GOLD WINNER : Citi Micro Entrepreneurship Awards, Youth >>>>>>>>>>>>> Urban, 2014. >>>>>>>>>>>>> GOLD WINNER : Citi Micro Entrepreneurship Awards, Service >>>>>>>>>>>>> Category 2014. >>>>>>>>>>>>> >>>>>>>>>>>>> *RISING STAR AWARDS* >>>>>>>>>>>>> RISING STAR AWARDS: Finalist, ICT Category, 2014-2015. >>>>>>>>>>>>> >>>>>>>>>>>>> *DAYSTAR ALUMNI AWARDS* >>>>>>>>>>>>> WINNER-Business Progression Entrepreneurship Award 2016 >>>>>>>>>>>>> >>>>>>>>>>>>> *GOOGLE CODE IN US* >>>>>>>>>>>>> *2018 Certified Google Code-in US Mentor* >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>> Mifos-users mailing list >>>>>>>>>>>>> mifos-us...@lists.sourceforge.net >>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> *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> >>>>>>>>>>>> >>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>> Mifos-users mailing list >>>>>>>>>>>> mifos-us...@lists.sourceforge.net >>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> LSC. Luis Alegría >>>>>>>>> INNOVARAPP >>>>>>>>> >>>>>>>>> *La información contenida en este correo electrónico y anexos es >>>>>>>>> confidencial. Ésta dirigida únicamente para el uso del individuo o >>>>>>>>> entidad >>>>>>>>> a la que fue dirigida y puede contener información propietaria que no >>>>>>>>> es >>>>>>>>> del dominio público. Si has recibido este correo por error o no eres >>>>>>>>> el >>>>>>>>> destinatario, por favor notificar al remitente de inmediato y borra >>>>>>>>> este >>>>>>>>> mensaje de la computadora o dispositivo. Cualquier uso, distribución o >>>>>>>>> reproducción de este correo que no sea por el destinatario de >>>>>>>>> intención >>>>>>>>> queda prohibido.* >>>>>>>>> Mifos-developer mailing list >>>>>>>>> mifos-develo...@lists.sourceforge.net >>>>>>>>> Unsubscribe or change settings at: >>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>> Mifos-users mailing list >>>>>>> mifos-us...@lists.sourceforge.net >>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>>> >>>>>> Mifos-developer mailing list >>>>> mifos-develo...@lists.sourceforge.net >>>>> Unsubscribe or change settings at: >>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer >>>> >>>> >>
