[Mifos-users] Mifos 21.07.01 Pentaho Reports

Juan Manuel Hernández

unread,

Aug 9, 2021, 8:32:57 PM8/9/21

to A good place to start for users or folks new to Mifos., Mifos software development

Hello Devs,

So what is the solution?:

https://groups.google.com/g/mifosdeveloper/c/6nXveK6HOEw

Best Regards,

Juan Manuel

solomon anaman

unread,

Aug 9, 2021, 11:42:13 PM8/9/21

to A good place to start for users or folks new to Mifos.

Hello Francis,

I have followed keenly the procedures outlined in the links in your mail to get my pentaho reports running but all to no avail. I have attached my logs file for you to study and tell me the problem with my setup. Your assistance will be very much appreciated. I am running mifosplatform-21.07.01.RELEASE on windows 10 local machine.

Thank you.

Yours sincerely

Kwabena Anaman

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

catalina.2021-08-10.log

Bharath Gowda

unread,

Aug 10, 2021, 9:25:57 AM8/10/21

to A good place to start for users or folks new to Mifos., Mifos software development

Hi Juan, Kwabena, and the Community,

I Will try to address few FAQs here

Follow the below document step by step always to install the latest Migos release on the windows machine

https://mifosforge.jira.com/wiki/spaces/docs/pages/2809626625/Mifos+21.07.01+Installation+on+Tomcat-Windows

FAQ 1:- If you are able to log-in to the application successfully, but Pentaho reports are not working

1. Check if the Pentaho jars are properly copied to the 'tomcat\webapps\fineract-provider\WEB-INF\lib' folder

2. Run Pentaho reports on new UI (web-app). To Access new UI:- https://localhost:8443/web-app ( or any port number which you are using)

- if you have successfully configured the Pentaho Plugin, then you should be able to view the Pentaho reports on web-app

NOTE: On Windows machine, Pentaho reports are working only on web-app UI, community-app has some issues which need to be fixed.

Any Interested volunteers can help on this issue (ticket link is here with more details)

FAQ 2:- Pentaho reports are working fine, only a few are throwing the error "Failed to load content using value C:\Users\hp1\Desktop\MIfosX_unofficial_logo.png"

This is error is because the logos were not removed from some reports when we upgraded the Pentaho version to 7.00.6.25

if you come across such reports, you could simply remove the logo and send PR and contribute to the community or you can work around this by placing a logo inside of pentahoReports folder and name it 'MIfosX_unofficial_logo.png' to resolve the error on your installation.

FAQ 3:- Not able to login / Connectivity Issue on Community-app

1. Check if all the prerequisite Softwares installed are of the right version

2. check the tomcat startup log which will always point to the root cause of the issue

3. If you are not able to analyze the log file, please share the log file along with all other details with the community for help.

FAQ 4:- Not able to log-in through web-app UI

1. Check if you are able to login successfully with community-app UI

- If you are able to login through community-app, then check the server dropdown selection on the web-app UI and make sure it is correct.

- Clear all browser cache or use a private browser.

- If you are not able to login through community-app then follow FAQ 3

I have also added these FAQs into the installation document, please refer to the document for further details.

Regards,

Bharath

Lead Implementation Analyst | Mifos Initiative

Skype: live:cbharath4| Mobile: +91.7019635592

http://mifos.org

solomon anaman

unread,

Aug 13, 2021, 12:01:48 PM8/13/21

to A good place to start for users or folks new to Mifos.

Hello Bharat Gowda,

I have placed a logo file named Mifosx_unofficial_logo.png in the pentaho report folder but I am still unable to view pentaho reports in web-app ui. Please review my logs filein my previous mail and tell me what is wrong with my setup.

Thank you

Yours sincerely

Kwabena Anaman

Juan Manuel Hernández

unread,

Aug 13, 2021, 12:01:48 PM8/13/21

to Bharath Gowda, Mifos software development, A good place to start for users or folks new to Mifos.

Hi,

You know what. They didn't mention pentaho jars in the documentation but I still have copied.

When they are copied, the server loses its SQL connection. It's too strange.

Which is why I think the Mifos 21 has something different which isn't letting pentaho work.

El mar, 10 ago 2021 a las 19:41, Juan Manuel Hernández (<fdomi...@gmail.com>) escribió:

Hi Bharath,

and for Linux?

Best regards

Juan Manuel Hernández

unread,

Aug 13, 2021, 12:02:04 PM8/13/21

to Ed Cable, Francis Guchie, Mifos Forum, Mifos Forum, Mifos software development, A good place to start for users or folks new to Mifos.

Dear all,

someone who has Pentaho fully working?

apparently Pentaho and Mifos are enemies

El El mar, 10.08.2021 a las 23:34, Juan Manuel Hernández <fdomi...@gmail.com> escribió:

Dear Francis,

I ran all this you mention, but am I getting this when generating pentaho report:

