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

48 views
Skip to first unread message

Bharath Gowda

unread,
Jul 7, 2020, 9:38:32 AM7/7/20
to Edwin Nchia, Developer, Dev, mifos-users
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


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

unread,
Jul 7, 2020, 9:51:54 AM7/7/20
to Edwin Nchia, Developer, Dev, mifos-users
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: 

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


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

Airsay Longcon

unread,
Jul 8, 2020, 2:04:41 AM7/8/20
to d...@fineract.apache.org, Edwin Nchia, Developer, mifos-users
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

unread,
Jul 10, 2020, 9:37:33 AM7/10/20
to A good place to start for users or folks new to Mifos., Developer, Edwin Nchia, Dev
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

unread,
Jul 13, 2020, 6:16:38 AM7/13/20
to A good place to start for users or folks new to Mifos., Luis Alberto Alegría de los Santos, Dev, Edwin Nchia, Developer
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


@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

yurie walter

unread,
Jul 13, 2020, 6:43:21 AM7/13/20
to A good place to start for users or folks new to Mifos., Developer, Dev, Edwin Nchia
This is great,  looking foward to this update.

Luis Alberto Alegría de los Santos

unread,
Jul 16, 2020, 12:18:58 AM7/16/20
to yurie walter, Developer, Edwin Nchia, Dev, A good place to start for users or folks new to Mifos.
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

unread,
Jul 16, 2020, 4:28:45 PM7/16/20
to luis.a...@innovar.app, Dev, Edwin Nchia, Developer, A good place to start for users or folks new to Mifos.
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
twitter: @FrancisGuchie








Luis Alberto Alegría de los Santos

unread,
Jul 16, 2020, 6:02:44 PM7/16/20
to Francis Guchie, Dev, Edwin Nchia, Developer, A good place to start for users or folks new to Mifos.
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

unread,
Jul 20, 2020, 9:04:57 AM7/20/20
to Mifos software development, Edwin Nchia, Dev, A good place to start for users or folks new to Mifos.
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

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

Ed Cable

unread,
Jul 20, 2020, 1:01:38 PM7/20/20
to Dev, Edwin Nchia, Mifos software development, A good place to start for users or folks new to Mifos.
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

unread,
Jul 20, 2020, 1:48:31 PM7/20/20
to A good place to start for users or folks new to Mifos., Dev, Edwin Nchia, Mifos software development
Thanks so much, Congratulations Luis
Moses
Moses Gitonga Ntiritu
Director
Digital Oasis Limited
Po. Box 5221-00200
Nairobi.
Tel: 0700 773 038
--------------------------------------------------------------------------------
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

unread,
Aug 6, 2020, 6:55:25 PM8/6/20
to A good place to start for users or folks new to Mifos., Mifos software development, Edwin Nchia, Dev
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

unread,
Aug 7, 2020, 6:08:50 AM8/7/20
to A good place to start for users or folks new to Mifos., Ed Cable, Francis Guchie, Dev, Edwin Nchia, Mifos software development
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

Francis Guchie

unread,
Aug 7, 2020, 6:12:51 AM8/7/20
to Bharath Gowda, Dev, Edwin Nchia, Mifos software development, A good place to start for users or folks new to Mifos.

Luis Alberto Alegría de los Santos

unread,
Aug 8, 2020, 9:23:44 PM8/8/20
to Dev, Mifos software development, Edwin Nchia, A good place to start for users or folks new to Mifos.
Hi all

Sorry for the delay reply, I've finally had a chance to work on integrating pentaho on the develop branch.


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

unread,
Aug 9, 2020, 5:17:21 AM8/9/20
to Mifos software development, Edwin Nchia, Dev, A good place to start for users or folks new to Mifos.
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

unread,
Aug 9, 2020, 5:36:34 AM8/9/20
to Mifos software development, Edwin Nchia, Dev, A good place to start for users or folks new to Mifos.
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

unread,
Aug 9, 2020, 6:51:44 PM8/9/20
to Mifos software development, Edwin Nchia, Dev, A good place to start for users or folks new to Mifos.
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

unread,
Aug 9, 2020, 8:04:44 PM8/9/20
to Dev, Edwin Nchia, Mifos software development, A good place to start for users or folks new to Mifos.
Hi Francis 
Maybe you need upgrade gradle versión, Im think 5 or later.

Please could you try it? 

Best regards

Francis Guchie

unread,
Aug 10, 2020, 6:18:01 AM8/10/20
to A good place to start for users or folks new to Mifos., Mifos software development, Edwin Nchia, Dev
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

unread,
Aug 10, 2020, 7:28:27 AM8/10/20
to A good place to start for users or folks new to Mifos., Mifos software development, Edwin Nchia, Dev
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

unread,
Aug 10, 2020, 7:29:28 AM8/10/20
to Ed Cable, Mifos software development, Edwin Nchia, Dev, A good place to start for users or folks new to Mifos.
Welcome Ed

Bharath Gowda

unread,
Aug 10, 2020, 11:09:30 AM8/10/20
to Mifos software development, Luis Alberto Alegría de los Santos, Francis Guchie, Edwin Nchia, Dev, A good place to start for users or folks new to Mifos.
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

Francis Guchie

unread,
Aug 10, 2020, 12:05:23 PM8/10/20
to Petri Tuomola, Mifos software development, Dev, Edwin Nchia, A good place to start for users or folks new to Mifos.
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
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

Reply all
Reply to author
Forward
0 new messages