Re: [Mifos-users] Tables Created but field is not active

[Bharath Gowda]

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  

On Thu, Jul 2, 2020 at 7:06 PM Edwin Nchia <edwingu...@gmail.com> wrote:

Hello! I have created a table but the field is not active, where I wrong?

[Bharath Gowda]

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  

On Tue, Jul 7, 2020 at 7:06 PM Edwin Nchia <edwingu...@gmail.com> wrote:

Sure, here it is.
18.03.01

[Airsay Longcon]

Hello Bharath

Please are the source code from which the war file of v19.12 available?

Sent from my iPhone

On 7 Jul 2020, at 14:50, Bharath Gowda <bgo...@mifos.org> wrote:



[yurie walter]

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 

_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users

[Bharath Gowda]

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 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 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  

[yurie walter]

This is great,  looking foward to this update.

[Luis Alberto Alegría de los Santos]

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

--

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.

[Francis Guchie]

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

[Luis Alberto Alegría de los Santos]

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

[Bharath Gowda]

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

And updated war file here

Thanks @franci...@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  

Mifos-developer mailing list
mifos-d...@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

[Ed Cable]

Thanks Luis, Bharat, and Francis. A great team effort!

Ed

--

Ed Cable

President/CEO, Mifos Initiative

edc...@mifos.org | Skype: edcable | Mobile: +1.484.477.8649

Collectively Creating a World of 3 Billion Maries | http://mifos.org  

[Moses Gitonga Ntiritu]

Thanks so much, Congratulations Luis

Moses

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

[Ed Cable]

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

[Bharath Gowda]

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  

[Francis Guchie]

Dear Bharath,

My branch is 

https://github.com/francisguchie/fineract/tree/supportPentahoReports  

[Luis Alberto Alegría de los Santos]

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: fails
• Another without querys: it works  

• 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, and I replaced "(" ")" characters on them.
• These files goes on ~/.mifosx/ folder

Thank you a lot

[Francis Guchie]

Dear Luis,

This is a great help, i have an amount of experience on Pentaho Reports. (3.9.1-GA). I will look into this starting 17hrs GMT. 

Sql-injection, report names etc these we can look into them all

[Francis Guchie]

Dear All,

Please note that for the sql injection error, not only  "(" and a few others mentioned

All key characters used in mySQL (e.g * , %, -, + )

All keywords used in mySQL (e.g. and)

If these are used in the report names, you will see the sql injection error while creating and adding any report into MifosX latest build 

[Francis Guchie]

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

[Luis Alberto Alegría de los Santos]

Hi Francis 

Maybe you need upgrade gradle versión, Im think 5 or later.

Please could you try it? 

Best regards

[Francis Guchie]

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

[Francis Guchie]

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 .........

[Francis Guchie]

Welcome Ed

[Bharath Gowda]

Hi Luis and Francis,

@Luis Alberto Alegría de los Santos  Thank you for your great effort in fixing the issue and narrowing down the other related issues.

@Francis Guchie  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  

[Francis Guchie]

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