Possibly unhandled rejection: {"data":{},"status":403,"config":{"method":"GET","transformRequest":[null],"transformResponse":[null],"jsonpCallbackParam":"callback","responseType":"arraybuffer","url":"
https://18.142.146.74/fineract-provider/api/v1/runreports/Client%20Savings%20Summary?output-type=HTML&tenantIdentifier=default&locale=en&dateFormat=dd
MMMM yyyy&R_fromDate=2021-08-02&R_toDate=2021-08-10&R_selectOffice=1&R_selectProduct=-1","headers":{"Accept":"application/json, text/plain, */*","Fineract-Platform-TenantId":"default","Authorization":"Basic bWlmb3M6cGFzc3dvcmQ="}},"statusText":"","xhrStatus":"complete"}""
libs are copied from pentaho too

El El mar, 10.08.2021 a las 22:09, Francis Guchie <franci...@gmail.com> escribió:
Dear Juan,

Where arent the jars mentioned ?

Did you read the part below in this document ==> https://mifosforge.jira.com/wiki/spaces/docs/pages/2824142857/Mifos+21.07.01+Installation+on+Tomcat-Ubuntu+18.04
Key issue is u have to successfully do an initial launch - then stop tomcat then start it back
Stop tomcat - after the initial launch, you need to stop MifosX so that you can upload the pentaho jars and then start MifosX again:
# sudo /etc/init.d/tomcat9 stop
# cd /usr/src/fineractplatform-21.07.01.RELEASE
# sudo cp -r pentaholibs/*.* /usr/share/tomcat9/webapps/fineract-provider/WEB-INF/lib
Start tomcat:
# sudo /etc/init.d/tomcat9 start

My Kind Regards

Francis Guchie Kirago
Skype: francisguchie
Telegram: 232 79 19 44 07
Whatsapp: 232 79 19 44 07
LINKEDIN: https://www.linkedin.com/in/francis-guchie-kirago-a4379617/
twitter: @FrancisGuchie

Francis Guchie

unread,

Aug 13, 2021, 12:02:14 PM8/13/21

to Juan Manuel Hernández, Mifos Forum, Mifos software development, A good place to start for users or folks new to Mifos., Mifos Forum

Me
I have it working on WIndows and Ubuntu 18.04 Lts

Francis Guchie

unread,

Aug 13, 2021, 12:06:01 PM8/13/21

to Juan Manuel Hernández, Mifos software development, A good place to start for users or folks new to Mifos.

Dear Juan,

Where arent the jars mentioned ?

Did you read the part below in this document ==> https://mifosforge.jira.com/wiki/spaces/docs/pages/2824142857/Mifos+21.07.01+Installation+on+Tomcat-Ubuntu+18.04

Key issue is u have to successfully do an initial launch - then stop tomcat then start it back

Stop tomcat - after the initial launch, you need to stop MifosX so that you can upload the pentaho jars and then start MifosX again:

# sudo /etc/init.d/tomcat9 stop
# cd /usr/src/fineractplatform-21.07.01.RELEASE
# sudo cp -r pentaholibs/*.* /usr/share/tomcat9/webapps/fineract-provider/WEB-INF/lib

Start tomcat:

# sudo /etc/init.d/tomcat9 start

My Kind Regards

Francis Guchie Kirago

Skype: francisguchie

Telegram: 232 79 19 44 07

Whatsapp: 232 79 19 44 07

LINKEDIN: https://www.linkedin.com/in/francis-guchie-kirago-a4379617/

twitter: @FrancisGuchie

Juan Manuel Hernández

unread,

Aug 13, 2021, 12:06:17 PM8/13/21

to Francis Guchie, Mifos Forum, Mifos software development, A good place to start for users or folks new to Mifos., Mifos Forum

Dear Francis,

How is it possible that version 18 (mifos 18 has many errors) works with Pentaho and the most recent version (21) doesn't?

is there a possibility to find the reason why pentaho does not work in version 21.07.01?

Best regards,

Juan

Francis Guchie

unread,

Aug 13, 2021, 12:07:34 PM8/13/21

to A good place to start for users or folks new to Mifos., Mifos software development

Dear Bharath,

I have opened a new issue for this https://github.com/openMF/fineract-pentaho/issues/49. I will look into it soon and send a PR

My Kind Regards

Francis Guchie Kirago

Skype: francisguchie

Telegram: 232 79 19 44 07

Whatsapp: 232 79 19 44 07

LINKEDIN: https://www.linkedin.com/in/francis-guchie-kirago-a4379617/

twitter: @FrancisGuchie

Juan Manuel Hernández

unread,

Aug 13, 2021, 12:07:50 PM8/13/21

to Francis Guchie, Ed Cable, Mifos Forum, Mifos Forum, Mifos software development, A good place to start for users or folks new to Mifos.

Dear Francis,

I ran all this you mention, but am I getting this when generating pentaho report:

Possibly unhandled rejection: {"data":{},"status":403,"config":{"method":"GET","transformRequest":[null],"transformResponse":[null],"jsonpCallbackParam":"callback","responseType":"arraybuffer","url":"

https://18.142.146.74/fineract-provider/api/v1/runreports/Client%20Savings%20Summary?output-type=HTML&tenantIdentifier=default&locale=en&dateFormat=dd

MMMM yyyy&R_fromDate=2021-08-02&R_toDate=2021-08-10&R_selectOffice=1&R_selectProduct=-1","headers":{"Accept":"application/json, text/plain, */*","Fineract-Platform-TenantId":"default","Authorization":"Basic bWlmb3M6cGFzc3dvcmQ="}},"statusText":"","xhrStatus":"complete"}""
libs are copied from pentaho too

El El mar, 10.08.2021 a las 22:09, Francis Guchie <franci...@gmail.com> escribió:

image.png

Reply all

Reply to author

Forward