[Mifos-developer] Mifos 21.07.01 Pentaho Reports

[Laban Kibowen]

Hello Devs

Am kindly requesting anyone with Mifos 21.07.01 running that has pentaho reports working correctly to share the experience.

LABAN KIBOWEN | DevOps Engineer

Intrasoft Technologies Limited

3rd Floor, Ruman Plaza, St. Bernard Street.

P. O. Box 82298 - 80100, Mombasa.

Tel: +254729743332

Skype: live:bowenjnr37 

Web: www.intrasofttechnologies.com

[solomon anaman]

Hello Dev

I have successfully installed mifos 21.07.01 on my laptop running Windows 10. Everything works fine except that when I run pentaho reports I get a blank page. Please any help to get the Penta ho report running would be very much appreciated

Thank you.

Yours sincerely

Kwabena Anaman

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

[Francis Guchie]

Dear Solomon,

Did you follow the steps here https://mifosforge.jira.com/wiki/spaces/docs/pages/2809626625/Mifos+21.07.01+Installation+on+Tomcat-Windows 

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

[solomon anaman]

Hello Francis

I followed all the procedures outlined in the link provided in your mail. All the table reports are running very well but only pentaho reports appear blank when I run it. Please is there anyway to go about it?

Sincerely yours

Solomon Anaman

[Francis Guchie]

Kindly share the document you are referring to. Because everything is in there

[Bharath Gowda]

Hi Solomon,

Also, could you share the error message/API response message when you are trying to run the Pentaho report?

It will help us to understand and solve the problem.

Regards,

Bharath

Lead Implementation Analyst | Mifos Initiative

Skype: live:cbharath4| Mobile: +91.7019635592

http://mifos.org  

[solomon anaman]

Hello Francis,

 Please this is the link to the document I referred to during the installation.

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

Awaiting your response

Thank you. 

Yours sincerely

Kwabena Anaman

[solomon anaman]

Hello  Bharath

This is the error message i get when i run the report. 

Awaiting your swift response

Thank you

Yours sincerely

Kwabena Anaman

[zay...@intrasofttechnologies.com]

Hi,

 

We are also facing same challenges in our staging server, I investigated the logs and saw below lines that I suspect might be the root cause of the blank pages in pentaho reports:

 

2021-08-04 05:56:55.465  WARN 185043 --- [nio-443-exec-20] o.p.r.e.c.core.filter.types.ContentType  : Failed to load content using value C:\Users\hp1\Desktop\MIfosX_unofficial_logo.png

 

org.pentaho.reporting.libraries.resourceloader.ResourceKeyCreationException: Unable to create key: No loader was able to handle the given key data: C:\Users\hp1\Desktop\MIfosX_unofficial_logo.png

 

Could someone verify if this is the issue? It looks like its trying to find where the MIfosX_unofficial_logo.png is but cant load since the path isn’t correct.

 

Our staging server runs Ubuntu 20.04.02 and the path in the code looks like a Windows path.

 

If yes this is the cause, how then can we resolve?

 

Regards;

 

*******

Zayyad A. Said | Chairman & C.E.O

Cell No.: +254 716 615274 | Skype: zsaid2011

Email: zay...@intrasofttechnologies.com 

Schedule Meetings: https://calendly.com/zayyadsaid

[Tom Ssemwogerere]

I downloaded the mifosplatform-21.07.01.RELEASE but I do not see the Database folder and therefore cannot navigate to  mifospltaform-tenants-first-time-install.sql 

Tom Ssemwogerere

[Laban Kibowen]

Hello Tom

Database file has not been included but the one available inside fineract 1.x releases can work just fine

LABAN KIBOWEN | DevOps Engineer

Intrasoft Technologies Limited

3rd Floor, Ruman Plaza, St. Bernard Street.

P. O. Box 82298 - 80100, Mombasa.

Tel: +254729743332

Skype: live:bowenjnr37 

Web: www.intrasofttechnologies.com

On Wed, Aug 4, 2021 at 2:29 PM Tom Ssemwogerere <ssem...@gmail.com> wrote:

I downloaded the mifosplatform-21.07.01.RELEASE but I do not see the Database folder and therefore cannot navigate to  mifospltaform-tenants-first-time-install.sql 

Tom Ssemwogerere

[Francis Guchie]

Thanks Zayad, 

I saw this and I forgot to remove the logos in some of the reports, when I was updating these templates from version 3.9 to 7.00.6.25 of Pentaho RD. But I'm  sure it is not the reason the the reports are failing 

If someone can look help me name all the reports designed with logos and provide a list of them, i can gladly remove them and do  PR for it 

In the meantime, you can work around this by placing a logo inside of pentahoReports folder and name it   MIfosX_unofficial_logo.png  the error yu=u have presented will go away 

[Bharath Gowda]

Hi Tom,

Thank you for posting your query here

The latest release does not need any manual sourcing of the data directly into the DB, hence the new release does not have the database folder.

We just have to run the following command and the server will take care of the remaining setup

create database `fineract_tenants`; create database `fineract_default`; 

Check the installation document below for detailed information

https://mifosforge.jira.com/wiki/spaces/docs/pages/2807201793/Mifos+X+21.07.01+Installation+Guide+with+Pentaho+plugin

Regards,

Bharath

Lead Implementation Analyst | Mifos Initiative

Skype: live:cbharath4| Mobile: +91.7019635592

http://mifos.org  

On Wed, Aug 4, 2021 at 4:59 PM Tom Ssemwogerere <ssem...@gmail.com> wrote:

I downloaded the mifosplatform-21.07.01.RELEASE but I do not see the Database folder and therefore cannot navigate to  mifospltaform-tenants-first-time-install.sql 

Tom Ssemwogerere

[Francis Guchie]

Thanks Bharath,

Most people have missed this part and end up running into challenges at boot up 

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