You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Ed Cable <ed...@mifos.org> on 2020/08/18 14:57:34 UTC

Classpath Errors when attempting to run Pentaho on latest Fineract

Hi all,

Just re-naming this thread and bumping to the top as it's @Luis Alberto
Alegría de los Santos <lu...@innovar.app> and @Francis Guchie
<fr...@gmail.com> could use some help in addressing the classpath
errors they're facing in trying to get a working PR for support of Pentaho
reports on top of the latest Fineract release which is a show-stopping
issue for the next Mifos X release.

Please see the the trailing thread for most recent issues.

@Petri Tuomola <pe...@tuomola.org> @manthansurkar@gmail.com
<ma...@gmail.com> @Yemdjih Kaze Nasser <ka...@gmail.com>
@percyayukashu@gmail.com <pe...@gmail.com> Any time to look into
helping resolve the issues?

Thanks,

Ed

---------- Forwarded message ---------
From: Francis Guchie <fr...@gmail.com>
Date: Mon, Aug 17, 2020 at 5:40 PM
Subject: Re: [Mifos-developer] [Mifos-users] Tables Created but field is
not active
To: Ed Cable <ed...@mifos.org>
Cc: Luis Alberto Alegría de los Santos <lu...@innovar.app>, Edwin
Nchia <ed...@gmail.com>, Bharath Gowda <bg...@mifos.org>



This  classpath error happens for both my branch
https://github.com/francisguchie/fineract/tree/supportPentahoReports
and that of Luis
https://github.com/luisalegria/fineract-1/tree/19.14Pentaho

However, the war file he provided works fine and the pentaho reports
display, of course my own build runs successfully with ./gradlew clean
bootWar
I think if we can solve the jar HELL error we are good to go. We need a
java guru to look at our code and get it solved


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 Tue, Aug 18, 2020 at 12:07 AM Francis Guchie <fr...@gmail.com>
wrote:

> Dear Ed and All,
>
> With the following on my windows PC -
> gradle 6.5.1
> Jdk 11.0.8
> node v14.4.0
> npm v 6.14.5
> kotlin 1.3.72
> groovy 2.5.11
>
>
> The error i get when i run  ./gradlew clean build is shown below
>
> org.opentest4j.AssertionFailedError: 3 Classpath duplicates detected:
> overview.html
>     jar:file:/C:/Users/..../org.mnode.ical4j/ical4j/3.0.19/5aa648ce509674af21b3a46ce1efb5aa3300b651/ical4j-3.0.19.jar!/overview.html
>     jar:file:/C:/Users/..../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/..../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/..../pentaho-library/libfonts/1.2.8/8d20d16c7b4022480df8fb8aa7c51f6357ff1817/libfonts-1.2.8.jar!/overview.html
>     jar:file:/C:/Users/..../pentaho-library/libserializer/1.2.8/52d4ccad3fa757ec040a3da34314d08c4a071332/libserializer-1.2.8.jar!/overview.html
> classic-engine.properties
>     jar:file:/C:/Users/..../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/..../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/..../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/..../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/..../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
>     jar:file:/C:/Users/..../pentaho-library/libdocbundle/1.2.8/9bde3c7aa2154a08e6c7bfdfd6d35dc3b18d05aa/libdocbundle-1.2.8.jar!/loader.properties
>     jar:file:/C:/Users/..../pentaho-library/libxml/1.2.8/60a57221b2f5b3ac5e8822bf14001640738a6ab/libxml-1.2.8.jar!/loader.properties
>
>
> The Error
>
> 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 17, 2020 at 6:40 PM Francis Guchie <fr...@gmail.com>
> wrote:
>
>> It would be fare for me to apologize for not responding this late.
>>
>> Thanks to Luis for setting the precedence.
>>
>> Yes Ed,
>> I will share my findings for both the warfile I got from Luis and also
>> the error I get when I follow the checks for raising a PR. I should be able
>> to share by 18th August 2020 12pm GMT
>>
>>
>> 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 17, 2020, 17:37 Ed Cable <ed...@mifos.org> wrote:
>>
>>> Thanks for the update Luis. Adding Bharath to this thread too.
>>>
>>> Francis - are you able to surface the issues that you all have been
>>> facing on-list. I'm trying to ensure we can ship this as part of the
>>> upcoming release.
>>>
>>> Once it's clear on-list what the blockers are, I'll try to escalate it
>>> to others in community to assist.
>>>
>>> Ed
>>>
>>> On Mon, Aug 17, 2020 at 9:18 AM Luis Alberto Alegría de los Santos
>>> <lu...@innovar.app> wrote:
>>>
>>>> Hi all
>>>>
>>>> Sorry for the late reply, I've been pretty busy with some projects
>>>> since last week.
>>>>
>>>> Last week I created a fork with pentaho support, on my machine I would
>>>> be able to compile a war file and run some reports. I share the war file to
>>>> Francis to test it to know it works well, he's working on it.
>>>>
>>>> Francis and I worked to try to execute some previous steps before
>>>> making a PR to fineract project, We are stuck  on these steps, it looks
>>>> like some of these steps make changes on files and we get some error
>>>> messages, different messages on Francis computer  and my computer.
>>>>
>>>> Please, let me finish some tasks on my projects, and I think next week
>>>> I could solve the issues with the pentaho support.
>>>>
>>>> I'm so sorry Ed and apologize to you.
>>>>
>>>> Kind regards
>>>>
>>>> El jue., 13 ago. 2020 a las 14:29, Ed Cable (<ed...@mifos.org>)
>>>> escribió:
>>>>
>>>>> 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 <fr...@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, <bg...@mifos.org>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hi Luis and Francis,
>>>>>>>>
>>>>>>>> @Luis Alberto Alegría de los Santos <lu...@innovar.app>  Thank
>>>>>>>> you for your great effort in fixing the issue and narrowing down the other
>>>>>>>> related issues.
>>>>>>>>
>>>>>>>> @Francis Guchie <fr...@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 <
>>>>>>>> francisguchie@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 <
>>>>>>>>> francisguchie@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 <lu...@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 <
>>>>>>>>>>> francisguchie@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 <lu...@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 (<
>>>>>>>>>>>>> francisguchie@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 <
>>>>>>>>>>>>>> bgowda@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 <ed...@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 <
>>>>>>>>>>>>>>>> ntiritumusa@gmail.com> wrote:
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> Thanks so much, Congratulations Luis
>>>>>>>>>>>>>>>>> Moses
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> On Mon, Jul 20, 2020 at 4:05 PM Bharath Gowda <
>>>>>>>>>>>>>>>>> bgowda@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 @francisguchie@gmail.com <fr...@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 <lu...@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 (<
>>>>>>>>>>>>>>>>>>> francisguchie@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 <lu...@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 (<
>>>>>>>>>>>>>>>>>>>>> yuwa909@gmail.com>) escribió:
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>> This is great,  looking foward to this update.
>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>> On Mon, Jul 13, 2020, 13:16 Bharath Gowda <
>>>>>>>>>>>>>>>>>>>>>> bgowda@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
>>>>>>>>>>>>>>>>>>>>>>> <lu...@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
>>>>>>>>>>>>>>>>>>>>>>> <lu...@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 <
>>>>>>>>>>>>>>>>>>>>>>> yuwa909@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 <
>>>>>>>>>>>>>>>>>>>>>>>> airsaylongcon@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 <
>>>>>>>>>>>>>>>>>>>>>>>>> bgowda@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 <
>>>>>>>>>>>>>>>>>>>>>>>>> edwingudfriend@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>> Sure, here it is.
>>>>>>>>>>>>>>>>>>>>>>>>>> 18.03.01
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>> On Tue, 7 Jul 2020 16:35 Bharath Gowda, <
>>>>>>>>>>>>>>>>>>>>>>>>>> bgowda@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>>> edwingudfriend@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> Hello! I have created a table but the field is
>>>>>>>>>>>>>>>>>>>>>>>>>>>> not active, where I wrong?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@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-users@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-developer@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>> Mifos-users@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-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>> *Ed Cable*
>>>>>>>>>>>>>>>> President/CEO, Mifos Initiative
>>>>>>>>>>>>>>>> edcable@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-users@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-developer@lists.sourceforge.net
>>>>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>>>>
>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>
>>>>>>>>>> Mifos-developer mailing list
>>>>>>>>> mifos-developer@lists.sourceforge.net
>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>>> --
>>>> 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.*
>>>>
>>>
>>>
>>> --
>>> *Ed Cable*
>>> President/CEO, Mifos Initiative
>>> edcable@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>
>>>
>>>

-- 
*Ed Cable*
President/CEO, Mifos Initiative
edcable@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>

Re: Classpath Errors when attempting to run Pentaho on latest Fineract

Posted by Ed Cable <ed...@mifos.org>.
Nasser,

It would be great if you could open up a PR - this would enable Pentaho
reports to once again run in the Mifos X distribution on top of Fineract.
While we can't ship Pentaho as part of Fineract for license reasons, the
fix that you're helping Francis/Luis make would enable Pentaho reports to
be supported through Mifos X once again as a change during the previous
release cycles resulted in that.

Ed

On Wed, Aug 19, 2020 at 2:00 AM Yemdjih Kaze Nasser <ka...@gmail.com>
wrote:

> Hey Francis, as Petri suggested, adding the appropriate resources to
> harmless duplicates resolves the issue.
> I have a proposed patch here:
> https://github.com/francisguchie/fineract/compare/supportPentahoReports...xurror:pentaho-reports?expand=1
> Check it out and let me know what you think.
>
> Ed, if you think this can go in release 1.4.0, let me know so I open a PR
> for it. Unfortunately there is no support for pentaho in fineract and I
> don't know why that is.
>
> Best regards,
> Y. K. Nasser
>
> On Tue, 18 Aug 2020 at 16:13, Petri Tuomola <pe...@tuomola.org> wrote:
>
>> Hi Ed - I sent the below suggestion earlier today. As far as I can see,
>> that should resolve the issue Francis is facing:
>>
>> ------
>>
>> Hi Francis
>>
>> If this is a valid and harmless duplicate (i.e. all the JARs include
>> "overview.html" but that doesn't affect the functionality), you can exclude
>> the relevant files from the duplicate check by adding them to the function
>> org.apache.fineract.infrastructure.classdupes.
>> ClasspathHellDuplicatesChecker.isHarmlessDuplicate()
>>
>> Have you tried this to resolve your issue?
>>
>> Regards
>> Petri
>>
>>
>> On Tue, 18 Aug 2020, 5:58 pm Ed Cable, <ed...@mifos.org> wrote:
>>
>>> Hi all,
>>>
>>> Just re-naming this thread and bumping to the top as it's @Luis Alberto
>>> Alegría de los Santos <lu...@innovar.app> and @Francis Guchie
>>> <fr...@gmail.com> could use some help in addressing the
>>> classpath errors they're facing in trying to get a working PR for support
>>> of Pentaho reports on top of the latest Fineract release which is a
>>> show-stopping issue for the next Mifos X release.
>>>
>>> Please see the the trailing thread for most recent issues.
>>>
>>> @Petri Tuomola <pe...@tuomola.org> @manthansurkar@gmail.com
>>> <ma...@gmail.com> @Yemdjih Kaze Nasser <ka...@gmail.com>
>>> @percyayukashu@gmail.com <pe...@gmail.com> Any time to look
>>> into helping resolve the issues?
>>>
>>> Thanks,
>>>
>>> Ed
>>>
>>> ---------- Forwarded message ---------
>>> From: Francis Guchie <fr...@gmail.com>
>>> Date: Mon, Aug 17, 2020 at 5:40 PM
>>> Subject: Re: [Mifos-developer] [Mifos-users] Tables Created but field is
>>> not active
>>> To: Ed Cable <ed...@mifos.org>
>>> Cc: Luis Alberto Alegría de los Santos <lu...@innovar.app>,
>>> Edwin Nchia <ed...@gmail.com>, Bharath Gowda <bg...@mifos.org>
>>>
>>>
>>>
>>> This  classpath error happens for both my branch
>>> https://github.com/francisguchie/fineract/tree/supportPentahoReports
>>> and that of Luis
>>> https://github.com/luisalegria/fineract-1/tree/19.14Pentaho
>>>
>>> However, the war file he provided works fine and the pentaho reports
>>> display, of course my own build runs successfully with ./gradlew clean
>>> bootWar
>>> I think if we can solve the jar HELL error we are good to go. We need a
>>> java guru to look at our code and get it solved
>>>
>>>
>>> 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 Tue, Aug 18, 2020 at 12:07 AM Francis Guchie <fr...@gmail.com>
>>> wrote:
>>>
>>>> Dear Ed and All,
>>>>
>>>> With the following on my windows PC -
>>>> gradle 6.5.1
>>>> Jdk 11.0.8
>>>> node v14.4.0
>>>> npm v 6.14.5
>>>> kotlin 1.3.72
>>>> groovy 2.5.11
>>>>
>>>>
>>>> The error i get when i run  ./gradlew clean build is shown below
>>>>
>>>> org.opentest4j.AssertionFailedError: 3 Classpath duplicates detected:
>>>> overview.html
>>>>     jar:file:/C:/Users/..../org.mnode.ical4j/ical4j/3.0.19/5aa648ce509674af21b3a46ce1efb5aa3300b651/ical4j-3.0.19.jar!/overview.html
>>>>     jar:file:/C:/Users/..../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/..../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/..../pentaho-library/libfonts/1.2.8/8d20d16c7b4022480df8fb8aa7c51f6357ff1817/libfonts-1.2.8.jar!/overview.html
>>>>     jar:file:/C:/Users/..../pentaho-library/libserializer/1.2.8/52d4ccad3fa757ec040a3da34314d08c4a071332/libserializer-1.2.8.jar!/overview.html
>>>> classic-engine.properties
>>>>     jar:file:/C:/Users/..../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/..../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/..../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/..../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/..../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
>>>>     jar:file:/C:/Users/..../pentaho-library/libdocbundle/1.2.8/9bde3c7aa2154a08e6c7bfdfd6d35dc3b18d05aa/libdocbundle-1.2.8.jar!/loader.properties
>>>>     jar:file:/C:/Users/..../pentaho-library/libxml/1.2.8/60a57221b2f5b3ac5e8822bf14001640738a6ab/libxml-1.2.8.jar!/loader.properties
>>>>
>>>>
>>>> The Error
>>>>
>>>> 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 17, 2020 at 6:40 PM Francis Guchie <fr...@gmail.com>
>>>> wrote:
>>>>
>>>>> It would be fare for me to apologize for not responding this late.
>>>>>
>>>>> Thanks to Luis for setting the precedence.
>>>>>
>>>>> Yes Ed,
>>>>> I will share my findings for both the warfile I got from Luis and also
>>>>> the error I get when I follow the checks for raising a PR. I should be able
>>>>> to share by 18th August 2020 12pm GMT
>>>>>
>>>>>
>>>>> 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 17, 2020, 17:37 Ed Cable <ed...@mifos.org> wrote:
>>>>>
>>>>>> Thanks for the update Luis. Adding Bharath to this thread too.
>>>>>>
>>>>>> Francis - are you able to surface the issues that you all have been
>>>>>> facing on-list. I'm trying to ensure we can ship this as part of the
>>>>>> upcoming release.
>>>>>>
>>>>>> Once it's clear on-list what the blockers are, I'll try to escalate
>>>>>> it to others in community to assist.
>>>>>>
>>>>>> Ed
>>>>>>
>>>>>> On Mon, Aug 17, 2020 at 9:18 AM Luis Alberto Alegría de los Santos
>>>>>> <lu...@innovar.app> wrote:
>>>>>>
>>>>>>> Hi all
>>>>>>>
>>>>>>> Sorry for the late reply, I've been pretty busy with some projects
>>>>>>> since last week.
>>>>>>>
>>>>>>> Last week I created a fork with pentaho support, on my machine I
>>>>>>> would be able to compile a war file and run some reports. I share the war
>>>>>>> file to Francis to test it to know it works well, he's working on it.
>>>>>>>
>>>>>>> Francis and I worked to try to execute some previous steps before
>>>>>>> making a PR to fineract project, We are stuck  on these steps, it looks
>>>>>>> like some of these steps make changes on files and we get some error
>>>>>>> messages, different messages on Francis computer  and my computer.
>>>>>>>
>>>>>>> Please, let me finish some tasks on my projects, and I think next
>>>>>>> week I could solve the issues with the pentaho support.
>>>>>>>
>>>>>>> I'm so sorry Ed and apologize to you.
>>>>>>>
>>>>>>> Kind regards
>>>>>>>
>>>>>>> El jue., 13 ago. 2020 a las 14:29, Ed Cable (<ed...@mifos.org>)
>>>>>>> escribió:
>>>>>>>
>>>>>>>> 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 <
>>>>>>>>> francisguchie@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, <bg...@mifos.org>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi Luis and Francis,
>>>>>>>>>>>
>>>>>>>>>>> @Luis Alberto Alegría de los Santos <lu...@innovar.app>  Thank
>>>>>>>>>>> you for your great effort in fixing the issue and narrowing down the other
>>>>>>>>>>> related issues.
>>>>>>>>>>>
>>>>>>>>>>> @Francis Guchie <fr...@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 <
>>>>>>>>>>> francisguchie@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 <
>>>>>>>>>>>> francisguchie@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 <lu...@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 <
>>>>>>>>>>>>>> francisguchie@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 <lu...@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 (<
>>>>>>>>>>>>>>>> francisguchie@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 <
>>>>>>>>>>>>>>>>> bgowda@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 <
>>>>>>>>>>>>>>>>>> edcable@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 <
>>>>>>>>>>>>>>>>>>> ntiritumusa@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>> Thanks so much, Congratulations Luis
>>>>>>>>>>>>>>>>>>>> Moses
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>> On Mon, Jul 20, 2020 at 4:05 PM Bharath Gowda <
>>>>>>>>>>>>>>>>>>>> bgowda@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 @francisguchie@gmail.com
>>>>>>>>>>>>>>>>>>>>> <fr...@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 <lu...@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 (<
>>>>>>>>>>>>>>>>>>>>>> francisguchie@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 <lu...@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 (<
>>>>>>>>>>>>>>>>>>>>>>>> yuwa909@gmail.com>) escribió:
>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> This is great,  looking foward to this update.
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> On Mon, Jul 13, 2020, 13:16 Bharath Gowda <
>>>>>>>>>>>>>>>>>>>>>>>>> bgowda@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
>>>>>>>>>>>>>>>>>>>>>>>>>> <lu...@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
>>>>>>>>>>>>>>>>>>>>>>>>>> <lu...@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>> yuwa909@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>>> airsaylongcon@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>>>> bgowda@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>>>> edwingudfriend@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Sure, here it is.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 18.03.01
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> On Tue, 7 Jul 2020 16:35 Bharath Gowda, <
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> bgowda@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> edwingudfriend@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Hello! I have created a table but the field
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> is not active, where I wrong?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@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-users@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-developer@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>> Mifos-users@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-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>>> *Ed Cable*
>>>>>>>>>>>>>>>>>>> President/CEO, Mifos Initiative
>>>>>>>>>>>>>>>>>>> edcable@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-users@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-developer@lists.sourceforge.net
>>>>>>>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>
>>>>>>>>>>>>> Mifos-developer mailing list
>>>>>>>>>>>> mifos-developer@lists.sourceforge.net
>>>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> 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.*
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> *Ed Cable*
>>>>>> President/CEO, Mifos Initiative
>>>>>> edcable@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>
>>>>>>
>>>>>>
>>>
>>> --
>>> *Ed Cable*
>>> President/CEO, Mifos Initiative
>>> edcable@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>
>>>
>>>

-- 
*Ed Cable*
President/CEO, Mifos Initiative
edcable@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>

Re: Classpath Errors when attempting to run Pentaho on latest Fineract

Posted by Yemdjih Kaze Nasser <ka...@gmail.com>.
Hey Francis, as Petri suggested, adding the appropriate resources to
harmless duplicates resolves the issue.
I have a proposed patch here:
https://github.com/francisguchie/fineract/compare/supportPentahoReports...xurror:pentaho-reports?expand=1
Check it out and let me know what you think.

Ed, if you think this can go in release 1.4.0, let me know so I open a PR
for it. Unfortunately there is no support for pentaho in fineract and I
don't know why that is.

Best regards,
Y. K. Nasser

On Tue, 18 Aug 2020 at 16:13, Petri Tuomola <pe...@tuomola.org> wrote:

> Hi Ed - I sent the below suggestion earlier today. As far as I can see,
> that should resolve the issue Francis is facing:
>
> ------
>
> Hi Francis
>
> If this is a valid and harmless duplicate (i.e. all the JARs include
> "overview.html" but that doesn't affect the functionality), you can exclude
> the relevant files from the duplicate check by adding them to the function
> org.apache.fineract.infrastructure.classdupes.
> ClasspathHellDuplicatesChecker.isHarmlessDuplicate()
>
> Have you tried this to resolve your issue?
>
> Regards
> Petri
>
>
> On Tue, 18 Aug 2020, 5:58 pm Ed Cable, <ed...@mifos.org> wrote:
>
>> Hi all,
>>
>> Just re-naming this thread and bumping to the top as it's @Luis Alberto
>> Alegría de los Santos <lu...@innovar.app> and @Francis Guchie
>> <fr...@gmail.com> could use some help in addressing the
>> classpath errors they're facing in trying to get a working PR for support
>> of Pentaho reports on top of the latest Fineract release which is a
>> show-stopping issue for the next Mifos X release.
>>
>> Please see the the trailing thread for most recent issues.
>>
>> @Petri Tuomola <pe...@tuomola.org> @manthansurkar@gmail.com
>> <ma...@gmail.com> @Yemdjih Kaze Nasser <ka...@gmail.com>
>> @percyayukashu@gmail.com <pe...@gmail.com> Any time to look into
>> helping resolve the issues?
>>
>> Thanks,
>>
>> Ed
>>
>> ---------- Forwarded message ---------
>> From: Francis Guchie <fr...@gmail.com>
>> Date: Mon, Aug 17, 2020 at 5:40 PM
>> Subject: Re: [Mifos-developer] [Mifos-users] Tables Created but field is
>> not active
>> To: Ed Cable <ed...@mifos.org>
>> Cc: Luis Alberto Alegría de los Santos <lu...@innovar.app>, Edwin
>> Nchia <ed...@gmail.com>, Bharath Gowda <bg...@mifos.org>
>>
>>
>>
>> This  classpath error happens for both my branch
>> https://github.com/francisguchie/fineract/tree/supportPentahoReports
>> and that of Luis
>> https://github.com/luisalegria/fineract-1/tree/19.14Pentaho
>>
>> However, the war file he provided works fine and the pentaho reports
>> display, of course my own build runs successfully with ./gradlew clean
>> bootWar
>> I think if we can solve the jar HELL error we are good to go. We need a
>> java guru to look at our code and get it solved
>>
>>
>> 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 Tue, Aug 18, 2020 at 12:07 AM Francis Guchie <fr...@gmail.com>
>> wrote:
>>
>>> Dear Ed and All,
>>>
>>> With the following on my windows PC -
>>> gradle 6.5.1
>>> Jdk 11.0.8
>>> node v14.4.0
>>> npm v 6.14.5
>>> kotlin 1.3.72
>>> groovy 2.5.11
>>>
>>>
>>> The error i get when i run  ./gradlew clean build is shown below
>>>
>>> org.opentest4j.AssertionFailedError: 3 Classpath duplicates detected:
>>> overview.html
>>>     jar:file:/C:/Users/..../org.mnode.ical4j/ical4j/3.0.19/5aa648ce509674af21b3a46ce1efb5aa3300b651/ical4j-3.0.19.jar!/overview.html
>>>     jar:file:/C:/Users/..../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/..../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/..../pentaho-library/libfonts/1.2.8/8d20d16c7b4022480df8fb8aa7c51f6357ff1817/libfonts-1.2.8.jar!/overview.html
>>>     jar:file:/C:/Users/..../pentaho-library/libserializer/1.2.8/52d4ccad3fa757ec040a3da34314d08c4a071332/libserializer-1.2.8.jar!/overview.html
>>> classic-engine.properties
>>>     jar:file:/C:/Users/..../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/..../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/..../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/..../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/..../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
>>>     jar:file:/C:/Users/..../pentaho-library/libdocbundle/1.2.8/9bde3c7aa2154a08e6c7bfdfd6d35dc3b18d05aa/libdocbundle-1.2.8.jar!/loader.properties
>>>     jar:file:/C:/Users/..../pentaho-library/libxml/1.2.8/60a57221b2f5b3ac5e8822bf14001640738a6ab/libxml-1.2.8.jar!/loader.properties
>>>
>>>
>>> The Error
>>>
>>> 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 17, 2020 at 6:40 PM Francis Guchie <fr...@gmail.com>
>>> wrote:
>>>
>>>> It would be fare for me to apologize for not responding this late.
>>>>
>>>> Thanks to Luis for setting the precedence.
>>>>
>>>> Yes Ed,
>>>> I will share my findings for both the warfile I got from Luis and also
>>>> the error I get when I follow the checks for raising a PR. I should be able
>>>> to share by 18th August 2020 12pm GMT
>>>>
>>>>
>>>> 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 17, 2020, 17:37 Ed Cable <ed...@mifos.org> wrote:
>>>>
>>>>> Thanks for the update Luis. Adding Bharath to this thread too.
>>>>>
>>>>> Francis - are you able to surface the issues that you all have been
>>>>> facing on-list. I'm trying to ensure we can ship this as part of the
>>>>> upcoming release.
>>>>>
>>>>> Once it's clear on-list what the blockers are, I'll try to escalate it
>>>>> to others in community to assist.
>>>>>
>>>>> Ed
>>>>>
>>>>> On Mon, Aug 17, 2020 at 9:18 AM Luis Alberto Alegría de los Santos
>>>>> <lu...@innovar.app> wrote:
>>>>>
>>>>>> Hi all
>>>>>>
>>>>>> Sorry for the late reply, I've been pretty busy with some projects
>>>>>> since last week.
>>>>>>
>>>>>> Last week I created a fork with pentaho support, on my machine I
>>>>>> would be able to compile a war file and run some reports. I share the war
>>>>>> file to Francis to test it to know it works well, he's working on it.
>>>>>>
>>>>>> Francis and I worked to try to execute some previous steps before
>>>>>> making a PR to fineract project, We are stuck  on these steps, it looks
>>>>>> like some of these steps make changes on files and we get some error
>>>>>> messages, different messages on Francis computer  and my computer.
>>>>>>
>>>>>> Please, let me finish some tasks on my projects, and I think next
>>>>>> week I could solve the issues with the pentaho support.
>>>>>>
>>>>>> I'm so sorry Ed and apologize to you.
>>>>>>
>>>>>> Kind regards
>>>>>>
>>>>>> El jue., 13 ago. 2020 a las 14:29, Ed Cable (<ed...@mifos.org>)
>>>>>> escribió:
>>>>>>
>>>>>>> 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 <fr...@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, <bg...@mifos.org>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> Hi Luis and Francis,
>>>>>>>>>>
>>>>>>>>>> @Luis Alberto Alegría de los Santos <lu...@innovar.app>  Thank
>>>>>>>>>> you for your great effort in fixing the issue and narrowing down the other
>>>>>>>>>> related issues.
>>>>>>>>>>
>>>>>>>>>> @Francis Guchie <fr...@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 <
>>>>>>>>>> francisguchie@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 <
>>>>>>>>>>> francisguchie@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 <lu...@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 <
>>>>>>>>>>>>> francisguchie@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 <lu...@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 (<
>>>>>>>>>>>>>>> francisguchie@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 <
>>>>>>>>>>>>>>>> bgowda@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 <ed...@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 <
>>>>>>>>>>>>>>>>>> ntiritumusa@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> Thanks so much, Congratulations Luis
>>>>>>>>>>>>>>>>>>> Moses
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> On Mon, Jul 20, 2020 at 4:05 PM Bharath Gowda <
>>>>>>>>>>>>>>>>>>> bgowda@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 @francisguchie@gmail.com
>>>>>>>>>>>>>>>>>>>> <fr...@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 <lu...@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 (<
>>>>>>>>>>>>>>>>>>>>> francisguchie@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 <lu...@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 (<
>>>>>>>>>>>>>>>>>>>>>>> yuwa909@gmail.com>) escribió:
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>> This is great,  looking foward to this update.
>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>> On Mon, Jul 13, 2020, 13:16 Bharath Gowda <
>>>>>>>>>>>>>>>>>>>>>>>> bgowda@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
>>>>>>>>>>>>>>>>>>>>>>>>> <lu...@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
>>>>>>>>>>>>>>>>>>>>>>>>> <lu...@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 <
>>>>>>>>>>>>>>>>>>>>>>>>> yuwa909@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>> airsaylongcon@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>>> bgowda@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>>> edwingudfriend@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> Sure, here it is.
>>>>>>>>>>>>>>>>>>>>>>>>>>>> 18.03.01
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> On Tue, 7 Jul 2020 16:35 Bharath Gowda, <
>>>>>>>>>>>>>>>>>>>>>>>>>>>> bgowda@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> edwingudfriend@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Hello! I have created a table but the field
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> is not active, where I wrong?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@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-users@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-developer@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>> Mifos-users@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-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>> *Ed Cable*
>>>>>>>>>>>>>>>>>> President/CEO, Mifos Initiative
>>>>>>>>>>>>>>>>>> edcable@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-users@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-developer@lists.sourceforge.net
>>>>>>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>
>>>>>>>>>>>> Mifos-developer mailing list
>>>>>>>>>>> mifos-developer@lists.sourceforge.net
>>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>>
>>>>>> --
>>>>>> 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.*
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> *Ed Cable*
>>>>> President/CEO, Mifos Initiative
>>>>> edcable@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>
>>>>>
>>>>>
>>
>> --
>> *Ed Cable*
>> President/CEO, Mifos Initiative
>> edcable@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>
>>
>>

Re: Classpath Errors when attempting to run Pentaho on latest Fineract

Posted by Petri Tuomola <pe...@tuomola.org>.
Hi Ed - I sent the below suggestion earlier today. As far as I can see,
that should resolve the issue Francis is facing:

------

Hi Francis

If this is a valid and harmless duplicate (i.e. all the JARs include
"overview.html" but that doesn't affect the functionality), you can exclude
the relevant files from the duplicate check by adding them to the function
org.apache.fineract.infrastructure.classdupes.
ClasspathHellDuplicatesChecker.isHarmlessDuplicate()

Have you tried this to resolve your issue?

Regards
Petri


On Tue, 18 Aug 2020, 5:58 pm Ed Cable, <ed...@mifos.org> wrote:

> Hi all,
>
> Just re-naming this thread and bumping to the top as it's @Luis Alberto
> Alegría de los Santos <lu...@innovar.app> and @Francis Guchie
> <fr...@gmail.com> could use some help in addressing the classpath
> errors they're facing in trying to get a working PR for support of Pentaho
> reports on top of the latest Fineract release which is a show-stopping
> issue for the next Mifos X release.
>
> Please see the the trailing thread for most recent issues.
>
> @Petri Tuomola <pe...@tuomola.org> @manthansurkar@gmail.com
> <ma...@gmail.com> @Yemdjih Kaze Nasser <ka...@gmail.com>
> @percyayukashu@gmail.com <pe...@gmail.com> Any time to look into
> helping resolve the issues?
>
> Thanks,
>
> Ed
>
> ---------- Forwarded message ---------
> From: Francis Guchie <fr...@gmail.com>
> Date: Mon, Aug 17, 2020 at 5:40 PM
> Subject: Re: [Mifos-developer] [Mifos-users] Tables Created but field is
> not active
> To: Ed Cable <ed...@mifos.org>
> Cc: Luis Alberto Alegría de los Santos <lu...@innovar.app>, Edwin
> Nchia <ed...@gmail.com>, Bharath Gowda <bg...@mifos.org>
>
>
>
> This  classpath error happens for both my branch
> https://github.com/francisguchie/fineract/tree/supportPentahoReports
> and that of Luis
> https://github.com/luisalegria/fineract-1/tree/19.14Pentaho
>
> However, the war file he provided works fine and the pentaho reports
> display, of course my own build runs successfully with ./gradlew clean
> bootWar
> I think if we can solve the jar HELL error we are good to go. We need a
> java guru to look at our code and get it solved
>
>
> 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 Tue, Aug 18, 2020 at 12:07 AM Francis Guchie <fr...@gmail.com>
> wrote:
>
>> Dear Ed and All,
>>
>> With the following on my windows PC -
>> gradle 6.5.1
>> Jdk 11.0.8
>> node v14.4.0
>> npm v 6.14.5
>> kotlin 1.3.72
>> groovy 2.5.11
>>
>>
>> The error i get when i run  ./gradlew clean build is shown below
>>
>> org.opentest4j.AssertionFailedError: 3 Classpath duplicates detected:
>> overview.html
>>     jar:file:/C:/Users/..../org.mnode.ical4j/ical4j/3.0.19/5aa648ce509674af21b3a46ce1efb5aa3300b651/ical4j-3.0.19.jar!/overview.html
>>     jar:file:/C:/Users/..../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/..../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/..../pentaho-library/libfonts/1.2.8/8d20d16c7b4022480df8fb8aa7c51f6357ff1817/libfonts-1.2.8.jar!/overview.html
>>     jar:file:/C:/Users/..../pentaho-library/libserializer/1.2.8/52d4ccad3fa757ec040a3da34314d08c4a071332/libserializer-1.2.8.jar!/overview.html
>> classic-engine.properties
>>     jar:file:/C:/Users/..../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/..../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/..../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/..../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/..../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
>>     jar:file:/C:/Users/..../pentaho-library/libdocbundle/1.2.8/9bde3c7aa2154a08e6c7bfdfd6d35dc3b18d05aa/libdocbundle-1.2.8.jar!/loader.properties
>>     jar:file:/C:/Users/..../pentaho-library/libxml/1.2.8/60a57221b2f5b3ac5e8822bf14001640738a6ab/libxml-1.2.8.jar!/loader.properties
>>
>>
>> The Error
>>
>> 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 17, 2020 at 6:40 PM Francis Guchie <fr...@gmail.com>
>> wrote:
>>
>>> It would be fare for me to apologize for not responding this late.
>>>
>>> Thanks to Luis for setting the precedence.
>>>
>>> Yes Ed,
>>> I will share my findings for both the warfile I got from Luis and also
>>> the error I get when I follow the checks for raising a PR. I should be able
>>> to share by 18th August 2020 12pm GMT
>>>
>>>
>>> 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 17, 2020, 17:37 Ed Cable <ed...@mifos.org> wrote:
>>>
>>>> Thanks for the update Luis. Adding Bharath to this thread too.
>>>>
>>>> Francis - are you able to surface the issues that you all have been
>>>> facing on-list. I'm trying to ensure we can ship this as part of the
>>>> upcoming release.
>>>>
>>>> Once it's clear on-list what the blockers are, I'll try to escalate it
>>>> to others in community to assist.
>>>>
>>>> Ed
>>>>
>>>> On Mon, Aug 17, 2020 at 9:18 AM Luis Alberto Alegría de los Santos
>>>> <lu...@innovar.app> wrote:
>>>>
>>>>> Hi all
>>>>>
>>>>> Sorry for the late reply, I've been pretty busy with some projects
>>>>> since last week.
>>>>>
>>>>> Last week I created a fork with pentaho support, on my machine I would
>>>>> be able to compile a war file and run some reports. I share the war file to
>>>>> Francis to test it to know it works well, he's working on it.
>>>>>
>>>>> Francis and I worked to try to execute some previous steps before
>>>>> making a PR to fineract project, We are stuck  on these steps, it looks
>>>>> like some of these steps make changes on files and we get some error
>>>>> messages, different messages on Francis computer  and my computer.
>>>>>
>>>>> Please, let me finish some tasks on my projects, and I think next week
>>>>> I could solve the issues with the pentaho support.
>>>>>
>>>>> I'm so sorry Ed and apologize to you.
>>>>>
>>>>> Kind regards
>>>>>
>>>>> El jue., 13 ago. 2020 a las 14:29, Ed Cable (<ed...@mifos.org>)
>>>>> escribió:
>>>>>
>>>>>> 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 <fr...@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, <bg...@mifos.org>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Hi Luis and Francis,
>>>>>>>>>
>>>>>>>>> @Luis Alberto Alegría de los Santos <lu...@innovar.app>  Thank
>>>>>>>>> you for your great effort in fixing the issue and narrowing down the other
>>>>>>>>> related issues.
>>>>>>>>>
>>>>>>>>> @Francis Guchie <fr...@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 <
>>>>>>>>> francisguchie@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 <
>>>>>>>>>> francisguchie@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 <lu...@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 <
>>>>>>>>>>>> francisguchie@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 <lu...@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 (<
>>>>>>>>>>>>>> francisguchie@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 <
>>>>>>>>>>>>>>> bgowda@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 <ed...@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 <
>>>>>>>>>>>>>>>>> ntiritumusa@gmail.com> wrote:
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> Thanks so much, Congratulations Luis
>>>>>>>>>>>>>>>>>> Moses
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> On Mon, Jul 20, 2020 at 4:05 PM Bharath Gowda <
>>>>>>>>>>>>>>>>>> bgowda@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 @francisguchie@gmail.com
>>>>>>>>>>>>>>>>>>> <fr...@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 <lu...@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 (<
>>>>>>>>>>>>>>>>>>>> francisguchie@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 <lu...@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 (<
>>>>>>>>>>>>>>>>>>>>>> yuwa909@gmail.com>) escribió:
>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>> This is great,  looking foward to this update.
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>> On Mon, Jul 13, 2020, 13:16 Bharath Gowda <
>>>>>>>>>>>>>>>>>>>>>>> bgowda@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
>>>>>>>>>>>>>>>>>>>>>>>> <lu...@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
>>>>>>>>>>>>>>>>>>>>>>>> <lu...@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 <
>>>>>>>>>>>>>>>>>>>>>>>> yuwa909@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 <
>>>>>>>>>>>>>>>>>>>>>>>>> airsaylongcon@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>> bgowda@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>> edwingudfriend@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Sure, here it is.
>>>>>>>>>>>>>>>>>>>>>>>>>>> 18.03.01
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> On Tue, 7 Jul 2020 16:35 Bharath Gowda, <
>>>>>>>>>>>>>>>>>>>>>>>>>>> bgowda@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>>>> edwingudfriend@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Hello! I have created a table but the field is
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> not active, where I wrong?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@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-users@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-developer@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>> Mifos-users@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-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>> *Ed Cable*
>>>>>>>>>>>>>>>>> President/CEO, Mifos Initiative
>>>>>>>>>>>>>>>>> edcable@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-users@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-developer@lists.sourceforge.net
>>>>>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>>>>>
>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>
>>>>>>>>>>> Mifos-developer mailing list
>>>>>>>>>> mifos-developer@lists.sourceforge.net
>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>
>>>>> --
>>>>> 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.*
>>>>>
>>>>
>>>>
>>>> --
>>>> *Ed Cable*
>>>> President/CEO, Mifos Initiative
>>>> edcable@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>
>>>>
>>>>
>
> --
> *Ed Cable*
> President/CEO, Mifos Initiative
> edcable@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>
>
>

Re: Classpath Errors when attempting to run Pentaho on latest Fineract

Posted by Ed Cable <ed...@mifos.org>.
My apologies as I had missed that Francis had already sent mail on this
with subject line, "Support for Pentaho for Mifos Latest build"

Please direct all messages on that thread.

Ed

On Tue, Aug 18, 2020 at 7:57 AM Ed Cable <ed...@mifos.org> wrote:

> Hi all,
>
> Just re-naming this thread and bumping to the top as it's @Luis Alberto
> Alegría de los Santos <lu...@innovar.app> and @Francis Guchie
> <fr...@gmail.com> could use some help in addressing the classpath
> errors they're facing in trying to get a working PR for support of Pentaho
> reports on top of the latest Fineract release which is a show-stopping
> issue for the next Mifos X release.
>
> Please see the the trailing thread for most recent issues.
>
> @Petri Tuomola <pe...@tuomola.org> @manthansurkar@gmail.com
> <ma...@gmail.com> @Yemdjih Kaze Nasser <ka...@gmail.com>
> @percyayukashu@gmail.com <pe...@gmail.com> Any time to look into
> helping resolve the issues?
>
> Thanks,
>
> Ed
>
> ---------- Forwarded message ---------
> From: Francis Guchie <fr...@gmail.com>
> Date: Mon, Aug 17, 2020 at 5:40 PM
> Subject: Re: [Mifos-developer] [Mifos-users] Tables Created but field is
> not active
> To: Ed Cable <ed...@mifos.org>
> Cc: Luis Alberto Alegría de los Santos <lu...@innovar.app>, Edwin
> Nchia <ed...@gmail.com>, Bharath Gowda <bg...@mifos.org>
>
>
>
> This  classpath error happens for both my branch
> https://github.com/francisguchie/fineract/tree/supportPentahoReports
> and that of Luis
> https://github.com/luisalegria/fineract-1/tree/19.14Pentaho
>
> However, the war file he provided works fine and the pentaho reports
> display, of course my own build runs successfully with ./gradlew clean
> bootWar
> I think if we can solve the jar HELL error we are good to go. We need a
> java guru to look at our code and get it solved
>
>
> 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 Tue, Aug 18, 2020 at 12:07 AM Francis Guchie <fr...@gmail.com>
> wrote:
>
>> Dear Ed and All,
>>
>> With the following on my windows PC -
>> gradle 6.5.1
>> Jdk 11.0.8
>> node v14.4.0
>> npm v 6.14.5
>> kotlin 1.3.72
>> groovy 2.5.11
>>
>>
>> The error i get when i run  ./gradlew clean build is shown below
>>
>> org.opentest4j.AssertionFailedError: 3 Classpath duplicates detected:
>> overview.html
>>     jar:file:/C:/Users/..../org.mnode.ical4j/ical4j/3.0.19/5aa648ce509674af21b3a46ce1efb5aa3300b651/ical4j-3.0.19.jar!/overview.html
>>     jar:file:/C:/Users/..../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/..../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/..../pentaho-library/libfonts/1.2.8/8d20d16c7b4022480df8fb8aa7c51f6357ff1817/libfonts-1.2.8.jar!/overview.html
>>     jar:file:/C:/Users/..../pentaho-library/libserializer/1.2.8/52d4ccad3fa757ec040a3da34314d08c4a071332/libserializer-1.2.8.jar!/overview.html
>> classic-engine.properties
>>     jar:file:/C:/Users/..../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/..../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/..../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/..../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/..../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
>>     jar:file:/C:/Users/..../pentaho-library/libdocbundle/1.2.8/9bde3c7aa2154a08e6c7bfdfd6d35dc3b18d05aa/libdocbundle-1.2.8.jar!/loader.properties
>>     jar:file:/C:/Users/..../pentaho-library/libxml/1.2.8/60a57221b2f5b3ac5e8822bf14001640738a6ab/libxml-1.2.8.jar!/loader.properties
>>
>>
>> The Error
>>
>> 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 17, 2020 at 6:40 PM Francis Guchie <fr...@gmail.com>
>> wrote:
>>
>>> It would be fare for me to apologize for not responding this late.
>>>
>>> Thanks to Luis for setting the precedence.
>>>
>>> Yes Ed,
>>> I will share my findings for both the warfile I got from Luis and also
>>> the error I get when I follow the checks for raising a PR. I should be able
>>> to share by 18th August 2020 12pm GMT
>>>
>>>
>>> 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 17, 2020, 17:37 Ed Cable <ed...@mifos.org> wrote:
>>>
>>>> Thanks for the update Luis. Adding Bharath to this thread too.
>>>>
>>>> Francis - are you able to surface the issues that you all have been
>>>> facing on-list. I'm trying to ensure we can ship this as part of the
>>>> upcoming release.
>>>>
>>>> Once it's clear on-list what the blockers are, I'll try to escalate it
>>>> to others in community to assist.
>>>>
>>>> Ed
>>>>
>>>> On Mon, Aug 17, 2020 at 9:18 AM Luis Alberto Alegría de los Santos
>>>> <lu...@innovar.app> wrote:
>>>>
>>>>> Hi all
>>>>>
>>>>> Sorry for the late reply, I've been pretty busy with some projects
>>>>> since last week.
>>>>>
>>>>> Last week I created a fork with pentaho support, on my machine I would
>>>>> be able to compile a war file and run some reports. I share the war file to
>>>>> Francis to test it to know it works well, he's working on it.
>>>>>
>>>>> Francis and I worked to try to execute some previous steps before
>>>>> making a PR to fineract project, We are stuck  on these steps, it looks
>>>>> like some of these steps make changes on files and we get some error
>>>>> messages, different messages on Francis computer  and my computer.
>>>>>
>>>>> Please, let me finish some tasks on my projects, and I think next week
>>>>> I could solve the issues with the pentaho support.
>>>>>
>>>>> I'm so sorry Ed and apologize to you.
>>>>>
>>>>> Kind regards
>>>>>
>>>>> El jue., 13 ago. 2020 a las 14:29, Ed Cable (<ed...@mifos.org>)
>>>>> escribió:
>>>>>
>>>>>> 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 <fr...@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, <bg...@mifos.org>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Hi Luis and Francis,
>>>>>>>>>
>>>>>>>>> @Luis Alberto Alegría de los Santos <lu...@innovar.app>  Thank
>>>>>>>>> you for your great effort in fixing the issue and narrowing down the other
>>>>>>>>> related issues.
>>>>>>>>>
>>>>>>>>> @Francis Guchie <fr...@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 <
>>>>>>>>> francisguchie@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 <
>>>>>>>>>> francisguchie@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 <lu...@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 <
>>>>>>>>>>>> francisguchie@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 <lu...@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 (<
>>>>>>>>>>>>>> francisguchie@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 <
>>>>>>>>>>>>>>> bgowda@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 <ed...@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 <
>>>>>>>>>>>>>>>>> ntiritumusa@gmail.com> wrote:
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> Thanks so much, Congratulations Luis
>>>>>>>>>>>>>>>>>> Moses
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> On Mon, Jul 20, 2020 at 4:05 PM Bharath Gowda <
>>>>>>>>>>>>>>>>>> bgowda@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 @francisguchie@gmail.com
>>>>>>>>>>>>>>>>>>> <fr...@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 <lu...@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 (<
>>>>>>>>>>>>>>>>>>>> francisguchie@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 <lu...@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 (<
>>>>>>>>>>>>>>>>>>>>>> yuwa909@gmail.com>) escribió:
>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>> This is great,  looking foward to this update.
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>> On Mon, Jul 13, 2020, 13:16 Bharath Gowda <
>>>>>>>>>>>>>>>>>>>>>>> bgowda@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
>>>>>>>>>>>>>>>>>>>>>>>> <lu...@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
>>>>>>>>>>>>>>>>>>>>>>>> <lu...@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 <
>>>>>>>>>>>>>>>>>>>>>>>> yuwa909@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 <
>>>>>>>>>>>>>>>>>>>>>>>>> airsaylongcon@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>> bgowda@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>> edwingudfriend@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Sure, here it is.
>>>>>>>>>>>>>>>>>>>>>>>>>>> 18.03.01
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> On Tue, 7 Jul 2020 16:35 Bharath Gowda, <
>>>>>>>>>>>>>>>>>>>>>>>>>>> bgowda@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 <
>>>>>>>>>>>>>>>>>>>>>>>>>>>> edwingudfriend@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Hello! I have created a table but the field is
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> not active, where I wrong?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>>>>>>> Mifos-users@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-users@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-developer@lists.sourceforge.net
>>>>>>>>>>>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>>>>>>>>> Mifos-users@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-users@lists.sourceforge.net
>>>>>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>> *Ed Cable*
>>>>>>>>>>>>>>>>> President/CEO, Mifos Initiative
>>>>>>>>>>>>>>>>> edcable@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-users@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-developer@lists.sourceforge.net
>>>>>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>>>>>
>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>> Mifos-users mailing list
>>>>>>>>>>>> Mifos-users@lists.sourceforge.net
>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>>>>>>>>
>>>>>>>>>>> Mifos-developer mailing list
>>>>>>>>>> mifos-developer@lists.sourceforge.net
>>>>>>>>>> Unsubscribe or change settings at:
>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>
>>>>> --
>>>>> 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.*
>>>>>
>>>>
>>>>
>>>> --
>>>> *Ed Cable*
>>>> President/CEO, Mifos Initiative
>>>> edcable@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>
>>>>
>>>>
>
> --
> *Ed Cable*
> President/CEO, Mifos Initiative
> edcable@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>
>
>

-- 
*Ed Cable*
President/CEO, Mifos Initiative
edcable@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>