Fineract Pentaho Plugin error log for Mifos 24 release
Good day Devs I have added the fineract pentaho plugin to mifos 24 release running on debian. When I try to run any pentaho report I get this error that I have attached. *Caused by: java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:address=(host=fineractmysql)(port=3306)(type=primary). fineractmysql * * at org.mariadb.jdbc.client.impl.ConnectionHelper.connectSocket(ConnectionHelper.java:136) * * at org.mariadb.jdbc.client.impl.StandardClient.(StandardClient.java:101) * * at org.mariadb.jdbc.Driver.connect(Driver.java:69) * * at org.mariadb.jdbc.Driver.connect(Driver.java:95) * * at org.mariadb.jdbc.Driver.connect(Driver.java:26) * * at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.DriverConnectionProvider.createConnection(DriverConnectionProvider.java:121) * * at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getConnection(SimpleSQLReportDataFactory.java:130) * * at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:174) * * ... 204 common frames omitted * *Caused by: java.net.UnknownHostException: fineractmysql * * at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:572) * * at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327) * * at java.base/java.net.Socket.connect(Socket.java:639) * * at org.mariadb.jdbc.client.impl.ConnectionHelper.connectSocket(ConnectionHelper.java:130) * * ... 211 common frames omitted * Caused by: java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:address=(host=fineractmysql)(port=3306)(type=primary). fineractmysql at org.mariadb.jdbc.client.impl.ConnectionHelper.connectSocket(ConnectionHelper.java:136) at org.mariadb.jdbc.client.impl.StandardClient.(StandardClient.java:101) at org.mariadb.jdbc.Driver.connect(Driver.java:69) at org.mariadb.jdbc.Driver.connect(Driver.java:95) at org.mariadb.jdbc.Driver.connect(Driver.java:26) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.DriverConnectionProvider.createConnection(DriverConnectionProvider.java:121) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getConnection(SimpleSQLReportDataFactory.java:130) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:174) ... 204 common frames omitted Caused by: java.net.UnknownHostException: fineractmysql at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:572) at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327) at java.base/java.net.Socket.connect(Socket.java:639) at org.mariadb.jdbc.client.impl.ConnectionHelper.connectSocket(ConnectionHelper.java:130) ... 211 common frames omitted 06:57:29.277 [http-nio-8443-exec-4] ERROR o.a.f.i.r.s.PentahoReportingProcessServiceImpl - Pentaho failed org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to execute query. at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:189) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:142) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:172) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:154) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:408) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:151) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:154) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:67) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQueryData(DefaultFlowController.java:256) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performSubReportQuery(DefaultFlowController.java:316) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForSubreport(ProcessState.java:566) at org.pentaho.reporting.engine.classic.core.states.process.InlineSubreportProcessor.processInline(InlineSubreportProcessor.java:72) at org.pentaho.reporting.engine.classic.core.states.process.ReportFooterHandler.advance
Re: Fineract Pentaho Reports on Docker Setup for Mifos
Hello, Read the manuals depending on your setup/Mifos release: https://mifosforge.jira.com/wiki/spaces/docs/pages/3775594527/Mifos+Pentaho+Plugin+-+Installation+Instruction+on+Windows+11+Home+x86+64+-+MariaDB https://mifosforge.jira.com/wiki/spaces/docs/pages/3775365260/Mifos+Pentaho+Plugin+-+Installation+Instruction+on+Linux+Ubuntu+24.04+LTS+-+Docker+Compose+-+MariaDB El mié, 12 jun 2024 a las 6:37, Floyd Nickson () escribió: > > Hello Mifos Users and Developers, > I have managed to have Latest Mifos running thanks to the support by Jose > and Victor. I now want to use Pentaho Reports and I would like to know how > the pentaho reports can be deployed to a docker environment. > > Thank you. >
Fineract Pentaho Reports on Docker Setup for Mifos
Hello Mifos Users and Developers, I have managed to have Latest Mifos running thanks to the support by Jose and Victor. I now want to use Pentaho Reports and I would like to know how the pentaho reports can be deployed to a docker environment. Thank you.
Re: PENTAHO REPORTS - Postgres
Thank you, This works. On Tue, Apr 30, 2024 at 5:21 PM Honest Chirozva wrote: > Hi Peter, > I think the reports are failing because you are using a PostgreSQL > database and the reports you are using are for MariaDB. > The SQL queries for the reports are MariaDB/MySQL compatible and will fail > when using a PostgreSQL database. > >1. Try using a MariaDB database >2. Or if you insist on PostgreSQL, you may need to change the queries >of the individual reports to PostgreSQL compatible queries. > > > > Regards. > > Honest Chirozva > Technical Consultant > > TAAT Consulting > > > -- > *From:* PETER KIPROP > *Sent:* Tuesday, April 30, 2024 2:52:36 PM > *To:* dev@fineract.apache.org > *Subject:* PENTAHO REPORTS - Postgres > > Hello Dev, > I am trying to run pentaho reports with mifos, The deployment was > successful but i am facing a query error as attached below, > > The sample report i am running is as below > > > https://localhost:8443/Re-Bank/api/v1/runreports/Client%20Listing(Pentaho)?tenantIdentifier=default&locale=en&dateFormat=dd%20%20&R_selectOffice=1&output-type=PDF > > >
RE: PENTAHO REPORTS - Postgres
Hi Peter, I think the reports are failing because you are using a PostgreSQL database and the reports you are using are for MariaDB. The SQL queries for the reports are MariaDB/MySQL compatible and will fail when using a PostgreSQL database. 1. Try using a MariaDB database 2. Or if you insist on PostgreSQL, you may need to change the queries of the individual reports to PostgreSQL compatible queries. Regards. Honest Chirozva Technical Consultant TAAT Consulting From: PETER KIPROP Sent: Tuesday, April 30, 2024 2:52:36 PM To: dev@fineract.apache.org Subject: PENTAHO REPORTS - Postgres Hello Dev, I am trying to run pentaho reports with mifos, The deployment was successful but i am facing a query error as attached below, The sample report i am running is as below https://localhost:8443/Re-Bank/api/v1/runreports/Client%20Listing(Pentaho)?tenantIdentifier=default&locale=en&dateFormat=dd%20%20&R_selectOffice=1&output-type=PDF
Re: [Mifos-developer] Pentaho Report Service Missing
Sorry i mean "there is NO ReportProcessingService implementation for
Pentaho"
Regards,
Naphlin Peter Akena,
Kampala,
Uganda
tel:+256777110054
skype: *napho.peter*
On Mon, Apr 22, 2024 at 3:44 AM Naphlin Peter wrote:
> Hello Zayyad,
>
> I have looked through the repo, if you are deploying it as is without
> modification, then there is ReportProcessingService implementation for
> Pentaho. You need to write this implementation (you can copy from your old
> repo).
>
> Regards,
>
> Naphlin Peter Akena,
> Kampala,
> Uganda
>
> tel:+256777110054
> skype: *napho.peter*
>
>
> On Sun, Apr 21, 2024 at 10:12 PM José Alberto Hernández
> wrote:
>
>> Hello! That should be different reasons:
>>
>> The Pentaho report Engine implementation is not part of the war file,
>> The Pentaho report libraries are not available (missed dependencies) in
>> the war file then the Pentaho report Engine implementation is not available
>> Pentaho report libraries usually are being changed
>>
>> You should review the log files for compilation and the
>> fineract-provider.log file in the Tomcat service
>>
>> Thanks and best regards
>> Alberto
>>
>> On Sun, Apr 21, 2024 at 9:23 AM Laban Kibowen
>> wrote:
>>
>>> That could be some files missing.
>>>
>>> On Sun, Apr 21, 2024, 16:59 wrote:
>>>
>>>> Hi Devs,
>>>>
>>>>
>>>>
>>>> One of our production servers running FINERACT-1.5 was running some
>>>> Pentaho reports e.g. Trial Balance and other custom made reports.
>>>>
>>>>
>>>>
>>>> For the last 1 week or so, all Pentaho reports are not opening (getting
>>>> blank screen) and developer tools gives the following error:
>>>>
>>>>
>>>>
>>>> {
>>>>
>>>> "developerMessage": "There is no ReportingProcessService
>>>> registered in the ReportingProcessServiceProvider for this report type:
>>>> Pentaho",
>>>>
>>>> "defaultUserMessage": "There is no ReportingProcessService
>>>> registered in the ReportingProcessServiceProvider for this report type:
>>>> Pentaho",
>>>>
>>>> "userMessageGlobalisationCode":
>>>> "err.msg.report.service.implementation.missing",
>>>>
>>>> "parameterName": "id",
>>>>
>>>> "value": null,
>>>>
>>>> "args": [
>>>>
>>>> {
>>>>
>>>> "value": "Pentaho"
>>>>
>>>> }
>>>>
>>>> ]
>>>>
>>>> }
>>>>
>>>>
>>>>
>>>> We started having this issue after deploying new war file from our
>>>> private repo on github forked from
>>>> https://github.com/apache/fineract/tree/1.5.0 , our repo has some few
>>>> changes we have done and we have been maintaining it for this production
>>>> server. The last war file we had before this issue had also been compiled
>>>> from the same repo and the Pentaho reports needed were running.
>>>>
>>>>
>>>>
>>>> Is there anyone who can be able to advise where the issue could be
>>>> considering the changes we did on the repo had nothing to do with pentaho?
>>>>
>>>>
>>>>
>>>> Thanks & Regards;
>>>>
>>>>
>>>>
>>>> *
>>>>
>>>> *Zayyad A. Said | Chief Executive Officer*
>>>>
>>>> Cell No.: +254 716 615274 | Skype: *zsaid2011*
>>>>
>>>> Email: zay...@intrasofttechnologies.com
>>>>
>>>> Schedule Meetings: https://calendly.com/zayyadsaid
>>>>
>>>>
>>>> Mifos-developer mailing list
>>>> mifos-develo...@lists.sourceforge.net
>>>> Unsubscribe or change settings at:
>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>
>>> Mifos-developer mailing list
>>> mifos-develo...@lists.sourceforge.net
>>> Unsubscribe or change settings at:
>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>
>>
Re: [Mifos-developer] Pentaho Report Service Missing
Hello Zayyad,
I have looked through the repo, if you are deploying it as is without
modification, then there is ReportProcessingService implementation for
Pentaho. You need to write this implementation (you can copy from your old
repo).
Regards,
Naphlin Peter Akena,
Kampala,
Uganda
tel:+256777110054
skype: *napho.peter*
On Sun, Apr 21, 2024 at 10:12 PM José Alberto Hernández
wrote:
> Hello! That should be different reasons:
>
> The Pentaho report Engine implementation is not part of the war file,
> The Pentaho report libraries are not available (missed dependencies) in
> the war file then the Pentaho report Engine implementation is not available
> Pentaho report libraries usually are being changed
>
> You should review the log files for compilation and the
> fineract-provider.log file in the Tomcat service
>
> Thanks and best regards
> Alberto
>
> On Sun, Apr 21, 2024 at 9:23 AM Laban Kibowen
> wrote:
>
>> That could be some files missing.
>>
>> On Sun, Apr 21, 2024, 16:59 wrote:
>>
>>> Hi Devs,
>>>
>>>
>>>
>>> One of our production servers running FINERACT-1.5 was running some
>>> Pentaho reports e.g. Trial Balance and other custom made reports.
>>>
>>>
>>>
>>> For the last 1 week or so, all Pentaho reports are not opening (getting
>>> blank screen) and developer tools gives the following error:
>>>
>>>
>>>
>>> {
>>>
>>> "developerMessage": "There is no ReportingProcessService
>>> registered in the ReportingProcessServiceProvider for this report type:
>>> Pentaho",
>>>
>>> "defaultUserMessage": "There is no ReportingProcessService
>>> registered in the ReportingProcessServiceProvider for this report type:
>>> Pentaho",
>>>
>>> "userMessageGlobalisationCode":
>>> "err.msg.report.service.implementation.missing",
>>>
>>> "parameterName": "id",
>>>
>>> "value": null,
>>>
>>> "args": [
>>>
>>> {
>>>
>>> "value": "Pentaho"
>>>
>>> }
>>>
>>> ]
>>>
>>> }
>>>
>>>
>>>
>>> We started having this issue after deploying new war file from our
>>> private repo on github forked from
>>> https://github.com/apache/fineract/tree/1.5.0 , our repo has some few
>>> changes we have done and we have been maintaining it for this production
>>> server. The last war file we had before this issue had also been compiled
>>> from the same repo and the Pentaho reports needed were running.
>>>
>>>
>>>
>>> Is there anyone who can be able to advise where the issue could be
>>> considering the changes we did on the repo had nothing to do with pentaho?
>>>
>>>
>>>
>>> Thanks & Regards;
>>>
>>>
>>>
>>> *
>>>
>>> *Zayyad A. Said | Chief Executive Officer*
>>>
>>> Cell No.: +254 716 615274 | Skype: *zsaid2011*
>>>
>>> Email: zay...@intrasofttechnologies.com
>>>
>>> Schedule Meetings: https://calendly.com/zayyadsaid
>>>
>>>
>>> Mifos-developer mailing list
>>> mifos-develo...@lists.sourceforge.net
>>> Unsubscribe or change settings at:
>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>
>> Mifos-developer mailing list
>> mifos-develo...@lists.sourceforge.net
>> Unsubscribe or change settings at:
>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>
>
Re: [Mifos-developer] Pentaho Report Service Missing
Hello! That should be different reasons:
The Pentaho report Engine implementation is not part of the war file,
The Pentaho report libraries are not available (missed dependencies) in the
war file then the Pentaho report Engine implementation is not available
Pentaho report libraries usually are being changed
You should review the log files for compilation and the
fineract-provider.log file in the Tomcat service
Thanks and best regards
Alberto
On Sun, Apr 21, 2024 at 9:23 AM Laban Kibowen
wrote:
> That could be some files missing.
>
> On Sun, Apr 21, 2024, 16:59 wrote:
>
>> Hi Devs,
>>
>>
>>
>> One of our production servers running FINERACT-1.5 was running some
>> Pentaho reports e.g. Trial Balance and other custom made reports.
>>
>>
>>
>> For the last 1 week or so, all Pentaho reports are not opening (getting
>> blank screen) and developer tools gives the following error:
>>
>>
>>
>> {
>>
>> "developerMessage": "There is no ReportingProcessService
>> registered in the ReportingProcessServiceProvider for this report type:
>> Pentaho",
>>
>> "defaultUserMessage": "There is no ReportingProcessService
>> registered in the ReportingProcessServiceProvider for this report type:
>> Pentaho",
>>
>> "userMessageGlobalisationCode":
>> "err.msg.report.service.implementation.missing",
>>
>> "parameterName": "id",
>>
>> "value": null,
>>
>> "args": [
>>
>> {
>>
>> "value": "Pentaho"
>>
>> }
>>
>> ]
>>
>> }
>>
>>
>>
>> We started having this issue after deploying new war file from our
>> private repo on github forked from
>> https://github.com/apache/fineract/tree/1.5.0 , our repo has some few
>> changes we have done and we have been maintaining it for this production
>> server. The last war file we had before this issue had also been compiled
>> from the same repo and the Pentaho reports needed were running.
>>
>>
>>
>> Is there anyone who can be able to advise where the issue could be
>> considering the changes we did on the repo had nothing to do with pentaho?
>>
>>
>>
>> Thanks & Regards;
>>
>>
>>
>> *
>>
>> *Zayyad A. Said | Chief Executive Officer*
>>
>> Cell No.: +254 716 615274 | Skype: *zsaid2011*
>>
>> Email: zay...@intrasofttechnologies.com
>>
>> Schedule Meetings: https://calendly.com/zayyadsaid
>>
>>
>> Mifos-developer mailing list
>> mifos-develo...@lists.sourceforge.net
>> Unsubscribe or change settings at:
>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>
> Mifos-developer mailing list
> mifos-develo...@lists.sourceforge.net
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer
RE: [Mifos-developer] Fineract-pentaho build failure
Hi Floyd, I’m quite new to the Mifos community so I wouldn’t know what you mean by “similar fashion as it is done on 18 and 21”. However, due to licensing issues the apache fineract cannot be released together with pentaho reports but separate as a plugin. The fineract pentaho plugin is maintained by Mifos on this repo https://github.com/openMF/fineract-pentaho and has instructions on how to build and deploy the plugin with fineract. If you face issues with the setup refer to previous mails on this thread and if not clear enough I am happy to assist. It seems that many people are facing issues with the pentaho plugin installation thereby critical that we update the docs/README on the pentaho plugin repo. I am willing to help on this Regards. Honest Chirozva Technical Consultant TAAT Consulting From: Floyd Nickson<mailto:floydnick...@gmail.com> Sent: Sunday, 23 July 2023 15:01 To: Mifos software development<mailto:mifos-develo...@lists.sourceforge.net> Cc: dev@fineract.apache.org<mailto:dev@fineract.apache.org>; mifos-users<mailto:mifos-us...@lists.sourceforge.net> Subject: Re: [Mifos-developer] Fineract-pentaho build failure Good Day everyone, Is there a way to build these reports and use them in a similar fashion as it is done in the official releases 18 and 21? It would be great if that could be done. If anyone is willing to help me out I will appreciate it. Thank you. On Wed, Jul 12, 2023 at 7:20 PM James Dailey mailto:jamespdai...@gmail.com>> wrote: Thanks Honest for that answer. I don't see anything here for the Fineract community to work on, but correct me if I am wrong. Perhaps someone over on the Mifos project (openMF) can update the documentation and change the way that the pentaho configuration is handled. i.e. cp files in deploy script/ add a gradle task? In any case, this is a useful set of instructions so thank you for that. James On Wed, Jul 12, 2023 at 8:16 AM Honest Chirozva mailto:hon...@taatconsulting.com>> wrote: > > Hi Jamui, > > > > + Adding the Mifos community list to this thread as the fineract-pentaho > repo is currently managed under OpenMF Umbrella. > > > > Please note that this is not a FINERACT topic, but you should be able to add > the Pentaho plugin if you follow the instructions under the readme here > https://github.com/openMF/fineract-pentaho > > Please see FAQ about separation of projects. > > > > I was also facing issues with the fineract pentaho plugin and managed to fix > it. > > > > The error as logged is due to missing artifacts from the mifos jfrog > repository. > >fineract-core:jar:0.0.255-beffb9d7 > > fineract-provider:jar:plain:0.0.255-beffb9d7 > > To fix this > > Clone apache/fineract > Build fineract using this command ./gradlew clean build > You should find fineract-core jar and fineract-provider plain jar in the > build directories > Add these jars to your fineract pentaho plugin pom file as system scope > (Notify if you face issues doing this step) > Build the plugin again > > > > Note that this will only build the pentaho plugin jar. For running the plugin > with fineract you should follow the steps at > https://github.com/openMF/fineract-pentaho/blob/develop/README.md. Again if > you encounter problems feel free to ask for assistance > > > > Regards. > > Honest Chirozva > Technical Consultant > > TAAT Consulting > > > > From: Jamiu Ayomide Olawale > Sent: Wednesday, 12 July 2023 16:09 > To: dev@fineract.apache.org<mailto:dev@fineract.apache.org> > Subject: Fineract-pentaho build failure > > > > > dear team > > > > tried building the plugin from git but got the below error > > > > > > > > > > [INFO] > > [INFO] BUILD FAILURE > [INFO] > > [INFO] Total time: 03:31 min > [INFO] Finished at: 2023-07-12T13:08:26Z > [INFO] > > [ERROR] Failed to execute goal on project pentaho-plugin: Could not resolve > dependencies for project community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT: > Failed to collect dependencies at > org.apache.fineract:fineract-provider:jar:plain:0.0.255-beffb9d7 -> > org.apache.fineract:fineract-core:jar:0.0.255-beffb9d7: Failed to read > artifact descriptor for > org.apache.fineract:fineract-core:jar:0.0.255-beffb9d7: Could not transfer > artifact org.apache.fineract:fineract-core:pom:0.0.255-beffb9d7 from/to > fineract-snapshot (https://mifos.jfrog.io/artifactory/libs-snapshot-local): > Transfer failed
Re: [Mifos-developer] Fineract-pentaho build failure
Good Day everyone, Is there a way to build these reports and use them in a similar fashion as it is done in the official releases 18 and 21? It would be great if that could be done. If anyone is willing to help me out I will appreciate it. Thank you. On Wed, Jul 12, 2023 at 7:20 PM James Dailey wrote: > Thanks Honest for that answer. > > I don't see anything here for the Fineract community to work on, but > correct me if I am wrong. > > Perhaps someone over on the Mifos project (openMF) can update the > documentation and change the way that the pentaho configuration is > handled. i.e. cp files in deploy script/ add a gradle task? > > In any case, this is a useful set of instructions so thank you for that. > > James > > On Wed, Jul 12, 2023 at 8:16 AM Honest Chirozva > wrote: > > > > Hi Jamui, > > > > > > > > + Adding the Mifos community list to this thread as the > fineract-pentaho repo is currently managed under OpenMF Umbrella. > > > > > > > > Please note that this is not a FINERACT topic, but you should be able to > add the Pentaho plugin if you follow the instructions under the readme here > https://github.com/openMF/fineract-pentaho > > > > Please see FAQ about separation of projects. > > > > > > > > I was also facing issues with the fineract pentaho plugin and managed to > fix it. > > > > > > > > The error as logged is due to missing artifacts from the mifos jfrog > repository. > > > >fineract-core:jar:0.0.255-beffb9d7 > > > > fineract-provider:jar:plain:0.0.255-beffb9d7 > > > > To fix this > > > > Clone apache/fineract > > Build fineract using this command ./gradlew clean build > > You should find fineract-core jar and fineract-provider plain jar in the > build directories > > Add these jars to your fineract pentaho plugin pom file as system scope > (Notify if you face issues doing this step) > > Build the plugin again > > > > > > > > Note that this will only build the pentaho plugin jar. For running the > plugin with fineract you should follow the steps at > https://github.com/openMF/fineract-pentaho/blob/develop/README.md. Again > if you encounter problems feel free to ask for assistance > > > > > > > > Regards. > > > > Honest Chirozva > > Technical Consultant > > > > TAAT Consulting > > > > > > > > From: Jamiu Ayomide Olawale > > Sent: Wednesday, 12 July 2023 16:09 > > To: dev@fineract.apache.org > > Subject: Fineract-pentaho build failure > > > > > > > > > > dear team > > > > > > > > tried building the plugin from git but got the below error > > > > > > > > > > > > > > > > > > > > [INFO] > > > [INFO] BUILD FAILURE > > [INFO] > > > [INFO] Total time: 03:31 min > > [INFO] Finished at: 2023-07-12T13:08:26Z > > [INFO] > > > [ERROR] Failed to execute goal on project pentaho-plugin: Could not > resolve dependencies for project > community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT: Failed to collect > dependencies at > org.apache.fineract:fineract-provider:jar:plain:0.0.255-beffb9d7 -> > org.apache.fineract:fineract-core:jar:0.0.255-beffb9d7: Failed to read > artifact descriptor for > org.apache.fineract:fineract-core:jar:0.0.255-beffb9d7: Could not transfer > artifact org.apache.fineract:fineract-core:pom:0.0.255-beffb9d7 from/to > fineract-snapshot (https://mifos.jfrog.io/artifactory/libs-snapshot-local): > Transfer failed for > https://mifos.jfrog.io/artifactory/libs-snapshot-local/org/apache/fineract/fineract-core/0.0.255-beffb9d7/fineract-core-0.0.255-beffb9d7.pom > 409 -> [Help 1] > > [ERROR] > > [ERROR] To see the full stack trace of the errors, re-run Maven with the > -e switch. > > [ERROR] Re-run Maven using the -X switch to enable full debug logging. > > [ERROR] > > [ERROR] For more information about the errors and possible solutions, > please read the following articles: > > [ERROR] [Help 1] > http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException > > > > > > > > > > > > > > > > > > > > -- > > > > Sybarite Networks > > > > > > > > > > > > > > > > > > > > > > > > > Mifos-developer mailing list > mifos-develo...@lists.sourceforge.net > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer
RE: Fineract-pentaho build failure
Hello, There seems to be multiple errors with your pom file. This one says you’re missing class file for jakarta.ws.rs.core.MultivaluedMap not found In your pom find the Jakarta dependency and make confirm its like below, jakarta.ws.rs jakarta.ws.rs-api 3.1.0 compile I think it was missing a version. Also update PentahoReportingProcessServiceImpl.java to import MultivaluedMap and Response form the jakarta api. Line 36 and 37 import jakarta.ws.rs.core.MultivaluedMap; import jakarta.ws.rs.core.Response; Build with this command on bash emulator ./mvnw -Dmaven.test.skip=true clean package Regards. Honest Chirozva Technical Consultant TAAT Consulting From: Jamiu Ayomide Olawale<mailto:horlawaleja...@gmail.com> Sent: Tuesday, 18 July 2023 09:51 To: dev@fineract.apache.org<mailto:dev@fineract.apache.org> Cc: mifos-users<mailto:mifos-us...@lists.sourceforge.net>; mifos-develo...@lists.sourceforge.net<mailto:mifos-develo...@lists.sourceforge.net> Subject: Re: Fineract-pentaho build failure Hello Honest Thanks for the help, I am trying to build both for dev and use. did as instructed but got the following error now INFO] --- maven-compiler-plugin:3.10.1:compile (default-compile) @ pentaho-plugin --- [INFO] Changes detected - recompiling the module! [INFO] Compiling 1 source file to E:\fineract-pentaho\target\classes [INFO] Some messages have been simplified; recompile with -Xdiags:verbose to get full output [INFO] - [ERROR] COMPILATION ERROR : [INFO] - [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[77,8] org.apache.fineract.infrastructure.report.service.PentahoReportingProcessServiceImpl is not abstract and does not override abstract method processRequest(java.lang.String,jakarta.ws.rs.core.MultivaluedMap) in org.apache.fineract.infrastructure.report.service.ReportingProcessService [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[107,5] method does not override or implement a method from a supertype [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[110,34] cannot access jakarta.ws.rs.core.MultivaluedMap class file for jakarta.ws.rs.core.MultivaluedMap not found [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[111,61] incompatible types: javax.ws.rs.core.MultivaluedMap cannot be converted to jakarta.ws.rs.core.MultivaluedMap [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[282,5] method does not override or implement a method from a supertype [INFO] 5 errors [INFO] - [INFO] [INFO] BUILD FAILURE [INFO] [INFO] Total time: 03:48 min [INFO] Finished at: 2023-07-18T08:46:23Z [INFO] [ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.10.1:compile (default-compile) on project pentaho-plugin: Compilation failure: Compilation failure: [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[77,8] org.apache.fineract.infrastructure.report.service.PentahoReportingProcessServiceImpl is not abstract and does not override abstract method processRequest(java.lang.String,jakarta.ws.rs.core.MultivaluedMap) in org.apache.fineract.infrastructure.report.service.ReportingProcessService [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[107,5] method does not override or implement a method from a supertype [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[110,34] cannot access jakarta.ws.rs.core.MultivaluedMap [ERROR] class file for jakarta.ws.rs.core.MultivaluedMap not found [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[111,61] incompatible types: javax.ws.rs.core.MultivaluedMap cannot be converted to jakarta.ws.rs.core.MultivaluedMap [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[282,5] method does not override or implement a method
Re: Fineract-pentaho build failure
Hello Honest Thanks for the help, I am trying to build both for dev and use. did as instructed but got the following error now INFO] --- maven-compiler-plugin:3.10.1:compile (default-compile) @ pentaho-plugin --- [INFO] Changes detected - recompiling the module! [INFO] Compiling 1 source file to E:\fineract-pentaho\target\classes [INFO] Some messages have been simplified; recompile with -Xdiags:verbose to get full output [INFO] - [ERROR] COMPILATION ERROR : [INFO] - [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[77,8] org.apache.fineract.infrastructure.report.service.PentahoReportingProcessServiceImpl is not abstract and does not override abstract method processRequest(java.lang.String,jakarta.ws.rs.core.MultivaluedMap) in org.apache.fineract.infrastructure.report.service.ReportingProcessService [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[107,5] method does not override or implement a method from a supertype [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[110,34] cannot access jakarta.ws.rs.core.MultivaluedMap class file for jakarta.ws.rs.core.MultivaluedMap not found [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[111,61] incompatible types: javax.ws.rs.core.MultivaluedMap cannot be converted to jakarta.ws.rs.core.MultivaluedMap [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[282,5] method does not override or implement a method from a supertype [INFO] 5 errors [INFO] - [INFO] [INFO] BUILD FAILURE [INFO] [INFO] Total time: 03:48 min [INFO] Finished at: 2023-07-18T08:46:23Z [INFO] [ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.10.1:compile (default-compile) on project pentaho-plugin: Compilation failure: Compilation failure: [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[77,8] org.apache.fineract.infrastructure.report.service.PentahoReportingProcessServiceImpl is not abstract and does not override abstract method processRequest(java.lang.String,jakarta.ws.rs.core.MultivaluedMap) in org.apache.fineract.infrastructure.report.service.ReportingProcessService [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[107,5] method does not override or implement a method from a supertype [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[110,34] cannot access jakarta.ws.rs.core.MultivaluedMap [ERROR] class file for jakarta.ws.rs.core.MultivaluedMap not found [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[111,61] incompatible types: javax.ws.rs.core.MultivaluedMap cannot be converted to jakarta.ws.rs.core.MultivaluedMap [ERROR] /E:/fineract-pentaho/src/main/java/org/apache/fineract/infrastructure/report/service/PentahoReportingProcessServiceImpl.java:[282,5] method does not override or implement a method from a supertype [ERROR] -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException On Tue, Jul 18, 2023 at 7:08 AM Honest Chirozva wrote: > > > Hi Jamiu, > > > > The error is because there is no fineract jar with version 0.0.255-beffb9d7. > Correct me if I am wrong but I think you renamed the jars and removed the > suffixes with the versions. When you build the fineract jars, they have a > version at the suffix like fineract-core-0.0.0-a119296a.jar, do not rename > them. > > > > Let’s assume you ran gradlew build and got the following artifacts, > > fineract-core-0.0.0-a119296a.jar > > fineract-provider-0.0.0-a119296a-plain.jar > > > > ***NB: the fineract provider has to be a plain jar not the whole >
RE: Fineract-pentaho build failure
Hi Jamiu,
The error is because there is no fineract jar with version 0.0.255-beffb9d7.
Correct me if I am wrong but I think you renamed the jars and removed the
suffixes with the versions. When you build the fineract jars, they have a
version at the suffix like fineract-core-0.0.0-a119296a.jar, do not rename them.
Let’s assume you ran gradlew build and got the following artifacts,
fineract-core-0.0.0-a119296a.jar
fineract-provider-0.0.0-a119296a-plain.jar
***NB: the fineract provider has to be a plain jar not the whole application
jar.
1. Update the fineract pentaho pom with the correct version, in this case
0.0.0-a119296a
…
0.0.0-a119296a
…
1. Create a libs folder at the root of the fineract pentaho project and copy
the jars to that folder.
2. Update your fineract core and fineract plain jars dependencies like
FOR PLAIN JAR
org.apache.fineract
fineract-provider
${fineract.version}
plain
system
${project.basedir}/libs/fineract-provider-${fineract.version}-plain.jar
org.apache.fineract
fineract-avro-schemas
FOR CORE JAR
org.apache.fineract
fineract-core
${fineract.version}
system
${project.basedir}/libs/fineract-core-${fineract.version}.jar
This should allow you to build the plugin jar. However can I ask something? You
want to build the pentaho plugin jar for development purposes or you want to
run the Fineract API with pentaho reports enabled or both?
Regards.
Honest Chirozva
Technical Consultant
TAAT Consulting
From: Jamiu Ayomide Olawale<mailto:horlawaleja...@gmail.com>
Sent: Friday, 14 July 2023 20:27
To: dev@fineract.apache.org<mailto:dev@fineract.apache.org>
Cc: mifos-users<mailto:mifos-us...@lists.sourceforge.net>;
mifos-develo...@lists.sourceforge.net<mailto:mifos-develo...@lists.sourceforge.net>
Subject: Re: Fineract-pentaho build failure
Thanks Honest for the reply
my sincere apologies for mailing the fineract team.
with respect to your number 4 step. i tried the below but got another error.
please help
added the below lines
org.apache.fineract
fineract-provider
${fineract.version}
system
C:/User/DarkVera/fineract-pentaho/fineract-core.jar
org.apache.fineract
fineract-provider
${fineract.version}
system
C:/User/DarkVera/fineract-pentaho/fineract-provider.jar
but got this error
Failed to execute goal on project pentaho-plugin: Could not resolve
dependencies for project community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT:
Could not find artifact
org.apache.fineract:fineract-provider:jar:0.0.255-beffb9d7 at specified path
C:\User\DarkVera\fineract-pentaho\fineract-provider.jar -> [Help 1]
once again, my apologies.
--
Sybarite Networks
On Fri, Jul 14, 2023 at 6:29 PM Jamiu Ayomide Olawale
mailto:horlawaleja...@gmail.com>> wrote:
Thanks Honest for the reply
my sincere apologies for mailing the fineract team.
with respect to your number 4 step. i tried the below but got another error.
please help
added the below lines
org.apache.fineract
fineract-provider
${fineract.version}
system
C:/User/DarkVera/fineract-pentaho/fineract-core.jar
org.apache.fineract
fineract-provider
${fineract.version}
system
C:/User/DarkVera/fineract-pentaho/fineract-provider.jar
but got this error
Failed to execute goal on project pentaho-plugin: Could not resolve
dependencies for project community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT:
Could not find artifact
org.apache.fineract:fineract-provider:jar:0.0.255-beffb9d7 at specified path
C:\User\DarkVera\fineract-pentaho\fineract-provider.jar -> [Help 1]
once again, my apologies.
On Wed, Jul 12, 2023 at 4:18 PM James Dailey
mailto:jamespdai...@gmail.com>> wrote:
Thanks Honest for that answer.
I don't see anything here for the Fineract community to work on, but
correct me if I am wrong.
Perhaps someone over on the Mifos project (openMF) can update the
documentation and change the way that the pentaho configuration is
handled. i.e. cp files in deploy script/ add a gradle task?
In any case, this is a useful set of instructions so thank you for that.
James
On Wed, Jul 12, 2023 at 8:16 AM Honest Chirozva
mailto:hon...@taatconsulting.com>> wrote:
>
> Hi Jamui,
>
>
>
> + Adding the Mifos community list to this thread as the fineract-pentaho
> repo is currently managed under OpenMF Umbrella.
>
>
RE: Fineract-pentaho build failure
Hi Jamiu,
The error is because there is no fineract jar with version 0.0.255-beffb9d7.
Correct me if I am wrong but I think you renamed the jars and removed the
suffixes with the versions. When you build the fineract jars, they have a
version at the suffix like fineract-core-0.0.0-a119296a.jar, do not rename them.
Let’s assume you ran gradlew build and got the following artifacts,
fineract-core-0.0.0-a119296a.jar
fineract-provider-0.0.0-a119296a-plain.jar
***NB: the fineract provider has to be a plain jar not the whole application
jar.
1. Update the fineract pentaho pom with the correct version, in this case
0.0.0-a119296a
…
0.0.0-a119296a
…
1. Create a libs folder at the root of the fineract pentaho project and copy
the jars to that folder.
2. Update your fineract core and fineract plain jars dependencies like
FOR PLAIN JAR
org.apache.fineract
fineract-provider
${fineract.version}
plain
system
${project.basedir}/libs/fineract-provider-${fineract.version}-plain.jar
org.apache.fineract
fineract-avro-schemas
FOR CORE JAR
org.apache.fineract
fineract-core
${fineract.version}
system
${project.basedir}/libs/fineract-core-${fineract.version}.jar
This should allow you to build the plugin jar. However can I ask something? You
want to build the pentaho plugin jar for development purposes or you want to
run the Fineract API with pentaho reports enabled or both?
Regards.
Honest Chirozva
Technical Consultant
TAAT Consulting
From: Jamiu Ayomide Olawale<mailto:horlawaleja...@gmail.com>
Sent: Friday, 14 July 2023 20:27
To: dev@fineract.apache.org<mailto:dev@fineract.apache.org>
Cc: mifos-users<mailto:mifos-us...@lists.sourceforge.net>;
mifos-develo...@lists.sourceforge.net<mailto:mifos-develo...@lists.sourceforge.net>
Subject: Re: Fineract-pentaho build failure
Thanks Honest for the reply
my sincere apologies for mailing the fineract team.
with respect to your number 4 step. i tried the below but got another error.
please help
added the below lines
org.apache.fineract
fineract-provider
${fineract.version}
system
C:/User/DarkVera/fineract-pentaho/fineract-core.jar
org.apache.fineract
fineract-provider
${fineract.version}
system
C:/User/DarkVera/fineract-pentaho/fineract-provider.jar
but got this error
Failed to execute goal on project pentaho-plugin: Could not resolve
dependencies for project community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT:
Could not find artifact
org.apache.fineract:fineract-provider:jar:0.0.255-beffb9d7 at specified path
C:\User\DarkVera\fineract-pentaho\fineract-provider.jar -> [Help 1]
once again, my apologies.
--
Sybarite Networks
On Fri, Jul 14, 2023 at 6:29 PM Jamiu Ayomide Olawale
mailto:horlawaleja...@gmail.com>> wrote:
Thanks Honest for the reply
my sincere apologies for mailing the fineract team.
with respect to your number 4 step. i tried the below but got another error.
please help
added the below lines
org.apache.fineract
fineract-provider
${fineract.version}
system
C:/User/DarkVera/fineract-pentaho/fineract-core.jar
org.apache.fineract
fineract-provider
${fineract.version}
system
C:/User/DarkVera/fineract-pentaho/fineract-provider.jar
but got this error
Failed to execute goal on project pentaho-plugin: Could not resolve
dependencies for project community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT:
Could not find artifact
org.apache.fineract:fineract-provider:jar:0.0.255-beffb9d7 at specified path
C:\User\DarkVera\fineract-pentaho\fineract-provider.jar -> [Help 1]
once again, my apologies.
On Wed, Jul 12, 2023 at 4:18 PM James Dailey
mailto:jamespdai...@gmail.com>> wrote:
Thanks Honest for that answer.
I don't see anything here for the Fineract community to work on, but
correct me if I am wrong.
Perhaps someone over on the Mifos project (openMF) can update the
documentation and change the way that the pentaho configuration is
handled. i.e. cp files in deploy script/ add a gradle task?
In any case, this is a useful set of instructions so thank you for that.
James
On Wed, Jul 12, 2023 at 8:16 AM Honest Chirozva
mailto:hon...@taatconsulting.com>> wrote:
>
> Hi Jamui,
>
>
>
> + Adding the Mifos community list to this thread as the fineract-pentaho
> repo is currently managed under OpenMF Umbrella.
>
>
Re: Fineract-pentaho build failure
Thanks Honest for the reply
my sincere apologies for mailing the fineract team.
with respect to your number 4 step. i tried the below but got another
error. please help
added the below lines
org.apache.fineract
fineract-provider
${fineract.version}
system
C:/User/DarkVera/fineract-pentaho/fineract-core.jar
org.apache.fineract
fineract-provider
${fineract.version}
system
C:/User/DarkVera/fineract-pentaho/fineract-provider.jar
*but got this error*
Failed to execute goal on project pentaho-plugin: Could not resolve
dependencies for project community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT:
Could not find artifact
org.apache.fineract:fineract-provider:jar:0.0.255-beffb9d7 at specified
path C:\User\DarkVera\fineract-pentaho\fineract-provider.jar -> [Help 1]
once again, my apologies.
--
Sybarite Networks
On Fri, Jul 14, 2023 at 6:29 PM Jamiu Ayomide Olawale <
horlawaleja...@gmail.com> wrote:
> Thanks Honest for the reply
>
> my sincere apologies for mailing the fineract team.
>
> with respect to your number 4 step. i tried the below but got another
> error. please help
>
> added the below lines
>
>
>org.apache.fineract
> fineract-provider
> ${fineract.version}
> system
>
> C:/User/DarkVera/fineract-pentaho/fineract-core.jar
>
>
>
>org.apache.fineract
> fineract-provider
> ${fineract.version}
> system
>
> C:/User/DarkVera/fineract-pentaho/fineract-provider.jar
>
>
> *but got this error*
>
>
> Failed to execute goal on project pentaho-plugin: Could not resolve
> dependencies for project community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT:
> Could not find artifact
> org.apache.fineract:fineract-provider:jar:0.0.255-beffb9d7 at specified
> path C:\User\DarkVera\fineract-pentaho\fineract-provider.jar -> [Help 1]
>
>
> once again, my apologies.
>
>
>
>
>
> On Wed, Jul 12, 2023 at 4:18 PM James Dailey
> wrote:
>
>> Thanks Honest for that answer.
>>
>> I don't see anything here for the Fineract community to work on, but
>> correct me if I am wrong.
>>
>> Perhaps someone over on the Mifos project (openMF) can update the
>> documentation and change the way that the pentaho configuration is
>> handled. i.e. cp files in deploy script/ add a gradle task?
>>
>> In any case, this is a useful set of instructions so thank you for that.
>>
>> James
>>
>> On Wed, Jul 12, 2023 at 8:16 AM Honest Chirozva
>> wrote:
>> >
>> > Hi Jamui,
>> >
>> >
>> >
>> > + Adding the Mifos community list to this thread as the
>> fineract-pentaho repo is currently managed under OpenMF Umbrella.
>> >
>> >
>> >
>> > Please note that this is not a FINERACT topic, but you should be able
>> to add the Pentaho plugin if you follow the instructions under the readme
>> here https://github.com/openMF/fineract-pentaho
>> >
>> > Please see FAQ about separation of projects.
>> >
>> >
>> >
>> > I was also facing issues with the fineract pentaho plugin and managed
>> to fix it.
>> >
>> >
>> >
>> > The error as logged is due to missing artifacts from the mifos jfrog
>> repository.
>> >
>> >fineract-core:jar:0.0.255-beffb9d7
>> >
>> > fineract-provider:jar:plain:0.0.255-beffb9d7
>> >
>> > To fix this
>> >
>> > Clone apache/fineract
>> > Build fineract using this command ./gradlew clean build
>> > You should find fineract-core jar and fineract-provider plain jar in
>> the build directories
>> > Add these jars to your fineract pentaho plugin pom file as system scope
>> (Notify if you face issues doing this step)
>> > Build the plugin again
>> >
>> >
>> >
>> > Note that this will only build the pentaho plugin jar. For running the
>> plugin with fineract you should follow the steps at
>> https://github.com/openMF/fineract-pentaho/blob/develop/README.md. Again
>> if you encounter problems feel free to ask for assistance
>> >
>> >
>> >
>> > Regards.
>> >
>> > Honest Chirozva
>> > Technical Consultant
>> >
>> > TAAT Consulting
>> >
>> >
>> >
>> > From: Jamiu Ayomide Olawale
>> > Sent: Wednesday, 12 July 2023 16:09
>> > To: dev@fin
Re: Fineract-pentaho build failure
Thanks Honest for the reply
my sincere apologies for mailing the fineract team.
with respect to your number 4 step. i tried the below but got another
error. please help
added the below lines
org.apache.fineract
fineract-provider
${fineract.version}
system
C:/User/DarkVera/fineract-pentaho/fineract-core.jar
org.apache.fineract
fineract-provider
${fineract.version}
system
C:/User/DarkVera/fineract-pentaho/fineract-provider.jar
*but got this error*
Failed to execute goal on project pentaho-plugin: Could not resolve
dependencies for project community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT:
Could not find artifact
org.apache.fineract:fineract-provider:jar:0.0.255-beffb9d7 at specified
path C:\User\DarkVera\fineract-pentaho\fineract-provider.jar -> [Help 1]
once again, my apologies.
On Wed, Jul 12, 2023 at 4:18 PM James Dailey wrote:
> Thanks Honest for that answer.
>
> I don't see anything here for the Fineract community to work on, but
> correct me if I am wrong.
>
> Perhaps someone over on the Mifos project (openMF) can update the
> documentation and change the way that the pentaho configuration is
> handled. i.e. cp files in deploy script/ add a gradle task?
>
> In any case, this is a useful set of instructions so thank you for that.
>
> James
>
> On Wed, Jul 12, 2023 at 8:16 AM Honest Chirozva
> wrote:
> >
> > Hi Jamui,
> >
> >
> >
> > + Adding the Mifos community list to this thread as the
> fineract-pentaho repo is currently managed under OpenMF Umbrella.
> >
> >
> >
> > Please note that this is not a FINERACT topic, but you should be able to
> add the Pentaho plugin if you follow the instructions under the readme here
> https://github.com/openMF/fineract-pentaho
> >
> > Please see FAQ about separation of projects.
> >
> >
> >
> > I was also facing issues with the fineract pentaho plugin and managed to
> fix it.
> >
> >
> >
> > The error as logged is due to missing artifacts from the mifos jfrog
> repository.
> >
> >fineract-core:jar:0.0.255-beffb9d7
> >
> > fineract-provider:jar:plain:0.0.255-beffb9d7
> >
> > To fix this
> >
> > Clone apache/fineract
> > Build fineract using this command ./gradlew clean build
> > You should find fineract-core jar and fineract-provider plain jar in the
> build directories
> > Add these jars to your fineract pentaho plugin pom file as system scope
> (Notify if you face issues doing this step)
> > Build the plugin again
> >
> >
> >
> > Note that this will only build the pentaho plugin jar. For running the
> plugin with fineract you should follow the steps at
> https://github.com/openMF/fineract-pentaho/blob/develop/README.md. Again
> if you encounter problems feel free to ask for assistance
> >
> >
> >
> > Regards.
> >
> > Honest Chirozva
> > Technical Consultant
> >
> > TAAT Consulting
> >
> >
> >
> > From: Jamiu Ayomide Olawale
> > Sent: Wednesday, 12 July 2023 16:09
> > To: dev@fineract.apache.org
> > Subject: Fineract-pentaho build failure
> >
> >
> >
> >
> > dear team
> >
> >
> >
> > tried building the plugin from git but got the below error
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > [INFO]
>
> > [INFO] BUILD FAILURE
> > [INFO]
>
> > [INFO] Total time: 03:31 min
> > [INFO] Finished at: 2023-07-12T13:08:26Z
> > [INFO]
>
> > [ERROR] Failed to execute goal on project pentaho-plugin: Could not
> resolve dependencies for project
> community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT: Failed to collect
> dependencies at
> org.apache.fineract:fineract-provider:jar:plain:0.0.255-beffb9d7 ->
> org.apache.fineract:fineract-core:jar:0.0.255-beffb9d7: Failed to read
> artifact descriptor for
> org.apache.fineract:fineract-core:jar:0.0.255-beffb9d7: Could not transfer
> artifact org.apache.fineract:fineract-core:pom:0.0.255-beffb9d7 from/to
> fineract-snapshot (https://mifos.jfrog.io/artifactory/libs-snapshot-local):
> Transfer failed for
> https://mifos.jfrog.io/artifactory/libs-snapshot-local/org/apache/fineract/fineract-core/0.0.255-beffb9d7/fineract-core-0.0.255-beffb9d7.pom
> 409
> -> [Help 1]
>
Re: Fineract-pentaho build failure
Thanks Honest for that answer. I don't see anything here for the Fineract community to work on, but correct me if I am wrong. Perhaps someone over on the Mifos project (openMF) can update the documentation and change the way that the pentaho configuration is handled. i.e. cp files in deploy script/ add a gradle task? In any case, this is a useful set of instructions so thank you for that. James On Wed, Jul 12, 2023 at 8:16 AM Honest Chirozva wrote: > > Hi Jamui, > > > > + Adding the Mifos community list to this thread as the fineract-pentaho > repo is currently managed under OpenMF Umbrella. > > > > Please note that this is not a FINERACT topic, but you should be able to add > the Pentaho plugin if you follow the instructions under the readme here > https://github.com/openMF/fineract-pentaho > > Please see FAQ about separation of projects. > > > > I was also facing issues with the fineract pentaho plugin and managed to fix > it. > > > > The error as logged is due to missing artifacts from the mifos jfrog > repository. > >fineract-core:jar:0.0.255-beffb9d7 > > fineract-provider:jar:plain:0.0.255-beffb9d7 > > To fix this > > Clone apache/fineract > Build fineract using this command ./gradlew clean build > You should find fineract-core jar and fineract-provider plain jar in the > build directories > Add these jars to your fineract pentaho plugin pom file as system scope > (Notify if you face issues doing this step) > Build the plugin again > > > > Note that this will only build the pentaho plugin jar. For running the plugin > with fineract you should follow the steps at > https://github.com/openMF/fineract-pentaho/blob/develop/README.md. Again if > you encounter problems feel free to ask for assistance > > > > Regards. > > Honest Chirozva > Technical Consultant > > TAAT Consulting > > > > From: Jamiu Ayomide Olawale > Sent: Wednesday, 12 July 2023 16:09 > To: dev@fineract.apache.org > Subject: Fineract-pentaho build failure > > > > > dear team > > > > tried building the plugin from git but got the below error > > > > > > > > > > [INFO] > > [INFO] BUILD FAILURE > [INFO] > ---- > [INFO] Total time: 03:31 min > [INFO] Finished at: 2023-07-12T13:08:26Z > [INFO] > > [ERROR] Failed to execute goal on project pentaho-plugin: Could not resolve > dependencies for project community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT: > Failed to collect dependencies at > org.apache.fineract:fineract-provider:jar:plain:0.0.255-beffb9d7 -> > org.apache.fineract:fineract-core:jar:0.0.255-beffb9d7: Failed to read > artifact descriptor for > org.apache.fineract:fineract-core:jar:0.0.255-beffb9d7: Could not transfer > artifact org.apache.fineract:fineract-core:pom:0.0.255-beffb9d7 from/to > fineract-snapshot (https://mifos.jfrog.io/artifactory/libs-snapshot-local): > Transfer failed for > https://mifos.jfrog.io/artifactory/libs-snapshot-local/org/apache/fineract/fineract-core/0.0.255-beffb9d7/fineract-core-0.0.255-beffb9d7.pom > 409 -> [Help 1] > [ERROR] > [ERROR] To see the full stack trace of the errors, re-run Maven with the -e > switch. > [ERROR] Re-run Maven using the -X switch to enable full debug logging. > [ERROR] > [ERROR] For more information about the errors and possible solutions, please > read the following articles: > [ERROR] [Help 1] > http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException > > > > > > > > > > -- > > Sybarite Networks > > > > > > > > > > >
RE: Fineract-pentaho build failure
Hi Jamui, + Adding the Mifos community list to this thread as the fineract-pentaho repo is currently managed under OpenMF Umbrella. Please note that this is not a FINERACT topic, but you should be able to add the Pentaho plugin if you follow the instructions under the readme here https://github.com/openMF/fineract-pentaho Please see FAQ about separation of projects. I was also facing issues with the fineract pentaho plugin and managed to fix it. The error as logged is due to missing artifacts from the mifos jfrog repository. fineract-core:jar:0.0.255-beffb9d7 fineract-provider:jar:plain:0.0.255-beffb9d7 To fix this 1. Clone apache/fineract 2. Build fineract using this command ./gradlew clean build 3. You should find fineract-core jar and fineract-provider plain jar in the build directories 4. Add these jars to your fineract pentaho plugin pom file as system scope (Notify if you face issues doing this step) 5. Build the plugin again Note that this will only build the pentaho plugin jar. For running the plugin with fineract you should follow the steps at https://github.com/openMF/fineract-pentaho/blob/develop/README.md. Again if you encounter problems feel free to ask for assistance Regards. Honest Chirozva Technical Consultant TAAT Consulting From: Jamiu Ayomide Olawale<mailto:horlawaleja...@gmail.com> Sent: Wednesday, 12 July 2023 16:09 To: dev@fineract.apache.org<mailto:dev@fineract.apache.org> Subject: Fineract-pentaho build failure dear team tried building the plugin from git but got the below error [INFO] [INFO] BUILD FAILURE [INFO] [INFO] Total time: 03:31 min [INFO] Finished at: 2023-07-12T13:08:26Z [INFO] [ERROR] Failed to execute goal on project pentaho-plugin: Could not resolve dependencies for project community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT: Failed to collect dependencies at org.apache.fineract:fineract-provider:jar:plain:0.0.255-beffb9d7 -> org.apache.fineract:fineract-core:jar:0.0.255-beffb9d7: Failed to read artifact descriptor for org.apache.fineract:fineract-core:jar:0.0.255-beffb9d7: Could not transfer artifact org.apache.fineract:fineract-core:pom:0.0.255-beffb9d7 from/to fineract-snapshot (https://mifos.jfrog.io/artifactory/libs-snapshot-local): Transfer failed for https://mifos.jfrog.io/artifactory/libs-snapshot-local/org/apache/fineract/fineract-core/0.0.255-beffb9d7/fineract-core-0.0.255-beffb9d7.pom 409 -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException -- Sybarite Networks
Fineract-pentaho build failure
dear team tried building the plugin from git but got the below error [INFO] [INFO] BUILD FAILURE [INFO] [INFO] Total time: 03:31 min [INFO] Finished at: 2023-07-12T13:08:26Z [INFO] [ERROR] Failed to execute goal on project pentaho-plugin: Could not resolve dependencies for project community.mifos:pentaho-plugin:jar:1.8.4-SNAPSHOT: Failed to collect dependencies at org.apache.fineract:fineract-provider:jar:plain:0.0.255-beffb9d7 -> org.apache.fineract:fineract-core:jar:0.0.255-beffb9d7: Failed to read artifact descriptor for org.apache.fineract:fineract-core:jar:0.0.255-beffb9d7: Could not transfer artifact org.apache.fineract:fineract-core:pom:0.0.255-beffb9d7 from/to fineract-snapshot (https://mifos.jfrog.io/artifactory/libs-snapshot-local): Transfer failed for https://mifos.jfrog.io/artifactory/libs-snapshot-local/org/apache/fineract/fineract-core/0.0.255-beffb9d7/fineract-core-0.0.255-beffb9d7.pom 409 -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException -- Sybarite Networks
Re: [Mifos-users] FINERACT PENTAHO
Hi Honest, Appreciate your interest in helping with the documentation, you can make the changes to the readme file of the Pentaho plugin GitHub repository https://github.com/openMF/fineract-pentaho#readme through PR. or you could send here a text document and we could help in updating the readme file from our end. Please not that the Pentaho plugin is not part of the Fineract project. it is being managed under Mifos. hereafter, any questions or queries related to Pentaho Please send them to Regards, Bharath Lead Implementation Analyst | Mifos Initiative Skype: live:cbharath4| Mobile: +91.7019635592 http://mifos.org <http://facebook.com/mifos> <http://www.twitter.com/mifos> On Thu, Jul 6, 2023 at 12:38 PM Honest Chirozva wrote: > Greetings, > > > > > > Thank you Victor for the clarity. I can help with the documentation at > Fineract about the plugin. How can I do that? > > > > Regards. > > Honest Chirozva > Technical Consultant > > TAAT Consulting > > > > *From: *James Dailey > *Sent: *Tuesday, 27 June 2023 18:07 > *To: *dev@fineract.apache.org > *Subject: *Re: [Mifos-users] FINERACT PENTAHO > > > > It appears that this is not a FINERACT topic. > > > > Please see FAQ about separation of projects. > > If there is an issue that relates to the plug in concept at Fineract, > please revert here. > > > > The Mifos project is not discussed here. > > If you think additional documentation at Fineract would help smooth this > for all plug-ins, please also make those suggestions to the existing > documentation at Fineract. In a "diff" manner. > > > > Thanks. > > > > > > On Tue, Jun 27, 2023 at 12:07 AM Honest Chirozva < > hon...@taatconsulting.com> wrote: > > Thanks Ed, > > > > I am available to contribute to the project and make necessary > documentation. Below are the issues I think new users might face when > integration pentaho reports which the docs do not answer > > > >1. How to enable the pentaho plugin in fineract-provider jar >2. What about the war file? >3. The pentaho plugin pom fails to locate fineract-provider plain jar. >Should we maybe provide guideline on how to build the jars locally for >fineract-core, fineract-client and fineract-provider-plain.jar? >4. The plugin depends on multiple jars, do we have to manually >download the jars? Can’t we build the fineract-pentaho plugin as a fat jar >with its dependencies included? >5. My thinking is that you only need fineract-provider.jar, >fineract-pentaho.jar, and a zip folder with the reports. These three must >work together without one needing to re build any of the jars? > > > > Regards. > > Honest Chirozva > Technical Consultant > > > > *From: *Ed Cable > *Sent: *Monday, 26 June 2023 17:00 > *To: *dev@fineract.apache.org > *Subject: *Re: [Mifos-users] FINERACT PENTAHO > > > > Honest, > > > > Can you directly share the issues you are facing while doing the > build/install? You could also then help improve the documentation yourself > based on what additional guidance community members can give you. > > > > Ed > > > > On Mon, Jun 26, 2023 at 5:52 AM Honest Chirozva > wrote: > > I have tried to follow the guideline but no avail. Can someone just > explain to me what to do in simple terms? > > > Honest Chirozva > Technical Consultant > > > > > > *From: *Francis Guchie > *Sent: *Monday, 26 June 2023 14:28 > *To: *A good place to start for users or folks new to Mifos. > > *Cc: *dev@fineract.apache.org > *Subject: *Re: [Mifos-users] FINERACT PENTAHO > > > > Dear Honest, > > > > Kindly follow the events here ==> > https://github.com/openMF/fineract-pentaho/issues this way we can follow > up on the challenges > > > > > > > > > > My Kind Regards > > > > > > Francis Kirago Guchie > > *Mobile:* > > +232 79 194407 > > +256 70 5011852 > > > > *Skype:* francisguchie > > *twitter*: @francisguchie > > *Telegram: *232 79 19 44 07 > > *Whatsapp: *232 79 19 44 07 > > *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-a4379617/ > > *Website: *https://guchietech.com > > > > > > On Mon, Jun 26, 2023 at 12:07 PM Bharath Gowda wrote: > > Hi Honest. > > + Adding the Mifos community list to this thread as the fineract-pentaho > repo is currently managed under OpenMF Umbrella. > > > > you should be able to add the Pentaho plugin if you follow the > instructions under the readme here > https://github.com/openMF/fin
RE: [Mifos-users] FINERACT PENTAHO
Greetings, Thank you Victor for the clarity. I can help with the documentation at Fineract about the plugin. How can I do that? Regards. Honest Chirozva Technical Consultant TAAT Consulting From: James Dailey<mailto:jamespdai...@gmail.com> Sent: Tuesday, 27 June 2023 18:07 To: dev@fineract.apache.org<mailto:dev@fineract.apache.org> Subject: Re: [Mifos-users] FINERACT PENTAHO It appears that this is not a FINERACT topic. Please see FAQ about separation of projects. If there is an issue that relates to the plug in concept at Fineract, please revert here. The Mifos project is not discussed here. If you think additional documentation at Fineract would help smooth this for all plug-ins, please also make those suggestions to the existing documentation at Fineract. In a "diff" manner. Thanks. On Tue, Jun 27, 2023 at 12:07 AM Honest Chirozva mailto:hon...@taatconsulting.com>> wrote: Thanks Ed, I am available to contribute to the project and make necessary documentation. Below are the issues I think new users might face when integration pentaho reports which the docs do not answer 1. How to enable the pentaho plugin in fineract-provider jar 2. What about the war file? 3. The pentaho plugin pom fails to locate fineract-provider plain jar. Should we maybe provide guideline on how to build the jars locally for fineract-core, fineract-client and fineract-provider-plain.jar? 4. The plugin depends on multiple jars, do we have to manually download the jars? Can’t we build the fineract-pentaho plugin as a fat jar with its dependencies included? 5. My thinking is that you only need fineract-provider.jar, fineract-pentaho.jar, and a zip folder with the reports. These three must work together without one needing to re build any of the jars? Regards. Honest Chirozva Technical Consultant From: Ed Cable<mailto:edca...@mifos.org> Sent: Monday, 26 June 2023 17:00 To: dev@fineract.apache.org<mailto:dev@fineract.apache.org> Subject: Re: [Mifos-users] FINERACT PENTAHO Honest, Can you directly share the issues you are facing while doing the build/install? You could also then help improve the documentation yourself based on what additional guidance community members can give you. Ed On Mon, Jun 26, 2023 at 5:52 AM Honest Chirozva mailto:hon...@taatconsulting.com>> wrote: I have tried to follow the guideline but no avail. Can someone just explain to me what to do in simple terms? Honest Chirozva Technical Consultant From: Francis Guchie<mailto:francisguc...@gmail.com> Sent: Monday, 26 June 2023 14:28 To: A good place to start for users or folks new to Mifos.<mailto:mifos-us...@lists.sourceforge.net> Cc: dev@fineract.apache.org<mailto:dev@fineract.apache.org> Subject: Re: [Mifos-users] FINERACT PENTAHO Dear Honest, Kindly follow the events here ==> https://github.com/openMF/fineract-pentaho/issues this way we can follow up on the challenges My Kind Regards Francis Kirago Guchie Mobile: +232 79 194407 +256 70 5011852 Skype: francisguchie twitter: @francisguchie Telegram: 232 79 19 44 07 Whatsapp: 232 79 19 44 07 LINKEDIN: https://www.linkedin.com/in/francis-guchie-a4379617/ Website: https://guchietech.com On Mon, Jun 26, 2023 at 12:07 PM Bharath Gowda mailto:bgo...@mifos.org>> wrote: Hi Honest. + Adding the Mifos community list to this thread as the fineract-pentaho repo is currently managed under OpenMF Umbrella. you should be able to add the Pentaho plugin if you follow the instructions under the readme here https://github.com/openMF/fineract-pentaho feel free to post questions in the same thread if you hit any dead ends during the plugin installation process Regards, Bharath Lead Implementation Analyst | Mifos Initiative Skype: live:cbharath4| Mobile: +91.7019635592 http://mifos.org<http://mifos.org/> [https://secure.plimus.com/developers/817570/Template/icon-tiny-facebook.png] <http://facebook.com/mifos> [http://organizationsandmarkets.files.wordpress.com/2010/04/icon-tiny-twitter.png] <http://www.twitter.com/mifos> On Mon, Jun 26, 2023 at 1:27 PM Honest Chirozva mailto:hon...@taatconsulting.com>> wrote: Greetings community, Can someone guide me on how to build finerect pentaho plugin against the latest fineract develop branch. Kind Regards! Honest Chirozva Technical Consultant Mobile: +263 718 795 908 Email: hon...@taatconsulting.com<mailto:hon...@taatconsulting.com> Web : www.taatconsulting.com<https://www.taatconsulting.com/> [cid:188fd98d461378dd91d1] ___ Mifos-users mailing list mifos-us...@lists.sourceforge.net<mailto:mifos-us...@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/mifos-users -- Ed Cable President/CEO, Mifos Initiative edca...@mifos.org<mailto:edca...@mifos.org> | Skype: edcable | Mobile: +1.484.477.8649 Collectively Creating a W
Re: [Mifos-users] FINERACT PENTAHO
Thanks for clarifying this as well too. As you can see from the last message that Victor sent, he removed the dev list and kept the discussion just on the Mifos list. Thanks Victor for both replying about the thread and isolating it to the right place. Ed On Tue, Jun 27, 2023, 09:07 James Dailey wrote: > It appears that this is not a FINERACT topic. > > Please see FAQ about separation of projects. > If there is an issue that relates to the plug in concept at Fineract, > please revert here. > > The Mifos project is not discussed here. > If you think additional documentation at Fineract would help smooth this > for all plug-ins, please also make those suggestions to the existing > documentation at Fineract. In a "diff" manner. > > Thanks. > > > On Tue, Jun 27, 2023 at 12:07 AM Honest Chirozva < > hon...@taatconsulting.com> wrote: > >> Thanks Ed, >> >> >> >> I am available to contribute to the project and make necessary >> documentation. Below are the issues I think new users might face when >> integration pentaho reports which the docs do not answer >> >> >> >>1. How to enable the pentaho plugin in fineract-provider jar >>2. What about the war file? >>3. The pentaho plugin pom fails to locate fineract-provider plain >>jar. Should we maybe provide guideline on how to build the jars locally >> for >>fineract-core, fineract-client and fineract-provider-plain.jar? >>4. The plugin depends on multiple jars, do we have to manually >>download the jars? Can’t we build the fineract-pentaho plugin as a fat jar >>with its dependencies included? >>5. My thinking is that you only need fineract-provider.jar, >>fineract-pentaho.jar, and a zip folder with the reports. These three must >>work together without one needing to re build any of the jars? >> >> >> >> Regards. >> >> Honest Chirozva >> Technical Consultant >> >> >> >> *From: *Ed Cable >> *Sent: *Monday, 26 June 2023 17:00 >> *To: *dev@fineract.apache.org >> *Subject: *Re: [Mifos-users] FINERACT PENTAHO >> >> >> >> Honest, >> >> >> >> Can you directly share the issues you are facing while doing the >> build/install? You could also then help improve the documentation yourself >> based on what additional guidance community members can give you. >> >> >> >> Ed >> >> >> >> On Mon, Jun 26, 2023 at 5:52 AM Honest Chirozva < >> hon...@taatconsulting.com> wrote: >> >> I have tried to follow the guideline but no avail. Can someone just >> explain to me what to do in simple terms? >> >> >> Honest Chirozva >> Technical Consultant >> >> >> >> >> >> *From: *Francis Guchie >> *Sent: *Monday, 26 June 2023 14:28 >> *To: *A good place to start for users or folks new to Mifos. >> >> *Cc: *dev@fineract.apache.org >> *Subject: *Re: [Mifos-users] FINERACT PENTAHO >> >> >> >> Dear Honest, >> >> >> >> Kindly follow the events here ==> >> https://github.com/openMF/fineract-pentaho/issues this way we can follow >> up on the challenges >> >> >> >> >> >> >> >> >> >> My Kind Regards >> >> >> >> >> >> Francis Kirago Guchie >> >> *Mobile:* >> >> +232 79 194407 >> >> +256 70 5011852 >> >> >> >> *Skype:* francisguchie >> >> *twitter*: @francisguchie >> >> *Telegram: *232 79 19 44 07 >> >> *Whatsapp: *232 79 19 44 07 >> >> *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-a4379617/ >> >> *Website: *https://guchietech.com >> >> >> >> >> >> On Mon, Jun 26, 2023 at 12:07 PM Bharath Gowda wrote: >> >> Hi Honest. >> >> + Adding the Mifos community list to this thread as the fineract-pentaho >> repo is currently managed under OpenMF Umbrella. >> >> >> >> you should be able to add the Pentaho plugin if you follow the >> instructions under the readme here >> https://github.com/openMF/fineract-pentaho >> >> >> >> feel free to post questions in the same thread if you hit any dead ends >> during the plugin installation process >> >> >> >> >> Regards, >> >> Bharath >> >> Lead Implementation Analyst | Mifos Initiative >> >> Skype: live:cbharath4| Mobile: +91.7019635592 >> >> http://mifos.org <http://facebook.com/mifos> >> <http://www.twitter.com/mifos> >> >> >> >> >> >> On Mon, Jun 26, 2023 at 1:27 PM Honest Chirozva < >> hon...@taatconsulting.com> wrote: >> >> Greetings community, >> >> >> >> Can someone guide me on how to build finerect pentaho plugin against the >> latest fineract develop branch. >> >> >> >> Kind Regards! >> >> Honest Chirozva >> Technical Consultant >> >> >> >> Mobile: +263 718 795 908 >> Email: hon...@taatconsulting.com >> >> Web : www.taatconsulting.com >> >> >> >> ___ >> Mifos-users mailing list >> mifos-us...@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/mifos-users >> >> >> >> >> >> >> -- >> >> *Ed Cable* >> >> President/CEO, Mifos Initiative >> >> edca...@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: [Mifos-users] FINERACT PENTAHO
It appears that this is not a FINERACT topic. Please see FAQ about separation of projects. If there is an issue that relates to the plug in concept at Fineract, please revert here. The Mifos project is not discussed here. If you think additional documentation at Fineract would help smooth this for all plug-ins, please also make those suggestions to the existing documentation at Fineract. In a "diff" manner. Thanks. On Tue, Jun 27, 2023 at 12:07 AM Honest Chirozva wrote: > Thanks Ed, > > > > I am available to contribute to the project and make necessary > documentation. Below are the issues I think new users might face when > integration pentaho reports which the docs do not answer > > > >1. How to enable the pentaho plugin in fineract-provider jar >2. What about the war file? >3. The pentaho plugin pom fails to locate fineract-provider plain jar. >Should we maybe provide guideline on how to build the jars locally for >fineract-core, fineract-client and fineract-provider-plain.jar? >4. The plugin depends on multiple jars, do we have to manually >download the jars? Can’t we build the fineract-pentaho plugin as a fat jar >with its dependencies included? >5. My thinking is that you only need fineract-provider.jar, >fineract-pentaho.jar, and a zip folder with the reports. These three must >work together without one needing to re build any of the jars? > > > > Regards. > > Honest Chirozva > Technical Consultant > > > > *From: *Ed Cable > *Sent: *Monday, 26 June 2023 17:00 > *To: *dev@fineract.apache.org > *Subject: *Re: [Mifos-users] FINERACT PENTAHO > > > > Honest, > > > > Can you directly share the issues you are facing while doing the > build/install? You could also then help improve the documentation yourself > based on what additional guidance community members can give you. > > > > Ed > > > > On Mon, Jun 26, 2023 at 5:52 AM Honest Chirozva > wrote: > > I have tried to follow the guideline but no avail. Can someone just > explain to me what to do in simple terms? > > > Honest Chirozva > Technical Consultant > > > > > > *From: *Francis Guchie > *Sent: *Monday, 26 June 2023 14:28 > *To: *A good place to start for users or folks new to Mifos. > > *Cc: *dev@fineract.apache.org > *Subject: *Re: [Mifos-users] FINERACT PENTAHO > > > > Dear Honest, > > > > Kindly follow the events here ==> > https://github.com/openMF/fineract-pentaho/issues this way we can follow > up on the challenges > > > > > > > > > > My Kind Regards > > > > > > Francis Kirago Guchie > > *Mobile:* > > +232 79 194407 > > +256 70 5011852 > > > > *Skype:* francisguchie > > *twitter*: @francisguchie > > *Telegram: *232 79 19 44 07 > > *Whatsapp: *232 79 19 44 07 > > *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-a4379617/ > > *Website: *https://guchietech.com > > > > > > On Mon, Jun 26, 2023 at 12:07 PM Bharath Gowda wrote: > > Hi Honest. > > + Adding the Mifos community list to this thread as the fineract-pentaho > repo is currently managed under OpenMF Umbrella. > > > > you should be able to add the Pentaho plugin if you follow the > instructions under the readme here > https://github.com/openMF/fineract-pentaho > > > > feel free to post questions in the same thread if you hit any dead ends > during the plugin installation process > > > > > Regards, > > Bharath > > Lead Implementation Analyst | Mifos Initiative > > Skype: live:cbharath4| Mobile: +91.7019635592 > > http://mifos.org <http://facebook.com/mifos> > <http://www.twitter.com/mifos> > > > > > > On Mon, Jun 26, 2023 at 1:27 PM Honest Chirozva > wrote: > > Greetings community, > > > > Can someone guide me on how to build finerect pentaho plugin against the > latest fineract develop branch. > > > > Kind Regards! > > Honest Chirozva > Technical Consultant > > > > Mobile: +263 718 795 908 > Email: hon...@taatconsulting.com > > Web : www.taatconsulting.com > > > > ___ > Mifos-users mailing list > mifos-us...@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > > > > -- > > *Ed Cable* > > President/CEO, Mifos Initiative > > edca...@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: [Mifos-users] FINERACT PENTAHO
Thanks Ed, I am available to contribute to the project and make necessary documentation. Below are the issues I think new users might face when integration pentaho reports which the docs do not answer 1. How to enable the pentaho plugin in fineract-provider jar 2. What about the war file? 3. The pentaho plugin pom fails to locate fineract-provider plain jar. Should we maybe provide guideline on how to build the jars locally for fineract-core, fineract-client and fineract-provider-plain.jar? 4. The plugin depends on multiple jars, do we have to manually download the jars? Can’t we build the fineract-pentaho plugin as a fat jar with its dependencies included? 5. My thinking is that you only need fineract-provider.jar, fineract-pentaho.jar, and a zip folder with the reports. These three must work together without one needing to re build any of the jars? Regards. Honest Chirozva Technical Consultant From: Ed Cable<mailto:edca...@mifos.org> Sent: Monday, 26 June 2023 17:00 To: dev@fineract.apache.org<mailto:dev@fineract.apache.org> Subject: Re: [Mifos-users] FINERACT PENTAHO Honest, Can you directly share the issues you are facing while doing the build/install? You could also then help improve the documentation yourself based on what additional guidance community members can give you. Ed On Mon, Jun 26, 2023 at 5:52 AM Honest Chirozva mailto:hon...@taatconsulting.com>> wrote: I have tried to follow the guideline but no avail. Can someone just explain to me what to do in simple terms? Honest Chirozva Technical Consultant From: Francis Guchie<mailto:francisguc...@gmail.com> Sent: Monday, 26 June 2023 14:28 To: A good place to start for users or folks new to Mifos.<mailto:mifos-us...@lists.sourceforge.net> Cc: dev@fineract.apache.org<mailto:dev@fineract.apache.org> Subject: Re: [Mifos-users] FINERACT PENTAHO Dear Honest, Kindly follow the events here ==> https://github.com/openMF/fineract-pentaho/issues this way we can follow up on the challenges My Kind Regards Francis Kirago Guchie Mobile: +232 79 194407 +256 70 5011852 Skype: francisguchie twitter: @francisguchie Telegram: 232 79 19 44 07 Whatsapp: 232 79 19 44 07 LINKEDIN: https://www.linkedin.com/in/francis-guchie-a4379617/ Website: https://guchietech.com On Mon, Jun 26, 2023 at 12:07 PM Bharath Gowda mailto:bgo...@mifos.org>> wrote: Hi Honest. + Adding the Mifos community list to this thread as the fineract-pentaho repo is currently managed under OpenMF Umbrella. you should be able to add the Pentaho plugin if you follow the instructions under the readme here https://github.com/openMF/fineract-pentaho feel free to post questions in the same thread if you hit any dead ends during the plugin installation process Regards, Bharath Lead Implementation Analyst | Mifos Initiative Skype: live:cbharath4| Mobile: +91.7019635592 http://mifos.org<http://mifos.org/> [https://secure.plimus.com/developers/817570/Template/icon-tiny-facebook.png] <http://facebook.com/mifos> [http://organizationsandmarkets.files.wordpress.com/2010/04/icon-tiny-twitter.png] <http://www.twitter.com/mifos> On Mon, Jun 26, 2023 at 1:27 PM Honest Chirozva mailto:hon...@taatconsulting.com>> wrote: Greetings community, Can someone guide me on how to build finerect pentaho plugin against the latest fineract develop branch. Kind Regards! Honest Chirozva Technical Consultant Mobile: +263 718 795 908 Email: hon...@taatconsulting.com<mailto:hon...@taatconsulting.com> Web : www.taatconsulting.com<https://www.taatconsulting.com/> [cid:188f83567a5378dd91d1] ___ Mifos-users mailing list mifos-us...@lists.sourceforge.net<mailto:mifos-us...@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/mifos-users -- Ed Cable President/CEO, Mifos Initiative edca...@mifos.org<mailto:edca...@mifos.org> | Skype: edcable | Mobile: +1.484.477.8649 Collectively Creating a World of 3 Billion Maries | http://mifos.org [https://secure.plimus.com/developers/817570/Template/icon-tiny-facebook.png] <http://facebook.com/mifos> [http://organizationsandmarkets.files.wordpress.com/2010/04/icon-tiny-twitter.png] <http://www.twitter.com/mifos>
Re: [Mifos-users] FINERACT PENTAHO
Honest, Can you directly share the issues you are facing while doing the build/install? You could also then help improve the documentation yourself based on what additional guidance community members can give you. Ed On Mon, Jun 26, 2023 at 5:52 AM Honest Chirozva wrote: > I have tried to follow the guideline but no avail. Can someone just > explain to me what to do in simple terms? > > > Honest Chirozva > Technical Consultant > > > > > > *From: *Francis Guchie > *Sent: *Monday, 26 June 2023 14:28 > *To: *A good place to start for users or folks new to Mifos. > > *Cc: *dev@fineract.apache.org > *Subject: *Re: [Mifos-users] FINERACT PENTAHO > > > > Dear Honest, > > > > Kindly follow the events here ==> > https://github.com/openMF/fineract-pentaho/issues this way we can follow > up on the challenges > > > > > > > > > > My Kind Regards > > > > > > Francis Kirago Guchie > > *Mobile:* > > +232 79 194407 > > +256 70 5011852 > > > > *Skype:* francisguchie > > *twitter*: @francisguchie > > *Telegram: *232 79 19 44 07 > > *Whatsapp: *232 79 19 44 07 > > *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-a4379617/ > > *Website: *https://guchietech.com > > > > > > On Mon, Jun 26, 2023 at 12:07 PM Bharath Gowda wrote: > > Hi Honest. > > + Adding the Mifos community list to this thread as the fineract-pentaho > repo is currently managed under OpenMF Umbrella. > > > > you should be able to add the Pentaho plugin if you follow the > instructions under the readme here > https://github.com/openMF/fineract-pentaho > > > > feel free to post questions in the same thread if you hit any dead ends > during the plugin installation process > > > > > Regards, > > Bharath > > Lead Implementation Analyst | Mifos Initiative > > Skype: live:cbharath4| Mobile: +91.7019635592 > > http://mifos.org <http://facebook.com/mifos> > <http://www.twitter.com/mifos> > > > > > > On Mon, Jun 26, 2023 at 1:27 PM Honest Chirozva > wrote: > > Greetings community, > > > > Can someone guide me on how to build finerect pentaho plugin against the > latest fineract develop branch. > > > > Kind Regards! > > Honest Chirozva > Technical Consultant > > > > Mobile: +263 718 795 908 > Email: hon...@taatconsulting.com > > Web : www.taatconsulting.com > > > > ___ > Mifos-users mailing list > mifos-us...@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > -- *Ed Cable* President/CEO, Mifos Initiative edca...@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: [Mifos-users] FINERACT PENTAHO
I have tried to follow the guideline but no avail. Can someone just explain to me what to do in simple terms? Honest Chirozva Technical Consultant From: Francis Guchie<mailto:francisguc...@gmail.com> Sent: Monday, 26 June 2023 14:28 To: A good place to start for users or folks new to Mifos.<mailto:mifos-us...@lists.sourceforge.net> Cc: dev@fineract.apache.org<mailto:dev@fineract.apache.org> Subject: Re: [Mifos-users] FINERACT PENTAHO Dear Honest, Kindly follow the events here ==> https://github.com/openMF/fineract-pentaho/issues this way we can follow up on the challenges My Kind Regards Francis Kirago Guchie Mobile: +232 79 194407 +256 70 5011852 Skype: francisguchie twitter: @francisguchie Telegram: 232 79 19 44 07 Whatsapp: 232 79 19 44 07 LINKEDIN: https://www.linkedin.com/in/francis-guchie-a4379617/ Website: https://guchietech.com On Mon, Jun 26, 2023 at 12:07 PM Bharath Gowda mailto:bgo...@mifos.org>> wrote: Hi Honest. + Adding the Mifos community list to this thread as the fineract-pentaho repo is currently managed under OpenMF Umbrella. you should be able to add the Pentaho plugin if you follow the instructions under the readme here https://github.com/openMF/fineract-pentaho feel free to post questions in the same thread if you hit any dead ends during the plugin installation process Regards, Bharath Lead Implementation Analyst | Mifos Initiative Skype: live:cbharath4| Mobile: +91.7019635592 http://mifos.org<http://mifos.org/> [https://secure.plimus.com/developers/817570/Template/icon-tiny-facebook.png] <http://facebook.com/mifos> [http://organizationsandmarkets.files.wordpress.com/2010/04/icon-tiny-twitter.png] <http://www.twitter.com/mifos> On Mon, Jun 26, 2023 at 1:27 PM Honest Chirozva mailto:hon...@taatconsulting.com>> wrote: Greetings community, Can someone guide me on how to build finerect pentaho plugin against the latest fineract develop branch. Kind Regards! Honest Chirozva Technical Consultant Mobile: +263 718 795 908 Email: hon...@taatconsulting.com<mailto:hon...@taatconsulting.com> Web : www.taatconsulting.com<https://www.taatconsulting.com/> [cid:188f756e018378dd91d1] ___ Mifos-users mailing list mifos-us...@lists.sourceforge.net<mailto:mifos-us...@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/mifos-users
Re: [Mifos-users] FINERACT PENTAHO
Dear Honest, Kindly follow the events here ==> https://github.com/openMF/fineract-pentaho/issues this way we can follow up on the challenges My Kind Regards Francis Kirago Guchie *Mobile:* +232 79 194407 +256 70 5011852 *Skype:* francisguchie *twitter*: @francisguchie *Telegram: *232 79 19 44 07 *Whatsapp: *232 79 19 44 07 *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-a4379617/ *Website: *https://guchietech.com On Mon, Jun 26, 2023 at 12:07 PM Bharath Gowda wrote: > Hi Honest. > + Adding the Mifos community list to this thread as the fineract-pentaho > repo is currently managed under OpenMF Umbrella. > > you should be able to add the Pentaho plugin if you follow the > instructions under the readme here > https://github.com/openMF/fineract-pentaho > > feel free to post questions in the same thread if you hit any dead ends > during the plugin installation process > > > Regards, > Bharath > Lead Implementation Analyst | Mifos Initiative > Skype: live:cbharath4| Mobile: +91.7019635592 > http://mifos.org <http://facebook.com/mifos> > <http://www.twitter.com/mifos> > > > On Mon, Jun 26, 2023 at 1:27 PM Honest Chirozva > wrote: > >> Greetings community, >> >> >> >> Can someone guide me on how to build finerect pentaho plugin against the >> latest fineract develop branch. >> >> >> >> Kind Regards! >> >> Honest Chirozva >> Technical Consultant >> >> >> >> Mobile: +263 718 795 908 >> Email: hon...@taatconsulting.com >> >> Web : www.taatconsulting.com >> >> >> > ___ > Mifos-users mailing list > mifos-us...@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users >
Re: FINERACT PENTAHO
Hi Honest. + Adding the Mifos community list to this thread as the fineract-pentaho repo is currently managed under OpenMF Umbrella. you should be able to add the Pentaho plugin if you follow the instructions under the readme here https://github.com/openMF/fineract-pentaho feel free to post questions in the same thread if you hit any dead ends during the plugin installation process Regards, Bharath Lead Implementation Analyst | Mifos Initiative Skype: live:cbharath4| Mobile: +91.7019635592 http://mifos.org <http://facebook.com/mifos> <http://www.twitter.com/mifos> On Mon, Jun 26, 2023 at 1:27 PM Honest Chirozva wrote: > Greetings community, > > > > Can someone guide me on how to build finerect pentaho plugin against the > latest fineract develop branch. > > > > Kind Regards! > > Honest Chirozva > Technical Consultant > > > > Mobile: +263 718 795 908 > Email: hon...@taatconsulting.com > > Web : www.taatconsulting.com > > >
FINERACT PENTAHO
Greetings community, Can someone guide me on how to build finerect pentaho plugin against the latest fineract develop branch. Kind Regards! Honest Chirozva Technical Consultant Mobile: +263 718 795 908 Email: hon...@taatconsulting.com<mailto:hon...@taatconsulting.com> Web : www.taatconsulting.com<https://www.taatconsulting.com/> [cid:image001.jpg@01D8982D.B2A11100]
Re: bad pentaho setup
On Sat, 15 Apr 2023 at 00:53, Jorge Antonio Murillo Parraga < jorge.muri...@espam.edu.ec> wrote: > I am reviewing the mifos x application, in the part of pentaho type > reports I cannot configure the plugin to see reports of that type > Latest versions have not been supporting pentaho. You kinda have re-intergrate the service/engine to get them to work -- *MUGABE MAGEZI ARTHUR* Software Developer and Process Management Consultant emails: *artmag...@gmail.com* *atmag...@yahoo.co.uk * Mob: +256704901261 facebook: Magezi Arthur Skype: marthur26 The Struggle the doesn't break you will make you, if you hold a little longer under that fire you will certainly come out as Gold
bad pentaho setup
I am reviewing the mifos x application, in the part of pentaho type reports I cannot configure the plugin to see reports of that type
Mifos 21.07.01 Pentaho Reports
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 <http://www.intrasofttechnologies.com>*
Re: Pentaho Plug-in help
Hi Bharath,
It seems to be an issue with the report query. You can try debugging by
pasting in MySQL workbench of any DB client you are using then update in
the report when you have it working.
If you have difficulties with this, we can maybe schedule a call so I walk
you through it
On Fri, Jun 25, 2021 at 4:07 PM Bharath Gowda wrote:
> Hi Aleks,
> Thank you for your input, adding the JAR file in the WEB-INF/lib folder
> did work.
>
> However, there seems to be a new issue where we are getting the
> error"org.pentaho.reporting.engine.classic.core.ReportDataFactoryException:
> Failed at query:"
>
> Full error message is below.
>
> There is no issue with the Query and the error is consistent for all the
> Pentaho reports, It would be great if anyone could help in analyzing the
> issue at the Fineract code level.
> I will also raise the JIRA ticket for the same
>
> "{"developerMessage":"The request caused a data integrity issue to be
> fired by the
> database.","httpStatusCode":"403","defaultUserMessage":"Pentaho failed:
> Failed at query: \n\n\n\n\n\n select a.name Branch,f.clients,a.
> Disbursed,a.principalpaid,a.intrestpaid,a. principalout,a.intrestout,\n
> a.Amountarres,b.groupcount,c.centercount,d.activeloan,e.areesloan 'no of
> loan arres'\n from\n (select ounder.name,\n \n
> sum(ml.principal_disbursed_derived) Disbursed,\n ounder.id oid,\n
> sum(ml.principal_repaid_derived) principalpaid,\n
> sum(ml.interest_repaid_derived) intrestpaid,\n
> sum(ml.principal_outstanding_derived)
> principalout,\nsum(ml.interest_outstanding_derived)
> intrestout,\nifnull(sum( mlarr.total_overdue_derived),0)
> Amountarres\n\nfrom m_office o\nleft join m_office ounder on
> ounder.hierarchy like concat(o.hierarchy,'%')\n and ounder.hierarchy like
> concat(${userhierarchy},'%')\nleft join m_client mc on mc.office_id=
> ounder.id\nleft join m_loan ml\non
> ml.client_id=mc.id\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\nleft
> join m_loan_arrears_aging mlarr\non mlarr.loan_id=ml.id\nwhere
> mc.status_enum=300 and o.id=1\ngroup by ounder.name) a\n\ninner join
> (select '#group',count(mg2.id) as groupcount,ounder.id oid\nfrom m_office
> o\nleft join m_office ounder on ounder.hierarchy like
> concat(o.hierarchy,'%')\nand ounder.hierarchy like
> concat(${userhierarchy},'%')\n\nleft join m_group mg2 on mg2.office_id=
> ounder.id and mg2.level_id=2\n#where mg2.level_id=2\nwhere o.id=1\ngroup
> by ounder.id) b on b.oid=a.oid\ninner join (select count(mg.id) as
> centercount,ounder.id oid\nfrom m_office o\nleft join m_office ounder on
> ounder.hierarchy like concat(o.hierarchy,'%')\nand ounder.hierarchy like
> concat(${userhierarchy},'%')\n\nleft join m_group mg on mg.office_id=
> ounder.id and mg.level_id=1\n#where mg.level_id=1\nwhere o.id=1\ngroup by
> ounder.id) c on b.oid=c.oid\ninner join (select count(ml.id) activeloan,
> ounder.id oid\nfrom m_office o\nleft join m_office ounder on
> ounder.hierarchy like concat(o.hierarchy,'%')\nand ounder.hierarchy like
> concat(${userhierarchy},'%')\ninner join m_client mc on mc.office_id=
> ounder.id\ninner join m_loan ml on ml.client_id=mc.id\nwhere
> ml.loan_status_id=300 and o.id=1\ngroup by ounder.name\n)d on
> c.oid=d.oid\nleft join (select count(mlarr.loan_id) areesloan, ounder.id
> oid\nfrom m_office o\nleft join m_office ounder on ounder.hierarchy like
> concat(o.hierarchy,'%')\nand ounder.hierarchy like
> concat(${userhierarchy},'%')\nleft join m_client mc on mc.office_id=
> ounder.id\nleft join m_loan ml on ml.client_id=mc.id\nleft join
> m_loan_arrears_aging mlarr on ml.id=mlarr.loan_id\nwhere
> ml.loan_status_id=300\n and o.id=1\ngroup by ounder.name)e on c.oid=e.oid
>\n\ninner join (select count(mc.id) clients, ounder.id
> oid\nfrom m_office o\njoin m_office ounder on ounder.hierarchy like
> concat(o.hierarchy,'%')\nand ounder.hierarchy like
> concat(${userhierarchy},'%')\ninner join m_client mc on mc.office_id=
> ounder.id \nwhere mc.status_enum=300 and o.id=1\ngroup by ounder.name )f
> on b.oid=f.oid\n
>
>
> ","userMessageGlobalisationCode":"error.msg.reporting.error","errors":[{"developerMessage":"Pentaho
> failed: Failed at query: \n\n\n\n\n\n select a.name Branch,f.clients,a.
> Disbursed,a.principalpaid,a.intrestpaid,a. principalout,a.intrestout,\n
> a.Amountarres,b.groupcount,c.centercount,d.activeloan,e.areesloan 'no of
> loan arres'\n from\n (select ounder.name,\n \n
> sum(ml.principal_disbursed_derived) Disbursed,\n ounder.id oid,\n
> sum(ml.principal_repaid_d
Re: Pentaho Plug-in help
Hi Aleks,
Thank you for your input, adding the JAR file in the WEB-INF/lib folder did
work.
However, there seems to be a new issue where we are getting the
error"org.pentaho.reporting.engine.classic.core.ReportDataFactoryException:
Failed at query:"
Full error message is below.
There is no issue with the Query and the error is consistent for all the
Pentaho reports, It would be great if anyone could help in analyzing the
issue at the Fineract code level.
I will also raise the JIRA ticket for the same
"{"developerMessage":"The request caused a data integrity issue to be fired
by the database.","httpStatusCode":"403","defaultUserMessage":"Pentaho
failed: Failed at query: \n\n\n\n\n\n select a.name Branch,f.clients,a.
Disbursed,a.principalpaid,a.intrestpaid,a. principalout,a.intrestout,\n
a.Amountarres,b.groupcount,c.centercount,d.activeloan,e.areesloan 'no of
loan arres'\n from\n (select ounder.name,\n \n
sum(ml.principal_disbursed_derived) Disbursed,\n ounder.id oid,\n
sum(ml.principal_repaid_derived) principalpaid,\n
sum(ml.interest_repaid_derived) intrestpaid,\n
sum(ml.principal_outstanding_derived)
principalout,\nsum(ml.interest_outstanding_derived)
intrestout,\nifnull(sum( mlarr.total_overdue_derived),0)
Amountarres\n\nfrom m_office o\nleft join m_office ounder on
ounder.hierarchy like concat(o.hierarchy,'%')\n and ounder.hierarchy like
concat(${userhierarchy},'%')\nleft join m_client mc on mc.office_id=
ounder.id\nleft join m_loan ml\non
ml.client_id=mc.id\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\nleft
join m_loan_arrears_aging mlarr\non mlarr.loan_id=ml.id\nwhere
mc.status_enum=300 and o.id=1\ngroup by ounder.name) a\n\ninner join
(select '#group',count(mg2.id) as groupcount,ounder.id oid\nfrom m_office
o\nleft join m_office ounder on ounder.hierarchy like
concat(o.hierarchy,'%')\nand ounder.hierarchy like
concat(${userhierarchy},'%')\n\nleft join m_group mg2 on mg2.office_id=
ounder.id and mg2.level_id=2\n#where mg2.level_id=2\nwhere o.id=1\ngroup by
ounder.id) b on b.oid=a.oid\ninner join (select count(mg.id) as
centercount,ounder.id oid\nfrom m_office o\nleft join m_office ounder on
ounder.hierarchy like concat(o.hierarchy,'%')\nand ounder.hierarchy like
concat(${userhierarchy},'%')\n\nleft join m_group mg on mg.office_id=
ounder.id and mg.level_id=1\n#where mg.level_id=1\nwhere o.id=1\ngroup by
ounder.id) c on b.oid=c.oid\ninner join (select count(ml.id) activeloan,
ounder.id oid\nfrom m_office o\nleft join m_office ounder on
ounder.hierarchy like concat(o.hierarchy,'%')\nand ounder.hierarchy like
concat(${userhierarchy},'%')\ninner join m_client mc on mc.office_id=
ounder.id\ninner join m_loan ml on ml.client_id=mc.id\nwhere
ml.loan_status_id=300 and o.id=1\ngroup by ounder.name\n)d on
c.oid=d.oid\nleft join (select count(mlarr.loan_id) areesloan, ounder.id
oid\nfrom m_office o\nleft join m_office ounder on ounder.hierarchy like
concat(o.hierarchy,'%')\nand ounder.hierarchy like
concat(${userhierarchy},'%')\nleft join m_client mc on mc.office_id=
ounder.id\nleft join m_loan ml on ml.client_id=mc.id\nleft join
m_loan_arrears_aging mlarr on ml.id=mlarr.loan_id\nwhere
ml.loan_status_id=300\n and o.id=1\ngroup by ounder.name)e on c.oid=e.oid
\n\ninner join (select count(mc.id) clients, ounder.id oid\nfrom
m_office o\njoin m_office ounder on ounder.hierarchy like
concat(o.hierarchy,'%')\nand ounder.hierarchy like
concat(${userhierarchy},'%')\ninner join m_client mc on mc.office_id=
ounder.id \nwhere mc.status_enum=300 and o.id=1\ngroup by ounder.name )f on
b.oid=f.oid\n
","userMessageGlobalisationCode":"error.msg.reporting.error","errors":[{"developerMessage":"Pentaho
failed: Failed at query: \n\n\n\n\n\n select a.name Branch,f.clients,a.
Disbursed,a.principalpaid,a.intrestpaid,a. principalout,a.intrestout,\n
a.Amountarres,b.groupcount,c.centercount,d.activeloan,e.areesloan 'no of
loan arres'\n from\n (select ounder.name,\n \n
sum(ml.principal_disbursed_derived) Disbursed,\n ounder.id oid,\n
sum(ml.principal_repaid_derived) principalpaid,\n
sum(ml.interest_repaid_derived) intrestpaid,\n
sum(ml.principal_outstanding_derived)
principalout,\nsum(ml.interest_outstanding_derived)
intrestout,\nifnull(sum( mlarr.total_overdue_derived),0)
Amountarres\n\nfrom m_office o\nleft join m_office ounder on
ounder.hierarchy like concat(o.hierarchy,'%')\n and ounder.hierarchy like
concat(${userhierarchy},'%')\nleft join m_client mc on mc.office_id=
ounder.id\nleft join m_loan ml\non
ml.client_id=mc.id\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\nleft
join m_loan_arrears_aging mlarr\non mlarr.loan_id=ml.id\nwhere
mc.status_enum=300 and o.id=1\ngroup by ounder.name) a\n\ninner join
(select '#group',count(
Re: Pentaho Plug-in help
Hi Bharath, ... a bit late to the party, but I'll try to help. As far as I remember the reporting module was tested by Michael with a standalone Fineract JAR (all dependencies packaged in one big JAR... like most Spring Boot applications). If you are able to use/deploy Fineract that way I think that would be easiest; because then you just have to drop the Pentaho module into a folder called "libs" (located in the same parent folder as the Fineract JAR itself; btw: there is a command line parameter that determines the name of that folder... so doesn't need to be called necessarily "libs"; please see the Dockerfile entrypoint). If you have no choice and you need to deploy Fineract as a WAR with a pre-installed Tomcat instance then I think the right way to add Pentaho is to add the JAR file in the WEB-INF/lib folder of the exploded Fineract WAR. Let me know if that helped. Cheers, Aleks On Fri, Jun 4, 2021 at 12:16 PM Bharath Gowda wrote: > Hi Victor, > > Thank you for your email, following are the details > > 1. Tomcat Version is 9.0.38 > 2. Fineract version is 1.5 > 3. Tomcat's jar folder is in '/usr/share/tomcat9/lib' > > Regards, > Bharath > Lead Implementation Analyst | Mifos Initiative > Skype: live:cbharath4| Mobile: +91.7019635592 > http://mifos.org <http://facebook.com/mifos> > <http://www.twitter.com/mifos> > > > On Thu, Jun 3, 2021 at 1:30 PM Laban Kibowen < > laban.kibo...@intrasofttechnologies.com> wrote: > >> Hello Victor >> >> Tomcat Version is 9 >> Fineract version is 1.x presumably 1.4 or 1.5 >> Tomcat's jar folder is in '/usr/share/tomcat9/lib' >> >> *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 >> <http://www.intrasofttechnologies.com>* >> >> >> >> >> >> On Thu, Jun 3, 2021 at 12:51 AM VICTOR MANUEL ROMERO RODRIGUEZ < >> victor.rom...@fintecheando.mx> wrote: >> >>> Hello Bharath, >>> >>> Quick questions? >>> >>> 1. Which is the Tomcat version? >>> 2. Which is the Fineract version? >>> 3. Which is the Tomcat's jar folder? (please share the directory or path) >>> >>> Regards >>> >>> Victor >>> >>> El mié, 2 jun 2021 a las 8:01, Bharath Gowda () >>> escribió: >>> >>>> Hi Michael and all Dev, >>>> >>>> I hope you all are keeping safe and doing well. >>>> >>>> I had tested the Pentaho plugin which Michael had created, and it works >>>> pretty well. >>>> It is a very useful plugin for reporting, thanks to Michael for this >>>> valuable contribution :) >>>> >>>> https://github.com/vorburger/fineract-pentaho >>>> >>>> With inbuilt Pentaho support missing from Fineract, Many organizations >>>> are trying to adopt this plugin into their servers and a lot of requests >>>> are pouring in on how we can get this working through the Tomcat server >>>> along with the "fineract-provider.war" file. >>>> >>>> Tomcat servers are the ideal way of how most of the organizations run >>>> their prod applications, so it would be perfect for production If we can >>>> run the pentaho plug-in in the same server. >>>> >>>> Any person who has any idea on how we can get it working on the tomcat >>>> server along with "fineract-provider.war" please do share it here. >>>> >>>> >>>> I tried to add the 'fineract-pentaho.jar' and other related .jar files >>>> from "fineract-pentaho\build\distributions\lib" to Tomcat's Jar folder, >>>> but it doesn't work. >>>> >>>> >>>> >>>> >>>> >>>> Regards, >>>> Bharath >>>> Lead Implementation Analyst | Mifos Initiative >>>> Skype: live:cbharath4| Mobile: +91.7019635592 >>>> http://mifos.org <http://facebook.com/mifos> >>>> <http://www.twitter.com/mifos> >>>> >>>
Re: Pentaho Plug-in help
Hi Victor, Thank you for your email, following are the details 1. Tomcat Version is 9.0.38 2. Fineract version is 1.5 3. Tomcat's jar folder is in '/usr/share/tomcat9/lib' Regards, Bharath Lead Implementation Analyst | Mifos Initiative Skype: live:cbharath4| Mobile: +91.7019635592 http://mifos.org <http://facebook.com/mifos> <http://www.twitter.com/mifos> On Thu, Jun 3, 2021 at 1:30 PM Laban Kibowen < laban.kibo...@intrasofttechnologies.com> wrote: > Hello Victor > > Tomcat Version is 9 > Fineract version is 1.x presumably 1.4 or 1.5 > Tomcat's jar folder is in '/usr/share/tomcat9/lib' > > *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 <http://www.intrasofttechnologies.com>* > > > > > > On Thu, Jun 3, 2021 at 12:51 AM VICTOR MANUEL ROMERO RODRIGUEZ < > victor.rom...@fintecheando.mx> wrote: > >> Hello Bharath, >> >> Quick questions? >> >> 1. Which is the Tomcat version? >> 2. Which is the Fineract version? >> 3. Which is the Tomcat's jar folder? (please share the directory or path) >> >> Regards >> >> Victor >> >> El mié, 2 jun 2021 a las 8:01, Bharath Gowda () >> escribió: >> >>> Hi Michael and all Dev, >>> >>> I hope you all are keeping safe and doing well. >>> >>> I had tested the Pentaho plugin which Michael had created, and it works >>> pretty well. >>> It is a very useful plugin for reporting, thanks to Michael for this >>> valuable contribution :) >>> >>> https://github.com/vorburger/fineract-pentaho >>> >>> With inbuilt Pentaho support missing from Fineract, Many organizations >>> are trying to adopt this plugin into their servers and a lot of requests >>> are pouring in on how we can get this working through the Tomcat server >>> along with the "fineract-provider.war" file. >>> >>> Tomcat servers are the ideal way of how most of the organizations run >>> their prod applications, so it would be perfect for production If we can >>> run the pentaho plug-in in the same server. >>> >>> Any person who has any idea on how we can get it working on the tomcat >>> server along with "fineract-provider.war" please do share it here. >>> >>> >>> I tried to add the 'fineract-pentaho.jar' and other related .jar files >>> from "fineract-pentaho\build\distributions\lib" to Tomcat's Jar folder, >>> but it doesn't work. >>> >>> >>> >>> >>> >>> Regards, >>> Bharath >>> Lead Implementation Analyst | Mifos Initiative >>> Skype: live:cbharath4| Mobile: +91.7019635592 >>> http://mifos.org <http://facebook.com/mifos> >>> <http://www.twitter.com/mifos> >>> >>
Re: Pentaho Plug-in help
Hello Victor Tomcat Version is 9 Fineract version is 1.x presumably 1.4 or 1.5 Tomcat's jar folder is in '/usr/share/tomcat9/lib' *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 <http://www.intrasofttechnologies.com>* On Thu, Jun 3, 2021 at 12:51 AM VICTOR MANUEL ROMERO RODRIGUEZ < victor.rom...@fintecheando.mx> wrote: > Hello Bharath, > > Quick questions? > > 1. Which is the Tomcat version? > 2. Which is the Fineract version? > 3. Which is the Tomcat's jar folder? (please share the directory or path) > > Regards > > Victor > > El mié, 2 jun 2021 a las 8:01, Bharath Gowda () > escribió: > >> Hi Michael and all Dev, >> >> I hope you all are keeping safe and doing well. >> >> I had tested the Pentaho plugin which Michael had created, and it works >> pretty well. >> It is a very useful plugin for reporting, thanks to Michael for this >> valuable contribution :) >> >> https://github.com/vorburger/fineract-pentaho >> >> With inbuilt Pentaho support missing from Fineract, Many organizations >> are trying to adopt this plugin into their servers and a lot of requests >> are pouring in on how we can get this working through the Tomcat server >> along with the "fineract-provider.war" file. >> >> Tomcat servers are the ideal way of how most of the organizations run >> their prod applications, so it would be perfect for production If we can >> run the pentaho plug-in in the same server. >> >> Any person who has any idea on how we can get it working on the tomcat >> server along with "fineract-provider.war" please do share it here. >> >> >> I tried to add the 'fineract-pentaho.jar' and other related .jar files >> from "fineract-pentaho\build\distributions\lib" to Tomcat's Jar folder, >> but it doesn't work. >> >> >> >> >> >> Regards, >> Bharath >> Lead Implementation Analyst | Mifos Initiative >> Skype: live:cbharath4| Mobile: +91.7019635592 >> http://mifos.org <http://facebook.com/mifos> >> <http://www.twitter.com/mifos> >> >
Re: Pentaho Plug-in help
Hello Bharath, Quick questions? 1. Which is the Tomcat version? 2. Which is the Fineract version? 3. Which is the Tomcat's jar folder? (please share the directory or path) Regards Victor El mié, 2 jun 2021 a las 8:01, Bharath Gowda () escribió: > Hi Michael and all Dev, > > I hope you all are keeping safe and doing well. > > I had tested the Pentaho plugin which Michael had created, and it works > pretty well. > It is a very useful plugin for reporting, thanks to Michael for this > valuable contribution :) > > https://github.com/vorburger/fineract-pentaho > > With inbuilt Pentaho support missing from Fineract, Many organizations are > trying to adopt this plugin into their servers and a lot of requests are > pouring in on how we can get this working through the Tomcat server along > with the "fineract-provider.war" file. > > Tomcat servers are the ideal way of how most of the organizations run > their prod applications, so it would be perfect for production If we can > run the pentaho plug-in in the same server. > > Any person who has any idea on how we can get it working on the tomcat > server along with "fineract-provider.war" please do share it here. > > > I tried to add the 'fineract-pentaho.jar' and other related .jar files > from "fineract-pentaho\build\distributions\lib" to Tomcat's Jar folder, > but it doesn't work. > > > > > > Regards, > Bharath > Lead Implementation Analyst | Mifos Initiative > Skype: live:cbharath4| Mobile: +91.7019635592 > http://mifos.org <http://facebook.com/mifos> > <http://www.twitter.com/mifos> >
Pentaho Plug-in help
Hi Michael and all Dev, I hope you all are keeping safe and doing well. I had tested the Pentaho plugin which Michael had created, and it works pretty well. It is a very useful plugin for reporting, thanks to Michael for this valuable contribution :) https://github.com/vorburger/fineract-pentaho With inbuilt Pentaho support missing from Fineract, Many organizations are trying to adopt this plugin into their servers and a lot of requests are pouring in on how we can get this working through the Tomcat server along with the "fineract-provider.war" file. Tomcat servers are the ideal way of how most of the organizations run their prod applications, so it would be perfect for production If we can run the pentaho plug-in in the same server. Any person who has any idea on how we can get it working on the tomcat server along with "fineract-provider.war" please do share it here. I tried to add the 'fineract-pentaho.jar' and other related .jar files from "fineract-pentaho\build\distributions\lib" to Tomcat's Jar folder, but it doesn't work. Regards, Bharath Lead Implementation Analyst | Mifos Initiative Skype: live:cbharath4| Mobile: +91.7019635592 http://mifos.org <http://facebook.com/mifos> <http://www.twitter.com/mifos>
Re: [Mifos-developer] Support for Pentaho for Mifos Latest build
Dear All I tried to incorporate a pentaho report to my fineract local repository based on the PR sent by Francis Guchie . Having run the fineract engine, I tried to open trial balance from community app. I got the following error stacktrace. I am looking for help org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: select -1 as id,'All' as name union select id,name from m_office at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:258) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:171) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:434) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:326) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.parameters.DefaultListParameter.getValues(DefaultListParameter.java:119) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator.computeValidListValue(DefaultReportParameterValidator.java:318) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator.validateSingleParameter(DefaultReportParameterValidator.java:256) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator.validate(DefaultReportParameterValidator.java:140) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:183) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:477) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1647) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.pentaho.reporting.engine.classic.core.modules.output.table.html.HtmlReportUtil.createStreamHTML(HtmlReportUtil.java:111) ~[pentaho-reporting-engine-classic-core-3.9.1.1.jar:3.9.1.1.16408] at org.apache.fineract.infrastructure.report.service.PentahoReportingProcessServiceImpl.processRequest(PentahoReportingProcessServiceImpl.java:149) ~[main/:na] at org.apache.fineract.infrastructure.dataqueries.api.RunreportsApiResource.runReport(RunreportsApiResource.java:128) ~[main/:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na] at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na] at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[jersey-server-1.19.4.jar:1.19.4] at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) ~[jersey-server-1.19.4.jar:
Latest pentaho reports
Hello, We are trying to get the pentaho reports working with the latest fineract but the reports are showing a blank screen with parameter not valid error. Has anyone managed to do this and how? Regards, Samuel Ngoda
Re: [Mifos-developer] Support for Pentaho for Mifos Latest build
Well done and thank you for sharing @Francis On Thu, 20 Aug 2020 at 21:21, Francis Guchie wrote: > Dear Ed, > > I think this thread has reached its peaceful end. Thank you for the > support > > > 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, Aug 20, 2020 at 6:19 PM Francis Guchie > wrote: > >> Dear All, >> >> For all those interested in using pentaho reports in the latest build, >> please note the following >> >>1. follow the discussion here >> >> >> >>https://github.com/apache/fineract/pull/1262 >>2. Fineract will not ship with Pentaho reports and thus whoever wants >>to use them can add them on their own you can use the branch >>https://github.com/francisguchie/fineract/tree/pentahoReports at an >>individual Basis (I hope i am not violating any rules by sharing this) >>3. If you choose to go Pentaho, below are my findings >> 1. tomcat 9.0.37 or above will be your best choice as i tried >> 9.036 and 9.035 and i was having errors displaying the reports >> 2. if you have tomcat 9.0.3x and you do not wish to redo your >> work, you can simply use the jar files in the lib folder of tomcat >> 9.0.37 >> it worked for me on a tomcat9.0.35 >>4. I have test this on a windows PC and Ubuntu 18.04 Lts and i am >>happy with the results >> 1. Pentaho Reports with names that have no SQL keys words, special >> characters and operands work well >> 1. Examples of these are words like Select, AND, characters >> like -, * ( will display and sql inject error when a user is trying >> to add >> the report >> >> Enjoy >> >> >> 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, Aug 20, 2020 at 12:36 AM Francis Guchie >> wrote: >> >>> Petri, Luis and all >>> >>> Thank you for the advise, I have managed to Raise the PR here >>> https://github.com/apache/fineract/pull/1262 >>> >>> Next Steps >>> >>>- Making sure the reports with no errors load ( *When i use my >>>Windows PC, this works very well - reports with "non-bad Names" and those >>>with no data integrity issues are displayed *) I am still trying to >>>figure out why this is not the same for Ubuntu 18.04 LTS >>>- Making Corrections of the Names and editing errors in all / a good >>>number of Pentaho Reports >>> >>> For now i can gladly wait for reviewers of the PR i have raised - as i >>> see -- All checks have passed >>> >>> >>> >>> 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 8:22 PM Francis Guchie >>> wrote: >>> >>>> Petri, >>>> >>>> No I have not tried this. Let me try it and let you know. >>>> >>>> >>>> >>>> >>>> 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, 15:18 Ed Cable wrote: >>>> >>>>> Thanks Petri. Sorry that I had duplicated Francis' thread. >>>>> >>>>> Ed >>>>> >>>>> On Tue, Aug 18, 2020 at 8:13 AM Petri Tuomola >>>>> wrote: >>>>> >>>>>> Hi Francis >>>>>> >>>>>> If this is a valid and harmless duplicate (i.e. all the JARs include >>>>>> "overview.html" but that d
Re: [Mifos-developer] Support for Pentaho for Mifos Latest build
Dear Ed, I think this thread has reached its peaceful end. Thank you for the support 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, Aug 20, 2020 at 6:19 PM Francis Guchie wrote: > Dear All, > > For all those interested in using pentaho reports in the latest build, > please note the following > >1. follow the discussion here >https://github.com/apache/fineract/pull/1262 >2. Fineract will not ship with Pentaho reports and thus whoever wants >to use them can add them on their own you can use the branch >https://github.com/francisguchie/fineract/tree/pentahoReports at an >individual Basis (I hope i am not violating any rules by sharing this) >3. If you choose to go Pentaho, below are my findings > 1. tomcat 9.0.37 or above will be your best choice as i tried > 9.036 and 9.035 and i was having errors displaying the reports > 2. if you have tomcat 9.0.3x and you do not wish to redo your work, > you can simply use the jar files in the lib folder of tomcat 9.0.37 it > worked for me on a tomcat9.0.35 >4. I have test this on a windows PC and Ubuntu 18.04 Lts and i am >happy with the results > 1. Pentaho Reports with names that have no SQL keys words, special > characters and operands work well > 1. Examples of these are words like Select, AND, characters like > -, * ( will display and sql inject error when a user is trying to > add the > report > > Enjoy > > > 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, Aug 20, 2020 at 12:36 AM Francis Guchie > wrote: > >> Petri, Luis and all >> >> Thank you for the advise, I have managed to Raise the PR here >> https://github.com/apache/fineract/pull/1262 >> >> Next Steps >> >>- Making sure the reports with no errors load ( *When i use my >>Windows PC, this works very well - reports with "non-bad Names" and those >>with no data integrity issues are displayed *) I am still trying to >>figure out why this is not the same for Ubuntu 18.04 LTS >>- Making Corrections of the Names and editing errors in all / a good >>number of Pentaho Reports >> >> For now i can gladly wait for reviewers of the PR i have raised - as i >> see -- All checks have passed >> >> >> >> 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 8:22 PM Francis Guchie >> wrote: >> >>> Petri, >>> >>> No I have not tried this. Let me try it and let you know. >>> >>> >>> >>> >>> 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, 15:18 Ed Cable wrote: >>> >>>> Thanks Petri. Sorry that I had duplicated Francis' thread. >>>> >>>> Ed >>>> >>>> On Tue, Aug 18, 2020 at 8:13 AM Petri Tuomola >>>> wrote: >>>> >>>>> 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, Aug 18, 2020 at 1:09 PM Francis Guchie < >>>>> francisguc...@gmail.com> wrote: >>>>> >>>>>> Dear All, >>>>>&
Re: [Mifos-developer] Support for Pentaho for Mifos Latest build
Dear All, For all those interested in using pentaho reports in the latest build, please note the following 1. follow the discussion here https://github.com/apache/fineract/pull/1262 2. Fineract will not ship with Pentaho reports and thus whoever wants to use them can add them on their own you can use the branch https://github.com/francisguchie/fineract/tree/pentahoReports at an individual Basis (I hope i am not violating any rules by sharing this) 3. If you choose to go Pentaho, below are my findings 1. tomcat 9.0.37 or above will be your best choice as i tried 9.036 and 9.035 and i was having errors displaying the reports 2. if you have tomcat 9.0.3x and you do not wish to redo your work, you can simply use the jar files in the lib folder of tomcat 9.0.37 it worked for me on a tomcat9.0.35 4. I have test this on a windows PC and Ubuntu 18.04 Lts and i am happy with the results 1. Pentaho Reports with names that have no SQL keys words, special characters and operands work well 1. Examples of these are words like Select, AND, characters like -, * ( will display and sql inject error when a user is trying to add the report Enjoy 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, Aug 20, 2020 at 12:36 AM Francis Guchie wrote: > Petri, Luis and all > > Thank you for the advise, I have managed to Raise the PR here > https://github.com/apache/fineract/pull/1262 > > Next Steps > >- Making sure the reports with no errors load ( *When i use my Windows >PC, this works very well - reports with "non-bad Names" and those with no >data integrity issues are displayed *) I am still trying to figure >out why this is not the same for Ubuntu 18.04 LTS >- Making Corrections of the Names and editing errors in all / a good >number of Pentaho Reports > > For now i can gladly wait for reviewers of the PR i have raised - as i > see -- All checks have passed > > > > 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 8:22 PM Francis Guchie > wrote: > >> Petri, >> >> No I have not tried this. Let me try it and let you know. >> >> >> >> >> 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, 15:18 Ed Cable wrote: >> >>> Thanks Petri. Sorry that I had duplicated Francis' thread. >>> >>> Ed >>> >>> On Tue, Aug 18, 2020 at 8:13 AM Petri Tuomola wrote: >>> >>>> 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, Aug 18, 2020 at 1:09 PM Francis Guchie >>>> wrote: >>>> >>>>> Dear All, >>>>> >>>>> We would like to see Pentaho Reports available in the next release. >>>>> Support for Pentaho was discontinued due to License issues (Personally i >>>>> don't know how the license issues affect as no details where provided >>>>> where >>>>> i read this note) >>>>> >>>>> At the moment MifosX is compatible with Pentaho 3.9.1-GA / 3.9.1.1 >>>>> >>>>> Luis and I have tried to add Pentaho Reports into the latest build and >>>>> here are our branches mine >>>>> https://github.com/francisguchie/fineract/tree/supportPentahoReports and >>>>> that of Luis >>>>> https://github.com/luisalegria/fineract-1/tree/19.14Pentaho >>>>> >>>>> In both cases, using the following environments on a Windows 10 Ent- >>>>> 64bit
Re: [Mifos-developer] Support for Pentaho for Mifos Latest build
Petri, Luis and all Thank you for the advise, I have managed to Raise the PR here https://github.com/apache/fineract/pull/1262 Next Steps - Making sure the reports with no errors load ( *When i use my Windows PC, this works very well - reports with "non-bad Names" and those with no data integrity issues are displayed *) I am still trying to figure out why this is not the same for Ubuntu 18.04 LTS - Making Corrections of the Names and editing errors in all / a good number of Pentaho Reports For now i can gladly wait for reviewers of the PR i have raised - as i see -- All checks have passed 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 8:22 PM Francis Guchie wrote: > Petri, > > No I have not tried this. Let me try it and let you know. > > > > > 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, 15:18 Ed Cable wrote: > >> Thanks Petri. Sorry that I had duplicated Francis' thread. >> >> Ed >> >> On Tue, Aug 18, 2020 at 8:13 AM Petri Tuomola wrote: >> >>> 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, Aug 18, 2020 at 1:09 PM Francis Guchie >>> wrote: >>> >>>> Dear All, >>>> >>>> We would like to see Pentaho Reports available in the next release. >>>> Support for Pentaho was discontinued due to License issues (Personally i >>>> don't know how the license issues affect as no details where provided where >>>> i read this note) >>>> >>>> At the moment MifosX is compatible with Pentaho 3.9.1-GA / 3.9.1.1 >>>> >>>> Luis and I have tried to add Pentaho Reports into the latest build and >>>> here are our branches mine >>>> https://github.com/francisguchie/fineract/tree/supportPentahoReports and >>>> that of Luis >>>> https://github.com/luisalegria/fineract-1/tree/19.14Pentaho >>>> >>>> In both cases, using the following environments on a Windows 10 Ent- >>>> 64bit PC >>>> >>>>1. gradle 6.5.1 >>>>2. Jdk 11.0.8 >>>>3. node v14.4.0 >>>>4. npm v 6.14.5 >>>>5. kotlin 1.3.72 >>>>6. groovy 2.5.11 >>>> >>>> >>>> when i run ./gradlew clean build (one of the conditions to be checked >>>> before a PR is raised) I do get the error 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 >>>> >&
Re: Classpath Errors when attempting to run Pentaho on latest Fineract
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 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 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, wrote: >> >>> Hi all, >>> >>> Just re-naming this thread and bumping to the top as it's @Luis Alberto >>> Alegría de los Santos and @Francis Guchie >>> 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 @manthansur...@gmail.com >>> @Yemdjih Kaze Nasser >>> @percyayuka...@gmail.com Any time to look >>> into helping resolve the issues? >>> >>> Thanks, >>> >>> Ed >>> >>> -- Forwarded message - >>> From: Francis Guchie >>> 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 >>> Cc: Luis Alberto Alegría de los Santos , >>> Edwin Nchia , Bharath Gowda >>> >>> >>> >>> 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 >>> 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-r
Re: Classpath Errors when attempting to run Pentaho on latest Fineract
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 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, wrote: > >> Hi all, >> >> Just re-naming this thread and bumping to the top as it's @Luis Alberto >> Alegría de los Santos and @Francis Guchie >> 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 @manthansur...@gmail.com >> @Yemdjih Kaze Nasser >> @percyayuka...@gmail.com Any time to look into >> helping resolve the issues? >> >> Thanks, >> >> Ed >> >> -- Forwarded message - >> From: Francis Guchie >> 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 >> Cc: Luis Alberto Alegría de los Santos , Edwin >> Nchia , Bharath Gowda >> >> >> >> 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 >> 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/24114228757a9325f4b4e48
Re: [Mifos-developer] Support for Pentaho for Mifos Latest build
Petri, No I have not tried this. Let me try it and let you know. 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, 15:18 Ed Cable wrote: > Thanks Petri. Sorry that I had duplicated Francis' thread. > > Ed > > On Tue, Aug 18, 2020 at 8:13 AM Petri Tuomola wrote: > >> 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, Aug 18, 2020 at 1:09 PM Francis Guchie >> wrote: >> >>> Dear All, >>> >>> We would like to see Pentaho Reports available in the next release. >>> Support for Pentaho was discontinued due to License issues (Personally i >>> don't know how the license issues affect as no details where provided where >>> i read this note) >>> >>> At the moment MifosX is compatible with Pentaho 3.9.1-GA / 3.9.1.1 >>> >>> Luis and I have tried to add Pentaho Reports into the latest build and >>> here are our branches mine >>> https://github.com/francisguchie/fineract/tree/supportPentahoReports and >>> that of Luis >>> https://github.com/luisalegria/fineract-1/tree/19.14Pentaho >>> >>> In both cases, using the following environments on a Windows 10 Ent- >>> 64bit PC >>> >>>1. gradle 6.5.1 >>>2. Jdk 11.0.8 >>>3. node v14.4.0 >>>4. npm v 6.14.5 >>>5. kotlin 1.3.72 >>>6. groovy 2.5.11 >>> >>> >>> when i run ./gradlew clean build (one of the conditions to be checked >>> before a PR is raised) I do get the error 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/60a57221b2f5b3ac5e8822
Re: Support for Pentaho for Mifos Latest build
Thanks Petri. Sorry that I had duplicated Francis' thread. Ed On Tue, Aug 18, 2020 at 8:13 AM Petri Tuomola wrote: > 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, Aug 18, 2020 at 1:09 PM Francis Guchie > wrote: > >> Dear All, >> >> We would like to see Pentaho Reports available in the next release. >> Support for Pentaho was discontinued due to License issues (Personally i >> don't know how the license issues affect as no details where provided where >> i read this note) >> >> At the moment MifosX is compatible with Pentaho 3.9.1-GA / 3.9.1.1 >> >> Luis and I have tried to add Pentaho Reports into the latest build and >> here are our branches mine >> https://github.com/francisguchie/fineract/tree/supportPentahoReports and >> that of Luis https://github.com/luisalegria/fineract-1/tree/19.14Pentaho >> >> >> In both cases, using the following environments on a Windows 10 Ent- >> 64bit PC >> >>1. gradle 6.5.1 >>2. Jdk 11.0.8 >>3. node v14.4.0 >>4. npm v 6.14.5 >>5. kotlin 1.3.72 >>6. groovy 2.5.11 >> >> >> when i run ./gradlew clean build (one of the conditions to be checked >> before a PR is raised) I do get the error 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 >> >> >> I need help on this jarHell 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 >> >> >> >> >> >> >> >> -- *Ed Cable* President/CEO, Mifos Initiative edca...@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
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 wrote: > Hi all, > > Just re-naming this thread and bumping to the top as it's @Luis Alberto > Alegría de los Santos and @Francis Guchie > 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 @manthansur...@gmail.com > @Yemdjih Kaze Nasser > @percyayuka...@gmail.com Any time to look into > helping resolve the issues? > > Thanks, > > Ed > > -- Forwarded message - > From: Francis Guchie > 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 > Cc: Luis Alberto Alegría de los Santos , Edwin > Nchia , Bharath Gowda > > > > 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 > 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/60a57221b2f5b3ac5e8822bf14001640738a
Re: Classpath Errors when attempting to run Pentaho on latest Fineract
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, wrote: > Hi all, > > Just re-naming this thread and bumping to the top as it's @Luis Alberto > Alegría de los Santos and @Francis Guchie > 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 @manthansur...@gmail.com > @Yemdjih Kaze Nasser > @percyayuka...@gmail.com Any time to look into > helping resolve the issues? > > Thanks, > > Ed > > -- Forwarded message - > From: Francis Guchie > 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 > Cc: Luis Alberto Alegría de los Santos , Edwin > Nchia , Bharath Gowda > > > > 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 > 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
Re: Support for Pentaho for Mifos Latest build
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, Aug 18, 2020 at 1:09 PM Francis Guchie wrote: > Dear All, > > We would like to see Pentaho Reports available in the next release. > Support for Pentaho was discontinued due to License issues (Personally i > don't know how the license issues affect as no details where provided where > i read this note) > > At the moment MifosX is compatible with Pentaho 3.9.1-GA / 3.9.1.1 > > Luis and I have tried to add Pentaho Reports into the latest build and > here are our branches mine > https://github.com/francisguchie/fineract/tree/supportPentahoReports and > that of Luis https://github.com/luisalegria/fineract-1/tree/19.14Pentaho > > > In both cases, using the following environments on a Windows 10 Ent- > 64bit PC > >1. gradle 6.5.1 >2. Jdk 11.0.8 >3. node v14.4.0 >4. npm v 6.14.5 >5. kotlin 1.3.72 >6. groovy 2.5.11 > > > when i run ./gradlew clean build (one of the conditions to be checked > before a PR is raised) I do get the error 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 > > > I need help on this jarHell 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 > > > > > > > >
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 and @Francis Guchie 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 @manthansur...@gmail.com @Yemdjih Kaze Nasser @percyayuka...@gmail.com Any time to look into helping resolve the issues? Thanks, Ed -- Forwarded message - From: Francis Guchie 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 Cc: Luis Alberto Alegría de los Santos , Edwin Nchia , Bharath Gowda 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 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 > 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 che
Support for Pentaho for Mifos Latest build
Dear All, We would like to see Pentaho Reports available in the next release. Support for Pentaho was discontinued due to License issues (Personally i don't know how the license issues affect as no details where provided where i read this note) At the moment MifosX is compatible with Pentaho 3.9.1-GA / 3.9.1.1 Luis and I have tried to add Pentaho Reports into the latest build and here are our branches mine https://github.com/francisguchie/fineract/tree/supportPentahoReports and that of Luis https://github.com/luisalegria/fineract-1/tree/19.14Pentaho In both cases, using the following environments on a Windows 10 Ent- 64bit PC 1. gradle 6.5.1 2. Jdk 11.0.8 3. node v14.4.0 4. npm v 6.14.5 5. kotlin 1.3.72 6. groovy 2.5.11 when i run ./gradlew clean build (one of the conditions to be checked before a PR is raised) I do get the error 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 I need help on this jarHell 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
Re: Fineract Dev Pentaho Reports Issue Discussion
Hi all,
Interesting topic. I think older Pentaho versions were GNU Lesser General
Public License and now it's Pentaho Reporting Enterprise Edition license.
Functionality-wise, we are primarily exploring Redash (other than
visualization what report designing capabilities it has) for going
forward. Redash has BSD 2-Clause "Simplified" License.
Superset is also on our radar in terms of familiarity and Apache license.
With best regards,
Avik.
ᐧ
On Tue, Jun 30, 2020 at 7:40 PM Luis Alberto Alegría de los Santos
wrote:
> Hi all
>
> Ed, is it possible for an IF to compile fineract with pentaho support by
> themselves, without infringing licenses?
>
> If this is possible I could do a guide, I have done some tests to support
> pentaho to fineract 1.2 and I was able to compile the code with class
> "PentahoReportingProcessServiceImpl.java". I am not done yet, I need to
> debug the code and do more tests, at this moment it still does not work,
> however with the help of the most experienced developers I think it is
> possible.
>
> I think that being able to access the reports from the MIFOS X itself is
> something that gives added value and makes the operation easier for end
> users. And if there are no problems with the licenses, it is worth it to be
> able to use the 95 pentaho reports that exist, as well as the ones that the
> FIs could have created.
>
> Best regards
>
> El mar., 30 jun. 2020 a las 2:38, Ankit Muellner ()
> escribió:
>
>> Hey Bharat, Thanks for putting together this thread.
>> As Saransh pointed out, not only integration of Pentaho with latest
>> versions started extinguishing, I have noticed that this Pentaho
>> integration misses out a lot more requirements.
>>
>> *3.* Clearly, a new external open solution needs to be integrated
>> because of the following scenarios:
>> a.) No ability for generating an external feed of reporting which many
>> FIs wish to use to report to their different Information Systems. I am
>> talking about file interchange format feeds. (CSV, excel is a limited
>> function.)
>> b.) Reports are not highly configurable as we promise with Pentaho. Of
>> Course, those with SQL knowhow can customize them. But somehow we have
>> missed out the aspect of this for non technical functional experts
>> routinely managing the system configuration of Fineract via community app.
>> Pentaho does not help in this direction.
>> c.) There is no user level encryption of the reports getting fired and up
>> for download, also at API level.(which of course can be extended & executed)
>> d.) The direct end points of granular level reporting(e.g accounting
>> reports in pentaho) are again missing which is increasingly becoming a
>> standard point of Financial reporting. e.g if an FI wishes to push their
>> portfolio reporting for an external securitization or better if Risk
>> reporting solutions need to be embedded, Pentaho does not support this to
>> the extent of 2020 level reporting.
>>
>> I would be happy to point a functional specification on a Jira Issue.
>> Prior to that, I am looking for a technical conversation of feasibility on
>> this thread.
>>
>> On Tue, Jun 30, 2020 at 9:22 AM Bharath Gowda wrote:
>>
>>> Hello Everyone,
>>>
>>> Initiating this thread to understand and discuss a solution for the
>>> Pentaho reporting issues which has surfaced recently.
>>>
>>> 1. From which version, Fineract has stopped supporting Pentaho due to
>>> Licencing issues?
>>> 2. When we run a Pentaho report on Develop version, we get an sql
>>> injection error like below, Will it be appropriate to raise an issue to
>>> handle the pentaho errors (if it is due to the licence support issue) which
>>> will help the users to understand better?
>>>
>>> {"developerMessage":"The request was invalid. This typically will happen
>>> due to validation errors which are
>>> provided.","httpStatusCode":"400","defaultUserMessage":"Unexpected SQL
>>> Commands
>>> found","userMessageGlobalisationCode":"error.msg.found.sql.injection
>>>
>>> 3. Should we discuss an alternate solution for this? Our stretchy
>>> reports have limitations, many value added reports (with design and
>>> calculations) will not work with stretchy reports.
>>>
>>> From an organization users perspective, this might become a bottleneck
>>> for their End/Beginning of the Day/Month/Year Business Reconciliations.
>>>
>>>
>>>
>>>
Re: Fineract Dev Pentaho Reports Issue Discussion
Hi all
Ed, is it possible for an IF to compile fineract with pentaho support by
themselves, without infringing licenses?
If this is possible I could do a guide, I have done some tests to support
pentaho to fineract 1.2 and I was able to compile the code with class
"PentahoReportingProcessServiceImpl.java". I am not done yet, I need to
debug the code and do more tests, at this moment it still does not work,
however with the help of the most experienced developers I think it is
possible.
I think that being able to access the reports from the MIFOS X itself is
something that gives added value and makes the operation easier for end
users. And if there are no problems with the licenses, it is worth it to be
able to use the 95 pentaho reports that exist, as well as the ones that the
FIs could have created.
Best regards
El mar., 30 jun. 2020 a las 2:38, Ankit Muellner ()
escribió:
> Hey Bharat, Thanks for putting together this thread.
> As Saransh pointed out, not only integration of Pentaho with latest
> versions started extinguishing, I have noticed that this Pentaho
> integration misses out a lot more requirements.
>
> *3.* Clearly, a new external open solution needs to be integrated because
> of the following scenarios:
> a.) No ability for generating an external feed of reporting which many FIs
> wish to use to report to their different Information Systems. I am talking
> about file interchange format feeds. (CSV, excel is a limited function.)
> b.) Reports are not highly configurable as we promise with Pentaho. Of
> Course, those with SQL knowhow can customize them. But somehow we have
> missed out the aspect of this for non technical functional experts
> routinely managing the system configuration of Fineract via community app.
> Pentaho does not help in this direction.
> c.) There is no user level encryption of the reports getting fired and up
> for download, also at API level.(which of course can be extended & executed)
> d.) The direct end points of granular level reporting(e.g accounting
> reports in pentaho) are again missing which is increasingly becoming a
> standard point of Financial reporting. e.g if an FI wishes to push their
> portfolio reporting for an external securitization or better if Risk
> reporting solutions need to be embedded, Pentaho does not support this to
> the extent of 2020 level reporting.
>
> I would be happy to point a functional specification on a Jira Issue.
> Prior to that, I am looking for a technical conversation of feasibility on
> this thread.
>
> On Tue, Jun 30, 2020 at 9:22 AM Bharath Gowda wrote:
>
>> Hello Everyone,
>>
>> Initiating this thread to understand and discuss a solution for the
>> Pentaho reporting issues which has surfaced recently.
>>
>> 1. From which version, Fineract has stopped supporting Pentaho due to
>> Licencing issues?
>> 2. When we run a Pentaho report on Develop version, we get an sql
>> injection error like below, Will it be appropriate to raise an issue to
>> handle the pentaho errors (if it is due to the licence support issue) which
>> will help the users to understand better?
>>
>> {"developerMessage":"The request was invalid. This typically will happen
>> due to validation errors which are
>> provided.","httpStatusCode":"400","defaultUserMessage":"Unexpected SQL
>> Commands
>> found","userMessageGlobalisationCode":"error.msg.found.sql.injection
>>
>> 3. Should we discuss an alternate solution for this? Our stretchy reports
>> have limitations, many value added reports (with design and calculations)
>> will not work with stretchy reports.
>>
>> From an organization users perspective, this might become a bottleneck
>> for their End/Beginning of the Day/Month/Year Business Reconciliations.
>>
>>
>>
>> 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, Jun 30, 2020 at 12:02 AM Saransh Sharma
>> wrote:
>>
>>> Currently fineract does not support Pentaho reports due to Licensing
>>> issues.
>>>
>>> You can use or integrate some oss version of reporting engine if you
>>> want.
>>>
>>> Thanks
>>>
>>> Though Inbuilt Sql based reporting is also quite usable and powerful.
>>>
>>> On Mon, 29 Jun 2020, 23:11 Kalanzi Vincent,
>>> wrote:
>>>
>>>> Hello Dev
>>>>
>>>> I have an instance running locally from the latest
Re: Fineract Dev Pentaho Reports
I tried integrating with Fineract 1.x , the large difference is the Sql driver and when making a request using current fineract sql driver it fails need to be debugged. BIRT is something worth integrating. We should discuss this ideally around fineract CN also. Thanks On Tue, Jun 30, 2020 at 10:22 AM Airsay Longcon wrote: > Thank you for your response on this. I'm aware Mifos 18.03.01 has Pentaho > integrated. How did they accomplish this? Or is this something that cannot > be discussed here? Also what other OSS reporting tools are known to work > with Fineract and how do we integrate them? > > Easy Reporting is a key deal breaker for the client I'm evaluating > Fineract for > > Sent from my iPhone > > On 29 Jun 2020, at 19:25, Saransh Sharma wrote: > > > Currently fineract does not support Pentaho reports due to Licensing > issues. > > You can use or integrate some oss version of reporting engine if you want. > > Thanks > > Though Inbuilt Sql based reporting is also quite usable and powerful. > > On Mon, 29 Jun 2020, 23:11 Kalanzi Vincent, > wrote: > >> Hello Dev >> >> I have an instance running locally from the latest fineract repository >> and also have accessed dev.mifos.io >> >> In both cases the Pentaho Reports show blank white screen. Am asking for >> guidance on how to utilize Pentaho Reports on fineract >> https://github.com/apache/fineract >> >> Kind Regards. >> > -- Thanks and regards, Saransh Sharma Research Partner This mail is governed by Muellners® IT policy. The information contained in this e-mail and any accompanying documents may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message, including any attachments. Any dissemination, distribution or other use of the contents of this message by anyone other than the intended recipient is strictly prohibited. All messages sent to and from this e-mail address may be monitored as permitted by applicable law and regulations to ensure compliance with our internal policies and to protect our business. E-mails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, lost or destroyed, or contain viruses. You are deemed to have accepted these risks if you communicate with us by e-mail.
Re: Fineract Dev Pentaho Reports Issue Discussion
Hey Bharat, Thanks for putting together this thread.
As Saransh pointed out, not only integration of Pentaho with latest
versions started extinguishing, I have noticed that this Pentaho
integration misses out a lot more requirements.
*3.* Clearly, a new external open solution needs to be integrated because
of the following scenarios:
a.) No ability for generating an external feed of reporting which many FIs
wish to use to report to their different Information Systems. I am talking
about file interchange format feeds. (CSV, excel is a limited function.)
b.) Reports are not highly configurable as we promise with Pentaho. Of
Course, those with SQL knowhow can customize them. But somehow we have
missed out the aspect of this for non technical functional experts
routinely managing the system configuration of Fineract via community app.
Pentaho does not help in this direction.
c.) There is no user level encryption of the reports getting fired and up
for download, also at API level.(which of course can be extended & executed)
d.) The direct end points of granular level reporting(e.g accounting
reports in pentaho) are again missing which is increasingly becoming a
standard point of Financial reporting. e.g if an FI wishes to push their
portfolio reporting for an external securitization or better if Risk
reporting solutions need to be embedded, Pentaho does not support this to
the extent of 2020 level reporting.
I would be happy to point a functional specification on a Jira Issue. Prior
to that, I am looking for a technical conversation of feasibility on this
thread.
On Tue, Jun 30, 2020 at 9:22 AM Bharath Gowda wrote:
> Hello Everyone,
>
> Initiating this thread to understand and discuss a solution for the
> Pentaho reporting issues which has surfaced recently.
>
> 1. From which version, Fineract has stopped supporting Pentaho due to
> Licencing issues?
> 2. When we run a Pentaho report on Develop version, we get an sql
> injection error like below, Will it be appropriate to raise an issue to
> handle the pentaho errors (if it is due to the licence support issue) which
> will help the users to understand better?
>
> {"developerMessage":"The request was invalid. This typically will happen
> due to validation errors which are
> provided.","httpStatusCode":"400","defaultUserMessage":"Unexpected SQL
> Commands
> found","userMessageGlobalisationCode":"error.msg.found.sql.injection
>
> 3. Should we discuss an alternate solution for this? Our stretchy reports
> have limitations, many value added reports (with design and calculations)
> will not work with stretchy reports.
>
> From an organization users perspective, this might become a bottleneck for
> their End/Beginning of the Day/Month/Year Business Reconciliations.
>
>
>
> 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, Jun 30, 2020 at 12:02 AM Saransh Sharma
> wrote:
>
>> Currently fineract does not support Pentaho reports due to Licensing
>> issues.
>>
>> You can use or integrate some oss version of reporting engine if you
>> want.
>>
>> Thanks
>>
>> Though Inbuilt Sql based reporting is also quite usable and powerful.
>>
>> On Mon, 29 Jun 2020, 23:11 Kalanzi Vincent,
>> wrote:
>>
>>> Hello Dev
>>>
>>> I have an instance running locally from the latest fineract repository
>>> and also have accessed dev.mifos.io
>>>
>>> In both cases the Pentaho Reports show blank white screen. Am asking for
>>> guidance on how to utilize Pentaho Reports on fineract
>>> https://github.com/apache/fineract
>>>
>>> Kind Regards.
>>>
>> Mifos-developer mailing list
>> mifos-develo...@lists.sourceforge.net
>> Unsubscribe or change settings at:
>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>
>
--
Ankit Müllner
Muellners Europe
+4581929792
This mail is governed by Muellners® IT policy.
The information contained in this e-mail and any accompanying documents may
contain information that is confidential or otherwise protected from
disclosure. If you are not the intended recipient of this message, or if
this message has been addressed to you in error, please immediately alert
the sender by reply e-mail and then delete this message, including any
attachments. Any dissemination, distribution or other use of the contents
of this message by anyone other than the intended recipient is strictly
prohibited. All messages sent to and from this e-mail address may be
monitored as permitted by applicable law and regulations to ensure
compliance with our internal policies and to protect our business. E-mails
are not secure and cannot be guaranteed to be error free as they can be
intercepted, amended, lost or destroyed, or contain viruses. You are deemed
to have accepted these risks if you communicate with us by e-mail.
Re: Fineract Dev Pentaho Reports Issue Discussion
Thanks Bharath for your reply. To add to what Saransh said, Pentaho reports
don't ship with the Fineract release due to license constraints but they
still ship with the Mifos X discuss distribution on top of Fineract and one
could also grab the reports from this distribution and run against the
latest Fineract version.
Bharath, can you clarify on the that process and link to any available
documentation?
Thanks,
Ed
On Tue, Jun 30, 2020, 00:22 Bharath Gowda wrote:
> Hello Everyone,
>
> Initiating this thread to understand and discuss a solution for the
> Pentaho reporting issues which has surfaced recently.
>
> 1. From which version, Fineract has stopped supporting Pentaho due to
> Licencing issues?
> 2. When we run a Pentaho report on Develop version, we get an sql
> injection error like below, Will it be appropriate to raise an issue to
> handle the pentaho errors (if it is due to the licence support issue) which
> will help the users to understand better?
>
> {"developerMessage":"The request was invalid. This typically will happen
> due to validation errors which are
> provided.","httpStatusCode":"400","defaultUserMessage":"Unexpected SQL
> Commands
> found","userMessageGlobalisationCode":"error.msg.found.sql.injection
>
> 3. Should we discuss an alternate solution for this? Our stretchy reports
> have limitations, many value added reports (with design and calculations)
> will not work with stretchy reports.
>
> From an organization users perspective, this might become a bottleneck for
> their End/Beginning of the Day/Month/Year Business Reconciliations.
>
>
>
> 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, Jun 30, 2020 at 12:02 AM Saransh Sharma
> wrote:
>
>> Currently fineract does not support Pentaho reports due to Licensing
>> issues.
>>
>> You can use or integrate some oss version of reporting engine if you
>> want.
>>
>> Thanks
>>
>> Though Inbuilt Sql based reporting is also quite usable and powerful.
>>
>> On Mon, 29 Jun 2020, 23:11 Kalanzi Vincent,
>> wrote:
>>
>>> Hello Dev
>>>
>>> I have an instance running locally from the latest fineract repository
>>> and also have accessed dev.mifos.io
>>>
>>> In both cases the Pentaho Reports show blank white screen. Am asking for
>>> guidance on how to utilize Pentaho Reports on fineract
>>> https://github.com/apache/fineract
>>>
>>> Kind Regards.
>>>
>> Mifos-developer mailing list
>> mifos-develo...@lists.sourceforge.net
>> Unsubscribe or change settings at:
>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>
>
Fineract Dev Pentaho Reports Issue Discussion
Hello Everyone,
Initiating this thread to understand and discuss a solution for the Pentaho
reporting issues which has surfaced recently.
1. From which version, Fineract has stopped supporting Pentaho due to
Licencing issues?
2. When we run a Pentaho report on Develop version, we get an sql
injection error like below, Will it be appropriate to raise an issue to
handle the pentaho errors (if it is due to the licence support issue) which
will help the users to understand better?
{"developerMessage":"The request was invalid. This typically will happen
due to validation errors which are
provided.","httpStatusCode":"400","defaultUserMessage":"Unexpected SQL
Commands
found","userMessageGlobalisationCode":"error.msg.found.sql.injection
3. Should we discuss an alternate solution for this? Our stretchy reports
have limitations, many value added reports (with design and calculations)
will not work with stretchy reports.
>From an organization users perspective, this might become a bottleneck for
their End/Beginning of the Day/Month/Year Business Reconciliations.
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, Jun 30, 2020 at 12:02 AM Saransh Sharma
wrote:
> Currently fineract does not support Pentaho reports due to Licensing
> issues.
>
> You can use or integrate some oss version of reporting engine if you want.
>
> Thanks
>
> Though Inbuilt Sql based reporting is also quite usable and powerful.
>
> On Mon, 29 Jun 2020, 23:11 Kalanzi Vincent,
> wrote:
>
>> Hello Dev
>>
>> I have an instance running locally from the latest fineract repository
>> and also have accessed dev.mifos.io
>>
>> In both cases the Pentaho Reports show blank white screen. Am asking for
>> guidance on how to utilize Pentaho Reports on fineract
>> https://github.com/apache/fineract
>>
>> Kind Regards.
>>
> Mifos-developer mailing list
> mifos-develo...@lists.sourceforge.net
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer
Re: Fineract Dev Pentaho Reports
Thank you for your response on this. I'm aware Mifos 18.03.01 has Pentaho integrated. How did they accomplish this? Or is this something that cannot be discussed here? Also what other OSS reporting tools are known to work with Fineract and how do we integrate them? Easy Reporting is a key deal breaker for the client I'm evaluating Fineract for Sent from my iPhone > On 29 Jun 2020, at 19:25, Saransh Sharma wrote: > > > Currently fineract does not support Pentaho reports due to Licensing issues. > > You can use or integrate some oss version of reporting engine if you want. > > Thanks > > Though Inbuilt Sql based reporting is also quite usable and powerful. > >> On Mon, 29 Jun 2020, 23:11 Kalanzi Vincent, >> wrote: >> Hello Dev >> >> I have an instance running locally from the latest fineract repository and >> also have accessed dev.mifos.io >> >> In both cases the Pentaho Reports show blank white screen. Am asking for >> guidance on how to utilize Pentaho Reports on fineract >> https://github.com/apache/fineract >> >> Kind Regards.
Re: Fineract Dev Pentaho Reports
Currently fineract does not support Pentaho reports due to Licensing issues. You can use or integrate some oss version of reporting engine if you want. Thanks Though Inbuilt Sql based reporting is also quite usable and powerful. On Mon, 29 Jun 2020, 23:11 Kalanzi Vincent, wrote: > Hello Dev > > I have an instance running locally from the latest fineract repository and > also have accessed dev.mifos.io > > In both cases the Pentaho Reports show blank white screen. Am asking for > guidance on how to utilize Pentaho Reports on fineract > https://github.com/apache/fineract > > Kind Regards. >
Fineract Dev Pentaho Reports
Hello Dev I have an instance running locally from the latest fineract repository and also have accessed dev.mifos.io In both cases the Pentaho Reports show blank white screen. Am asking for guidance on how to utilize Pentaho Reports on fineract https://github.com/apache/fineract Kind Regards.
Re: [Mifos-users] Pentaho
Hi All, I am going to look into this and share here 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 Wed, Jun 24, 2020, 18:30 Juan Manuel Hernández wrote: > Hi All, > > Does anyone know why Pentaho reports don't work in version 19.12? > > https://staging.mifos.io/#/reports/all > > [image: Captura de pantalla 2020-06-24 a las 20.28.04.png] > > Regards, > > Juan Manuel > > > ___ > Mifos-users mailing list > mifos-us...@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users >
Re: [Mifos-users] Pentaho
Hello Juan, The version which is running on the staging server is the Latest Development branch and not the 19.12 version. However, 19.12 version too has this issue. @Ed Cable and Moses, Reports are failing because of sql injection error. ""developerMessage":"The request was invalid. This typically will happen due to validation errors which are provided.","httpStatusCode":"400","defaultUserMessage":"Unexpected SQL Commands found","userMessageGlobalisationCode":"error.msg.found.sql.injection" 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, Jun 25, 2020 at 2:14 AM Ed Cable wrote: > Moses, > > Could you please create a ticket on the issue tracker? For reporting > related issues to Mifos X, we are using the github issue tracker for the > community-app since there's no dedicated repo for reporting. > > Ed > > On Wed, Jun 24, 2020 at 1:35 PM Moses Gitonga Ntiritu < > ntiritum...@gmail.com> wrote: > >> Thankyou ED >> We have been having similar issue on Pentaho as raised by Juan Manuel >> We had to revert back to version 18 after failing to work especially on >> accounting reports like balance sheets and trial balance >> Sincere regards >> >> Moses >> >> On Wed, Jun 24, 2020 at 11:03 PM Ed Cable wrote: >> >>> Juan Manuel, >>> >>> That release branch of the code still hasn't been fully tested and >>> released but we will try to troubleshoot your Pentaho issues and I have >>> cc'd @Bharath Gowda to try to look into your issue. >>> >>> Ed >>> >>> On Wed, Jun 24, 2020 at 11:28 AM Juan Manuel Hernández < >>> fdominik...@gmail.com> wrote: >>> >>>> Hi All, >>>> >>>> Does anyone know why Pentaho reports don't work in version 19.12? >>>> >>>> https://staging.mifos.io/#/reports/all >>>> >>>> [image: Captura de pantalla 2020-06-24 a las 20.28.04.png] >>>> >>>> Regards, >>>> >>>> Juan Manuel >>>> >>>> >>>> >>> >>> -- >>> *Ed Cable* >>> President/CEO, Mifos Initiative >>> edca...@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-us...@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* >> >> >> >> > > -- > *Ed Cable* > President/CEO, Mifos Initiative > edca...@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: [Mifos-users] Pentaho
Moses, Could you please create a ticket on the issue tracker? For reporting related issues to Mifos X, we are using the github issue tracker for the community-app since there's no dedicated repo for reporting. Ed On Wed, Jun 24, 2020 at 1:35 PM Moses Gitonga Ntiritu wrote: > Thankyou ED > We have been having similar issue on Pentaho as raised by Juan Manuel > We had to revert back to version 18 after failing to work especially on > accounting reports like balance sheets and trial balance > Sincere regards > > Moses > > On Wed, Jun 24, 2020 at 11:03 PM Ed Cable wrote: > >> Juan Manuel, >> >> That release branch of the code still hasn't been fully tested and >> released but we will try to troubleshoot your Pentaho issues and I have >> cc'd @Bharath Gowda to try to look into your issue. >> >> Ed >> >> On Wed, Jun 24, 2020 at 11:28 AM Juan Manuel Hernández < >> fdominik...@gmail.com> wrote: >> >>> Hi All, >>> >>> Does anyone know why Pentaho reports don't work in version 19.12? >>> >>> https://staging.mifos.io/#/reports/all >>> >>> [image: Captura de pantalla 2020-06-24 a las 20.28.04.png] >>> >>> Regards, >>> >>> Juan Manuel >>> >>> >>> >> >> -- >> *Ed Cable* >> President/CEO, Mifos Initiative >> edca...@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-us...@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* > > > > -- *Ed Cable* President/CEO, Mifos Initiative edca...@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: [Mifos-users] Pentaho
Thankyou ED We have been having similar issue on Pentaho as raised by Juan Manuel We had to revert back to version 18 after failing to work especially on accounting reports like balance sheets and trial balance Sincere regards Moses On Wed, Jun 24, 2020 at 11:03 PM Ed Cable wrote: > Juan Manuel, > > That release branch of the code still hasn't been fully tested and > released but we will try to troubleshoot your Pentaho issues and I have > cc'd @Bharath Gowda to try to look into your issue. > > Ed > > On Wed, Jun 24, 2020 at 11:28 AM Juan Manuel Hernández < > fdominik...@gmail.com> wrote: > >> Hi All, >> >> Does anyone know why Pentaho reports don't work in version 19.12? >> >> https://staging.mifos.io/#/reports/all >> >> [image: Captura de pantalla 2020-06-24 a las 20.28.04.png] >> >> Regards, >> >> Juan Manuel >> >> >> > > -- > *Ed Cable* > President/CEO, Mifos Initiative > edca...@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-us...@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*
Re: Pentaho
Juan Manuel, That release branch of the code still hasn't been fully tested and released but we will try to troubleshoot your Pentaho issues and I have cc'd @Bharath Gowda to try to look into your issue. Ed On Wed, Jun 24, 2020 at 11:28 AM Juan Manuel Hernández < fdominik...@gmail.com> wrote: > Hi All, > > Does anyone know why Pentaho reports don't work in version 19.12? > > https://staging.mifos.io/#/reports/all > > [image: Captura de pantalla 2020-06-24 a las 20.28.04.png] > > Regards, > > Juan Manuel > > > -- *Ed Cable* President/CEO, Mifos Initiative edca...@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>
Pentaho
Hi All, Does anyone know why Pentaho reports don't work in version 19.12? https://staging.mifos.io/#/reports/all [image: Captura de pantalla 2020-06-24 a las 20.28.04.png] Regards, Juan Manuel
Pentaho reports: develop branch fineract and community-app
Hi all, I hope everyone is well. I need your help to run pentaho reports on the develop branch of fineract and community app. Previously, there was a fineract fork to install with pentaho support and another without it, however for the develop branch I could not find it. After installing fineract (https://github.com/apache/fineract ) and community-app (https://github.com/openMF/community-app.git) develop branch, I try the reports, but it didn't work. I copied pentaho files from the previously released version and copied to HOME_USER\,fineract folder. Please someone could help me to achieve this. Thank you. Best regards -- LSC. Luis Alegría INNOVARAPP 2225548732 *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.*
Re: [Mifos-developer] PENTAHO REPORTS
Hi Prakash No, it has not. attached is our fineract log file. What we did was copy all the Pentaho reports to the project and then its dependencies did the known configuration. The war was built successfully from gradle. But when the report is executed a blank screen comes up not the pentaho report as in Mifos X. Then we tried to git clone the mifosx from openmf. This could not be compiled at all. Now no idea how we can compare the project for having the pentaho reports. Please help us. Regards Girish On Thu, Dec 5, 2019 at 7:37 PM Prakash Perumal < prakashperumal_2...@outlook.com> wrote: > Hi Girish, > > Is the issue with Pentaho reports resolved? > If not please share some information on the error / notification. > > Kind Regards, > > Prakash Perumal > Product Manager - Mifos Initiative > > -- > *From:* Girish Kumar > *Sent:* Wednesday, December 4, 2019 2:19 PM > *To:* Mifos software development ; > Dev > *Subject:* [Mifos-developer] PENTAHO REPORTS > > Hi all, > > We are trying to enforce the pentaho reports to the fineract, the build > with pentaho rep and dependencies was successful but the reports are nor > running, any clue where and what we are missing .. the reports are very > crucial for the projects > > Regards > Girish K >
Re: [Mifos-developer] PENTAHO REPORTS
Hi Girish, Is the issue with Pentaho reports resolved? If not please share some information on the error / notification. Kind Regards, Prakash Perumal Product Manager - Mifos Initiative From: Girish Kumar Sent: Wednesday, December 4, 2019 2:19 PM To: Mifos software development ; Dev Subject: [Mifos-developer] PENTAHO REPORTS Hi all, We are trying to enforce the pentaho reports to the fineract, the build with pentaho rep and dependencies was successful but the reports are nor running, any clue where and what we are missing .. the reports are very crucial for the projects Regards Girish K
Re: PENTAHO REPORTS
Could you tell me the procedures, I tried (don't worry about the SQL I will look into it) but the reports are not generating only I see blank screens when a Pentaho report is called !! the build was successful after adding the reports and other dependencies (I presume I had added all, as there were no errors while the build) On 2019/12/04 09:37:18, Maek Twain wrote: > I tried doing the same seems like there is some issue with database > queries, t me there were errors in the log about statement being fired but > failing at the core level of execution, I researched a bit I found it , has > to do with sql libs. > > Thanks > > On Wed, 4 Dec 2019, 14:19 Girish Kumar, wrote: > > > Hi all, > > > > We are trying to enforce the pentaho reports to the fineract, the build > > with pentaho rep and dependencies was successful but the reports are nor > > running, any clue where and what we are missing .. the reports are very > > crucial for the projects > > > > Regards > > Girish K > > >
Re: PENTAHO REPORTS
I tried doing the same seems like there is some issue with database queries, t me there were errors in the log about statement being fired but failing at the core level of execution, I researched a bit I found it , has to do with sql libs. Thanks On Wed, 4 Dec 2019, 14:19 Girish Kumar, wrote: > Hi all, > > We are trying to enforce the pentaho reports to the fineract, the build > with pentaho rep and dependencies was successful but the reports are nor > running, any clue where and what we are missing .. the reports are very > crucial for the projects > > Regards > Girish K >
PENTAHO REPORTS
Hi all, We are trying to enforce the pentaho reports to the fineract, the build with pentaho rep and dependencies was successful but the reports are nor running, any clue where and what we are missing .. the reports are very crucial for the projects Regards Girish K
Mifos Pentaho Reports failing on query for userhierarchy
Hi Everyone,
I am trying to integrate Pentaho reporting into Fineract. I got the pentaho
reports from https://github.com/openMF/incubator-fineract.
I am not yet creating custom reports and would want to run the existing
pentaho reports (e.g., Active Loans - Details(Pentaho) ) however, I am
failing when running any pentaho reports via Reports menu (web) and getting
below error:
*10:59:11.755 [http-bio-8443-exec-10] ERROR
o.p.r.e.c.c.m.o.p.pdf.PdfReportUtil - Writing PDF failed.*
*org.pentaho.reporting.engine.classic.core.ReportDataFactoryException:
Failed at query: *
*select *
*id, *
*concat(substring("", 1, *
*((LENGTH(`hierarchy`) - LENGTH(REPLACE(`hierarchy`, '.', '')) - 1) *
4)),`name`) as tc *
*from m_office *
*where hierarchy like concat (${userhierarchy}, '%') *
*order by hierarchy*
I am confused why it is failing because running the Active Loans -
Details(Pentaho) report via Pentaho Designer (via Print Preview) gives me
an output thus, should have no syntax error for this query.
Any help would be highly appreciated. Cheers!
Regards,
Jun King P. Miñon
Consultant Software Engineer
Core Banking Solutions
--
PEARLPAY INC.
2nd Floor, 22 The Jupiter Center, Jupiter Street,
Makati, 1209 Metro Manila, Philippines
https://www.pearlpay.com
<https://www.pearlpay.com>
https://www.linkedin.com/company/pearlpay
<https://www.linkedin.com/company/pearlpay>
https://www.facebook.com/PearlPayOFFICIAL
<https://www.facebook.com/PearlPayOFFICIAL/>
This email and any files
transmitted with it are confidential and intended solely for the use of the
individual or entity to whom they are addressed. If you have received this
email in error please notify the system manager. This message contains
confidential information and is intended only for the individual named. If
you are not the named addressee you should not disseminate, distribute or
copy this e-mail. Please notify the sender immediately by e-mail if you
have received this e-mail by mistake and delete this e-mail from your
system. If you are not the intended recipient you are notified that
disclosing, copying, distributing or taking any action in reliance on the
contents of this information is strictly prohibited. WARNING: Computer
viruses can be transmitted via email. The recipient should check this email
and any attachments for the presence of viruses. The company accepts no
liability for any damage caused by any virus transmitted by this email.
E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message,
which arise as a result of e-mail transmission. Our company accepts no
liability for the content of this email, or for the consequences of any
actions taken on the basis of the information provided, unless that
information is subsequently confirmed in writing. If you are not the
intended recipient you are notified that disclosing, copying, distributing
or taking any action in reliance on the contents of this information is
strictly prohibited. Any views or opinions presented in this email are
solely those of the author and do not necessarily represent those of the
company. Employees of the company are expressly required not to make
defamatory statements and not to infringe or authorize any infringement of
copyright or any other legal right by email communications. Any such
communication is contrary to company policy and outside the scope of the
employment of the individual concerned. The company will not accept any
liability in respect of such communication, and the employee responsible
will be personally liable for any damages or other liability arising.
Re: Mifos X Pentaho Custom Reports
Ok, thanks. On Tue, Aug 20, 2019, 14:39 Maek Twain wrote: > Hey you need to connect with mysql there is no need to run mifos x /apache > fineract. > > > On Mon, 19 Aug 2019, 17:34 Mexina Daniel, wrote: > >> Hello Laban >> >> The pentaho reports are designed by using Pentaho Report Designer, after >> designing is when you can embed in mifos. >> >> See the link >> https://mifosforge.jira.com/wiki/spaces/docs/pages/82706447/Creating+Simple+Pentaho+Report+and+Embedding+it+to+MifosX >> >> Hope this will help. >> >> Best Regards >> >> On August 19, 2019 at 5:02 PM Laban Kibowen < >> laban.kibo...@intrasofttechnologies.com> wrote: >> >> Hello, >> Kindly tell me how I can set up an environment on windows 10 so as I can >> be able to design pentaho reports using mifos x local instance running on >> my laptop. >> thanks >> *LABAN KIBOWEN | **DevOps Engineer* >> *Intrasoft Technologies Limited* >> *3rd Floor, Ruman Plaza, St. Bernard Street.* >> *P. O. Box 82298 - 80100, Mombasa.* >> *Tel: +254 706 427 805 / 0752 427 805* >> *Skype: bowenjnr37* >> *Web: www.intrasofttechnologies.com >> <http://www.intrasofttechnologies.com>* >> >> >> >> Mexina Daniel >> >> Singo Africa Limited >> >> Mbezi Beach "B" | Mwai Kibaki Road | 6 Wasafi Str. >> P.O BOX 78908 | 14121 Dar es salaam >> >> +255 71 211 0791 | +255 22 261 8511 >> >> amala.co.tz | singo.africa >> >> >> >
Re: Mifos X Pentaho Custom Reports
Hey you need to connect with mysql there is no need to run mifos x /apache fineract. On Mon, 19 Aug 2019, 17:34 Mexina Daniel, wrote: > Hello Laban > > The pentaho reports are designed by using Pentaho Report Designer, after > designing is when you can embed in mifos. > > See the link > https://mifosforge.jira.com/wiki/spaces/docs/pages/82706447/Creating+Simple+Pentaho+Report+and+Embedding+it+to+MifosX > > Hope this will help. > > Best Regards > > On August 19, 2019 at 5:02 PM Laban Kibowen < > laban.kibo...@intrasofttechnologies.com> wrote: > > Hello, > Kindly tell me how I can set up an environment on windows 10 so as I can > be able to design pentaho reports using mifos x local instance running on > my laptop. > thanks > *LABAN KIBOWEN | **DevOps Engineer* > *Intrasoft Technologies Limited* > *3rd Floor, Ruman Plaza, St. Bernard Street.* > *P. O. Box 82298 - 80100, Mombasa.* > *Tel: +254 706 427 805 / 0752 427 805* > *Skype: bowenjnr37* > *Web: www.intrasofttechnologies.com <http://www.intrasofttechnologies.com>* > > > > Mexina Daniel > > Singo Africa Limited > > Mbezi Beach "B" | Mwai Kibaki Road | 6 Wasafi Str. > P.O BOX 78908 | 14121 Dar es salaam > > +255 71 211 0791 | +255 22 261 8511 > > amala.co.tz | singo.africa > > >
Re: Mifos X Pentaho Custom Reports
Hello Laban The pentaho reports are designed by using Pentaho Report Designer, after designing is when you can embed in mifos. See the link https://mifosforge.jira.com/wiki/spaces/docs/pages/82706447/Creating+Simple+Pentaho+Report+and+Embedding+it+to+MifosX Hope this will help. Best Regards > On August 19, 2019 at 5:02 PM Laban Kibowen > wrote: > > Hello, > Kindly tell me how I can set up an environment on windows 10 so as I can > be able to design pentaho reports using mifos x local instance running on my > laptop. > thanks > LABAN KIBOWEN | DevOps Engineer > Intrasoft Technologies Limited > 3rd Floor, Ruman Plaza, St. Bernard Street. > P. O. Box 82298 - 80100, Mombasa. > Tel: +254 706 427 805 / 0752 427 805 > Skype: bowenjnr37 > Web:http://www.intrasofttechnologies.com > > > Mexina Daniel Singo Africa Limited Mbezi Beach "B" | Mwai Kibaki Road | 6 Wasafi Str. P.O BOX 78908 | 14121 Dar es salaam +255 71 211 0791 | +255 22 261 8511 amala.co.tz https://amala.co.tz/ | singo.africa https://singo.africa
Mifos X Pentaho Custom Reports
Hello, Kindly tell me how I can set up an environment on windows 10 so as I can be able to design pentaho reports using mifos x local instance running on my laptop. thanks *LABAN KIBOWEN | **DevOps Engineer* *Intrasoft Technologies Limited* *3rd Floor, Ruman Plaza, St. Bernard Street.* *P. O. Box 82298 - 80100, Mombasa.* *Tel: +254 706 427 805 / 0752 427 805* *Skype: bowenjnr37* *Web: www.intrasofttechnologies.com <http://www.intrasofttechnologies.com>*
Re: [Mifos-developer] Apache Fineract and Pentaho report
Girish, I'm adding the dev@fineract.apache.org mailing list, where people developing the Fineract back end hang out. If you would like to build it and develo yourself, you should subscribe to that list, by sending a blank email to dev-subscr...@fineract.apache.org, as outlined on http://fineract.apache.org/ On Fri, Jul 19, 2019 at 11:46 AM Girish Kumar wrote: > Hi > > My this mail is in regard with the question asked > > http://mifos.cloud.answerhub.com/questions/3143/latest-source-code-and-pentaho-reports.html > > I too am confused, as there will be lot others out there like me. Could > any one give us a clear direction where we can get the latest code with > pentaho or the best is at least can we get a write up on how to integrate > the pentaho reports on openmf git to our own cloned/downloaded fineract. I > tried and am getting an error while the build > Execution failed for task ':rat'. > > Found 51 files with unapproved/unknown licenses. See > file:/D:/MifoxProject/Attempt2/fineract/build/reports/rat/rat-report.txt > > and build fails > The https://github.com/apache/fineract build does not fail - as proven by the green https://travis-ci.org/apache/fineract. Are you perhaps using https://github.com/openMF/incubator-fineract ? As far as I know, that's is not maintained anymore (anyone please jump in and correct me if that's wrong). > Appreciate if anyone can guide us thru in this regard > > Thanks and Regards > Girish K > Mifos-developer mailing list > mifos-develo...@lists.sourceforge.net > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer
Re: Some of the loan reports of pentaho are not displaying
Can you verify whether mifos distribution is deployed or fineract
distribution is deployed? I see the following error for pentaho reports.
{
1. developerMessage: "The requested resource is not available.",
httpStatusCode: "404",…}
1. defaultUserMessage: "The requested resource is not available."
2. developerMessage: "The requested resource is not available."
3. errors: [{developerMessage: "Reporting meta-data entry not
found.",…}]
4. httpStatusCode: "404"
5. userMessageGlobalisationCode: "error.msg.resource.not.found"
6.
7. Regards,
8. Nazeer
9.
On Wed, May 29, 2019 at 7:46 PM Mexina Daniel wrote:
> Hello
>
> It seems there are changes done in fineract that brought effect to display
> of some of the pentaho loan reports ( seems it has to do with parameters)
>
> I have tried with the same community app, to run platform of Fineract
> 1.1.0 and Fineract 1.2.0 and found those reports was displayed when using
> 1.1.0 and not displayed when using 1.2.0.
>
> I checked on https://staging.openmf.org too since it fineract 1.2.0 and
> found the same issue.
>
> Can someone check and help what could be the change and how to solve it.
>
> Some of the reports are :
>
> *Active Loans - Details(Pentaho)*
>
> *Active Loans - Summary(Pentaho)*
>
> *Active Loans by Disbursal Period(Pentaho)*
>
> etc
>
> Quick response will be appreciated as our live servers are running
> fineract 1.2.0.
>
> Thanks in advance.
>
> Mexina Daniel
>
> Singo Africa Limited
>
> Mbezi Beach "B" | Mwai Kibaki Road | 6 Wasafi Str.
> P.O BOX 78908 | 14121 Dar es salaam
>
> +255 71 211 0791 | +255 22 261 8511
>
> amala.co.tz | singo.africa
>
>
>
Some of the loan reports of pentaho are not displaying
Hello It seems there are changes done in fineract that brought effect to display of some of the pentaho loan reports ( seems it has to do with parameters) I have tried with the same community app, to run platform of Fineract 1.1.0 and Fineract 1.2.0 and found those reports was displayed when using 1.1.0 and not displayed when using 1.2.0. I checked on https://staging.openmf.org too since it fineract 1.2.0 and found the same issue. Can someone check and help what could be the change and how to solve it. Some of the reports are : Active Loans - Details(Pentaho) Active Loans - Summary(Pentaho) Active Loans by Disbursal Period(Pentaho) etc Quick response will be appreciated as our live servers are running fineract 1.2.0. Thanks in advance. Mexina Daniel Singo Africa Limited Mbezi Beach "B" | Mwai Kibaki Road | 6 Wasafi Str. P.O BOX 78908 | 14121 Dar es salaam +255 71 211 0791 | +255 22 261 8511 amala.co.tz https://amala.co.tz/ | singo.africa https://singo.africa
Re: Eror 404 when running Pentaho Reports
Hello Zayyad, Since fineract is running inside a docker container, I cannot restart tomcat. But I tried restarting the container, but it's the same result. But when I analyze the code the function generatePentahoReportAsOutputStream is all commented out. Is it the method that is supposed to render the reports? : https://github.com/apache/fineract/blob/3c21ae1483a9dc9589dfcaaef9885a434b70a125/fineract-provider/src/main/java/org/apache/fineract/infrastructure/dataqueries/service/ReadReportingServiceImpl.java . Patrick On Tue, 28 May 2019 at 15:05, Patrick Finken wrote: > Thanks Zayyad, I will try that. > > On Tue, 28 May 2019 at 14:40, Zayyad A. Said < > zay...@intrasofttechnologies.com> wrote: > >> Hello Patrick, >> >> >> >> Try these steps: >> >> >> >> · Stop Tomcat server. >> >> · Copy pentahoReports directory from the downloaded directory to >> the .mifosx directory. >> >> · Start Tomcat Server. >> >> >> >> Check if your pentaho reports are now running. >> >> >> >> We had similar issue before and we simply copied the directory again and >> it worked, strange I know. >> >> >> >> 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 >> >> [image: Description: Email banner] >> >> >> >> *From:* Patrick Finken [mailto:patr...@finksolutions.ca] >> *Sent:* 28 May 2019 07:48 PM >> *To:* dev@fineract.apache.org >> *Subject:* Eror 404 when running Pentaho Reports >> >> >> >> Hello guys, >> >> >> >> I've noticed a 404 http error whenever I try to run a Pentaho report. >> I've checked and the reports are correctly installed in the folder >> /root/.mifosx/pentahoReports according to the documentation. >> >> >> >> It seems to be the same problem described in this thread: >> https://groups.google.com/forum/#!topic/mifosusers/JrWyLgWVSrU >> >> >> >> Does someone have an idea of what might be the problem? >> >> >> >> Regards >> >> -- >> >> Patrick Finken, >> >> Principal Consultant >> >> > > -- > Patrick Finken, > Principal Consultant > > -- Patrick Finken, Principal Consultant
Re: Eror 404 when running Pentaho Reports
Thanks Zayyad, I will try that. On Tue, 28 May 2019 at 14:40, Zayyad A. Said < zay...@intrasofttechnologies.com> wrote: > Hello Patrick, > > > > Try these steps: > > > > · Stop Tomcat server. > > · Copy pentahoReports directory from the downloaded directory to > the .mifosx directory. > > · Start Tomcat Server. > > > > Check if your pentaho reports are now running. > > > > We had similar issue before and we simply copied the directory again and > it worked, strange I know. > > > > 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 > > [image: Description: Email banner] > > > > *From:* Patrick Finken [mailto:patr...@finksolutions.ca] > *Sent:* 28 May 2019 07:48 PM > *To:* dev@fineract.apache.org > *Subject:* Eror 404 when running Pentaho Reports > > > > Hello guys, > > > > I've noticed a 404 http error whenever I try to run a Pentaho report. I've > checked and the reports are correctly installed in the folder > /root/.mifosx/pentahoReports according to the documentation. > > > > It seems to be the same problem described in this thread: > https://groups.google.com/forum/#!topic/mifosusers/JrWyLgWVSrU > > > > Does someone have an idea of what might be the problem? > > > > Regards > > -- > > Patrick Finken, > > Principal Consultant > > -- Patrick Finken, Principal Consultant
RE: Eror 404 when running Pentaho Reports
Hello Patrick, Try these steps: · Stop Tomcat server. · Copy pentahoReports directory from the downloaded directory to the .mifosx directory. · Start Tomcat Server. Check if your pentaho reports are now running. We had similar issue before and we simply copied the directory again and it worked, strange I know. 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 Description: Email banner From: Patrick Finken [mailto:patr...@finksolutions.ca] Sent: 28 May 2019 07:48 PM To: dev@fineract.apache.org Subject: Eror 404 when running Pentaho Reports Hello guys, I've noticed a 404 http error whenever I try to run a Pentaho report. I've checked and the reports are correctly installed in the folder /root/.mifosx/pentahoReports according to the documentation. It seems to be the same problem described in this thread: https://groups.google.com/forum/#!topic/mifosusers/JrWyLgWVSrU Does someone have an idea of what might be the problem? Regards -- Patrick Finken, Principal Consultant <https://firebasestorage.googleapis.com/v0/b/fink-solutions.appspot.com/o/Company%20picture%2Ffink-solution_small.png?alt=media&token=bd80ed63-17f3-4a74-be18-2a64a2d38778>
Eror 404 when running Pentaho Reports
Hello guys, I've noticed a 404 http error whenever I try to run a Pentaho report. I've checked and the reports are correctly installed in the folder /root/.mifosx/pentahoReports according to the documentation. It seems to be the same problem described in this thread: https://groups.google.com/forum/#!topic/mifosusers/JrWyLgWVSrU Does someone have an idea of what might be the problem? Regards -- Patrick Finken, Principal Consultant
Re: Unable to find Pentaho Processing Service in apache/fineract
We should add these questions to the Fineract FAQ and provide the FAQ link in the list signature line . On Thu, May 9, 2019, 1:24 PM Vishwas Babu wrote: > Parth, > > Fineract does not ship Pentaho reports or the related libraries > (compliance issues with Apache licence) . Head over to the Mifos community > who maintains distributions that include pentaho. > > Regards, > Vishwas > > > > On Thu, May 9, 2019 at 10:59 AM Parth Mangroliya < > parth.mangrol...@kuliza.com> wrote: > >> Hello , >> >> I was going through reporting service feature and found >> no ReportingProcessService for Pentaho Reports in "apache/fineract". >> However, I am able to find class PentahoReportingProcessServiceImpl.java in >> "incubator-fineract" repository which is forked from "apache/fineract" >> along with pentaho report files for core reports. >> >> My query is : Is it fine to use Pentaho with apache/fineract without >> forking from "incubator-fineract" ? >> >> >> -- >> Regards, >> Parth Mangroliya >> >
Re: Unable to find Pentaho Processing Service in apache/fineract
Parth, Fineract does not ship Pentaho reports or the related libraries (compliance issues with Apache licence) . Head over to the Mifos community who maintains distributions that include pentaho. Regards, Vishwas On Thu, May 9, 2019 at 10:59 AM Parth Mangroliya < parth.mangrol...@kuliza.com> wrote: > Hello , > > I was going through reporting service feature and found > no ReportingProcessService for Pentaho Reports in "apache/fineract". > However, I am able to find class PentahoReportingProcessServiceImpl.java in > "incubator-fineract" repository which is forked from "apache/fineract" > along with pentaho report files for core reports. > > My query is : Is it fine to use Pentaho with apache/fineract without > forking from "incubator-fineract" ? > > > -- > Regards, > Parth Mangroliya >
Unable to find Pentaho Processing Service in apache/fineract
Hello , I was going through reporting service feature and found no ReportingProcessService for Pentaho Reports in "apache/fineract". However, I am able to find class PentahoReportingProcessServiceImpl.java in "incubator-fineract" repository which is forked from "apache/fineract" along with pentaho report files for core reports. My query is : Is it fine to use Pentaho with apache/fineract without forking from "incubator-fineract" ? -- Regards, Parth Mangroliya
Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts
+Sampath. Hi Sampath, Please guide Andrew about how to show Charts in Pentaho reports. Thanks Santosh On Thu, Sep 6, 2018 at 10:09 PM, wrote: > Hey Santosh, > > > > Thanks, I have noted that. Will it be possible to resolve the Pentaho not > showing charts issue? > > > > Regards, > > > > Andrew > > > > *From:* Santosh Math [mailto:sant...@confluxtechnologies.com] > *Sent:* Thursday, September 6, 2018 7:49 AM > > *To:* andrew.ken...@bridgeanalytics.co.ke > *Cc:* Mifos software development ; > Dev > *Subject:* Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts > > > > Hi Andrew, > > > > Dashboard isssue is related to Mifos UI, it's nothing to do with Pentaho > reports. Both are two different things. > > > > Thanks > > Santosh > > > > On Wed, Sep 5, 2018 at 10:12 PM, > wrote: > > Hello Santosh, > > > > Just to clarify, is this the same issue for Pentaho Report not showing the > charts? Is that what we have to wait for the fix to be put in the latest > code? > > > > Regards, > > > > Andrew > > > > *From:* Santosh Math [mailto:sant...@confluxtechnologies.com] > *Sent:* Wednesday, September 5, 2018 8:05 AM > *To:* andrew.ken...@bridgeanalytics.co.ke > *Cc:* Mifos software development ; > Dev > *Subject:* Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts > > > > HI Andrew, > > > > The ticket is closed because PR is merged. It's yet to be tested with > latest code from develop branch. > > > > On Tue, Sep 4, 2018 at 12:39 PM, > wrote: > > Hello Santosh, > > > > Could it be this issue you commented on https://github.com/openMF/ > community-app/issues/2041 > > > > Since all the charts are not showing in Mifos, both the ones in the > homepage dashboard as well as when I build a chart report. > > > > Regards, > > > > Andrew > > > > *From:* Santosh Math [mailto:sant...@confluxtechnologies.com] > *Sent:* Monday, September 3, 2018 8:38 AM > *To:* Mifos software development > *Subject:* Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts > > > > +Sampath. > > > > On Sat 1 Sep, 2018, 6:49 PM , wrote: > > Hello Team, > > > > Am having a challenge when embedding a Pentaho report into Mifos. I have > developed a report in Pentaho reports designer that is showing data > correctly in text and graphs, however when I embed it to Mifos it only > shows text data and not the graphs as expected. > > Please advise me on what I need to do to rectify this in case any of you > have ever experienced this issue. > > > > Regards, > > > > Andrew Kenana > > Bridge Analytics LTD > > Phone: +254 722 262547 > > Website: www.bridgeanalytics.co.ke > > > > > -- > > [image: Avast logo] <https://www.avast.com/antivirus> > > This email has been checked for viruses by Avast antivirus software. > www.avast.com <https://www.avast.com/antivirus> > > > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdotMifos-developer > mailing list > mifos-develo...@lists.sourceforge.net > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > Mifos-developer mailing list > mifos-develo...@lists.sourceforge.net > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > > > > > -- > > Thanks & Regards > > Santosh Math > > *QA Engineer* > > *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/>* > > | *Office*: +91-080-41208662 | > > *Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, > Bengaluru, Karnataka, 560043 INDIA > > > > > > -- > > Thanks & Regards > > Santosh Math > > *QA Engineer* > > *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/>* > > | *Office*: +91-080-41208662 | > > *Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, > Bengaluru, Karnataka, 560043 INDIA > -- Thanks & Regards Santosh Math *QA Engineer* *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/>* | *Office*: +91-080-41208662 | *Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, Bengaluru, Karnataka, 560043 INDIA
Re: RE: [Mifos-developer] Mifos Pentaho Reports not showing Charts
Dear sirI need your help to add Arabic language in mifos xfirst i changed every thing in mysql database structure to utf-8 (db-tablee-varchar fields) however when i write any data in mifos lke organization name-officer name, it appears ?second i translated the file local-fr.json to Arabic instead of french and i choose french in profile setting some words like password ,. appear in Arabic very good but other apears Can you tell me the right way to add Arabic language?Best Regards Naser AbdelatiIT Manger of ESED (NGO) in Egypt www.esed-eg.org
RE: [Mifos-developer] Mifos Pentaho Reports not showing Charts
Hey Santosh, Thanks, I have noted that. Will it be possible to resolve the Pentaho not showing charts issue? Regards, Andrew From: Santosh Math [mailto:sant...@confluxtechnologies.com] Sent: Thursday, September 6, 2018 7:49 AM To: andrew.ken...@bridgeanalytics.co.ke Cc: Mifos software development ; Dev Subject: Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts Hi Andrew, Dashboard isssue is related to Mifos UI, it's nothing to do with Pentaho reports. Both are two different things. Thanks Santosh On Wed, Sep 5, 2018 at 10:12 PM, mailto:andrew.ken...@bridgeanalytics.co.ke> > wrote: Hello Santosh, Just to clarify, is this the same issue for Pentaho Report not showing the charts? Is that what we have to wait for the fix to be put in the latest code? Regards, Andrew From: Santosh Math [mailto:sant...@confluxtechnologies.com <mailto:sant...@confluxtechnologies.com> ] Sent: Wednesday, September 5, 2018 8:05 AM To: andrew.ken...@bridgeanalytics.co.ke <mailto:andrew.ken...@bridgeanalytics.co.ke> Cc: Mifos software development mailto:mifos-develo...@lists.sourceforge.net> >; Dev mailto:dev@fineract.apache.org> > Subject: Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts HI Andrew, The ticket is closed because PR is merged. It's yet to be tested with latest code from develop branch. On Tue, Sep 4, 2018 at 12:39 PM, mailto:andrew.ken...@bridgeanalytics.co.ke> > wrote: Hello Santosh, Could it be this issue you commented on https://github.com/openMF/community-app/issues/2041 Since all the charts are not showing in Mifos, both the ones in the homepage dashboard as well as when I build a chart report. Regards, Andrew From: Santosh Math [mailto:sant...@confluxtechnologies.com <mailto:sant...@confluxtechnologies.com> ] Sent: Monday, September 3, 2018 8:38 AM To: Mifos software development mailto:mifos-develo...@lists.sourceforge.net> > Subject: Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts +Sampath. On Sat 1 Sep, 2018, 6:49 PM , mailto:andrew.ken...@bridgeanalytics.co.ke> > wrote: Hello Team, Am having a challenge when embedding a Pentaho report into Mifos. I have developed a report in Pentaho reports designer that is showing data correctly in text and graphs, however when I embed it to Mifos it only shows text data and not the graphs as expected. Please advise me on what I need to do to rectify this in case any of you have ever experienced this issue. Regards, Andrew Kenana Bridge Analytics LTD Phone: +254 722 262547 Website: <http://www.bridgeanalytics.co.ke/> www.bridgeanalytics.co.ke _ <https://www.avast.com/antivirus> This email has been checked for viruses by Avast antivirus software. www.avast.com <https://www.avast.com/antivirus> -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdotMifos-developer mailing list mifos-develo...@lists.sourceforge.net <mailto:mifos-develo...@lists.sourceforge.net> Unsubscribe or change settings at: https://lists.sourceforge.net/lists/listinfo/mifos-developer -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Mifos-developer mailing list mifos-develo...@lists.sourceforge.net <mailto:mifos-develo...@lists.sourceforge.net> Unsubscribe or change settings at: https://lists.sourceforge.net/lists/listinfo/mifos-developer -- Thanks & Regards Santosh Math QA Engineer <http://www.confluxtechnologies.com/> Conflux Technologies Pvt Ltd | Office: +91-080-41208662 | Address: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, Bengaluru, Karnataka, 560043 INDIA -- Thanks & Regards Santosh Math QA Engineer <http://www.confluxtechnologies.com/> Conflux Technologies Pvt Ltd | Office: +91-080-41208662 | Address: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, Bengaluru, Karnataka, 560043 INDIA --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts
Hi Andrew, Dashboard isssue is related to Mifos UI, it's nothing to do with Pentaho reports. Both are two different things. Thanks Santosh On Wed, Sep 5, 2018 at 10:12 PM, wrote: > Hello Santosh, > > > > Just to clarify, is this the same issue for Pentaho Report not showing the > charts? Is that what we have to wait for the fix to be put in the latest > code? > > > > Regards, > > > > Andrew > > > > *From:* Santosh Math [mailto:sant...@confluxtechnologies.com] > *Sent:* Wednesday, September 5, 2018 8:05 AM > *To:* andrew.ken...@bridgeanalytics.co.ke > *Cc:* Mifos software development ; > Dev > *Subject:* Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts > > > > HI Andrew, > > > > The ticket is closed because PR is merged. It's yet to be tested with > latest code from develop branch. > > > > On Tue, Sep 4, 2018 at 12:39 PM, > wrote: > > Hello Santosh, > > > > Could it be this issue you commented on https://github.com/openMF/ > community-app/issues/2041 > > > > Since all the charts are not showing in Mifos, both the ones in the > homepage dashboard as well as when I build a chart report. > > > > Regards, > > > > Andrew > > > > *From:* Santosh Math [mailto:sant...@confluxtechnologies.com] > *Sent:* Monday, September 3, 2018 8:38 AM > *To:* Mifos software development > *Subject:* Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts > > > > +Sampath. > > > > On Sat 1 Sep, 2018, 6:49 PM , wrote: > > Hello Team, > > > > Am having a challenge when embedding a Pentaho report into Mifos. I have > developed a report in Pentaho reports designer that is showing data > correctly in text and graphs, however when I embed it to Mifos it only > shows text data and not the graphs as expected. > > Please advise me on what I need to do to rectify this in case any of you > have ever experienced this issue. > > > > Regards, > > > > Andrew Kenana > > Bridge Analytics LTD > > Phone: +254 722 262547 > > Website: www.bridgeanalytics.co.ke > > > > > -- > > [image: Avast logo] <https://www.avast.com/antivirus> > > This email has been checked for viruses by Avast antivirus software. > www.avast.com <https://www.avast.com/antivirus> > > > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdotMifos-developer > mailing list > mifos-develo...@lists.sourceforge.net > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > Mifos-developer mailing list > mifos-develo...@lists.sourceforge.net > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > > > > > -- > > Thanks & Regards > > Santosh Math > > *QA Engineer* > > *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/>* > > | *Office*: +91-080-41208662 | > > *Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, > Bengaluru, Karnataka, 560043 INDIA > -- Thanks & Regards Santosh Math *QA Engineer* *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/>* | *Office*: +91-080-41208662 | *Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, Bengaluru, Karnataka, 560043 INDIA
RE: [Mifos-developer] Mifos Pentaho Reports not showing Charts
Hello Santosh, Just to clarify, is this the same issue for Pentaho Report not showing the charts? Is that what we have to wait for the fix to be put in the latest code? Regards, Andrew From: Santosh Math [mailto:sant...@confluxtechnologies.com] Sent: Wednesday, September 5, 2018 8:05 AM To: andrew.ken...@bridgeanalytics.co.ke Cc: Mifos software development ; Dev Subject: Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts HI Andrew, The ticket is closed because PR is merged. It's yet to be tested with latest code from develop branch. On Tue, Sep 4, 2018 at 12:39 PM, mailto:andrew.ken...@bridgeanalytics.co.ke> > wrote: Hello Santosh, Could it be this issue you commented on https://github.com/openMF/community-app/issues/2041 Since all the charts are not showing in Mifos, both the ones in the homepage dashboard as well as when I build a chart report. Regards, Andrew From: Santosh Math [mailto:sant...@confluxtechnologies.com <mailto:sant...@confluxtechnologies.com> ] Sent: Monday, September 3, 2018 8:38 AM To: Mifos software development mailto:mifos-develo...@lists.sourceforge.net> > Subject: Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts +Sampath. On Sat 1 Sep, 2018, 6:49 PM , mailto:andrew.ken...@bridgeanalytics.co.ke> > wrote: Hello Team, Am having a challenge when embedding a Pentaho report into Mifos. I have developed a report in Pentaho reports designer that is showing data correctly in text and graphs, however when I embed it to Mifos it only shows text data and not the graphs as expected. Please advise me on what I need to do to rectify this in case any of you have ever experienced this issue. Regards, Andrew Kenana Bridge Analytics LTD Phone: +254 722 262547 Website: <http://www.bridgeanalytics.co.ke/> www.bridgeanalytics.co.ke _ <https://www.avast.com/antivirus> This email has been checked for viruses by Avast antivirus software. www.avast.com <https://www.avast.com/antivirus> -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdotMifos-developer mailing list mifos-develo...@lists.sourceforge.net <mailto:mifos-develo...@lists.sourceforge.net> Unsubscribe or change settings at: https://lists.sourceforge.net/lists/listinfo/mifos-developer -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Mifos-developer mailing list mifos-develo...@lists.sourceforge.net <mailto:mifos-develo...@lists.sourceforge.net> Unsubscribe or change settings at: https://lists.sourceforge.net/lists/listinfo/mifos-developer -- Thanks & Regards Santosh Math QA Engineer <http://www.confluxtechnologies.com/> Conflux Technologies Pvt Ltd | Office: +91-080-41208662 | Address: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, Bengaluru, Karnataka, 560043 INDIA --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts
HI Andrew, The ticket is closed because PR is merged. It's yet to be tested with latest code from develop branch. On Tue, Sep 4, 2018 at 12:39 PM, wrote: > Hello Santosh, > > > > Could it be this issue you commented on https://github.com/openMF/ > community-app/issues/2041 > > > > Since all the charts are not showing in Mifos, both the ones in the > homepage dashboard as well as when I build a chart report. > > > > Regards, > > > > Andrew > > > > *From:* Santosh Math [mailto:sant...@confluxtechnologies.com] > *Sent:* Monday, September 3, 2018 8:38 AM > *To:* Mifos software development > *Subject:* Re: [Mifos-developer] Mifos Pentaho Reports not showing Charts > > > > +Sampath. > > > > On Sat 1 Sep, 2018, 6:49 PM , wrote: > > Hello Team, > > > > Am having a challenge when embedding a Pentaho report into Mifos. I have > developed a report in Pentaho reports designer that is showing data > correctly in text and graphs, however when I embed it to Mifos it only > shows text data and not the graphs as expected. > > Please advise me on what I need to do to rectify this in case any of you > have ever experienced this issue. > > > > Regards, > > > > Andrew Kenana > > Bridge Analytics LTD > > Phone: +254 722 262547 > > Website: www.bridgeanalytics.co.ke > > [image: Bridge logo-02] > > > > > -- > > [image: Avast logo] <https://www.avast.com/antivirus> > > This email has been checked for viruses by Avast antivirus software. > www.avast.com <https://www.avast.com/antivirus> > > > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdotMifos-developer > mailing list > mifos-develo...@lists.sourceforge.net > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > Mifos-developer mailing list > mifos-develo...@lists.sourceforge.net > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > -- Thanks & Regards Santosh Math *QA Engineer* *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/>* | *Office*: +91-080-41208662 | *Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, Bengaluru, Karnataka, 560043 INDIA
Re: Adding Pentaho to Fineract
Thanks Karthik, skype? Louis On Sat, Jul 14, 2018 at 14:37 Karthik Ananthakrishnan wrote: > Dear Louis, > > I can guide you on the steps followed as per Sampath and Santhosh's > guidelines and help. Please ping me. > > Thanks, > Karthik > > On Sat, Jul 14, 2018 at 5:00 PM, Louis Niyongabo > wrote: > > > Ref. to email by Karthik, subj. above. > > > > I would like to know how it was solved. > > > > > > > > Thanks, > > > > > > > > Louis > > > > > > > > > > > > >
Re: Adding Pentaho to Fineract
Dear Louis, I can guide you on the steps followed as per Sampath and Santhosh's guidelines and help. Please ping me. Thanks, Karthik On Sat, Jul 14, 2018 at 5:00 PM, Louis Niyongabo wrote: > Ref. to email by Karthik, subj. above. > > I would like to know how it was solved. > > > > Thanks, > > > > Louis > > > > > >
Adding Pentaho to Fineract
Ref. to email by Karthik, subj. above. I would like to know how it was solved. Thanks, Louis
Re: Adding Pentaho to Fineract
Sampath, Karthik is aware of that. I wanted you to outline the steps to deploy build Mifos X with latest fineract war or jar file as he has made changes to a more recent version of Fineract and can't just use the Mifos X distribution powered by Fineract So basically he needs to swap out the Fineract 1.1 in Mifos X with his custom Fineract build. Ed On Tue, Jun 19, 2018 at 10:07 PM Sampath Kumar G < samp...@confluxtechnologies.com> wrote: > Hi Karthik, > > As you know, Apache Fineract can't support Pentaho reports due to > licensing issue, I am not sure what you mean by "we will need to add > Pentaho capability to the application". Is it okay we can take a call at > 11:30 am (IST)? > > Regards, > Sampath > > > > *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/> *#304, > 2nd Floor, 7th Main Road > > HRBR Layout 1st Block > > Bengaluru, Karnataka, 560043 INDIA > > ™ > > Disclaimer: The information contained in this e-mail message and any > files/attachment transmitted with it is confidential and for the sole use > of the intended recipient(s) or entity identified. If you are not the > intended recipient, please email:supp...@confluxtechnologies.com and > destroy/delete all copies and attachment thereto along with the original > message. Any unauthorized review, use, disclosure, dissemination, > forwarding, printing or copying of this email or any action taken in > reliance on this e-mail is strictly prohibited and is unlawful. The > recipient acknowledges that Conflux Technologies Private Limited or its > subsidiaries and associated companies are unable to exercise control or > ensure or guarantee the integrity of/over the contents of the information > contained in e-mail transmissions. Before opening any attachments, please > check. > > On Wed, Jun 20, 2018 at 12:43 AM, Karthik Ananthakrishnan < > karthy...@gmail.com> wrote: > >> Thank You Ed. >> >> Santhosh/Sampath, >> >> Please let me know an convenient time to connect. >> >> Regards, >> Karthik >> >> On Wed, Jun 20, 2018 at 12:33 AM, Ed Cable wrote: >> >>> Santosh, >>> >>> Could you assist? >>> >>> Ed >>> >>> -- Forwarded message - >>> From: Karthik Ananthakrishnan >>> Date: Tue, Jun 19, 2018 at 12:02 PM >>> Subject: Adding Pentaho to Fineract >>> To: dev@fineract.apache.org >>> >>> >>> Hello all, >>> >>> >>> >>> We are building an application with base code from Apache Fineract git >>> repo. We realized that there are few accounting reports which works only >>> with penta ho and we will need to add pentaho capability to the application. >>> >>> >>> >>> Can anyone who has done this before help us add the right components to >>> our application to enable pentaho reports running. >>> >>> >>> >>> Thanks, >>> >>> Karthik >>> >>> >>> >>> -- >>> *Ed Cable* >>> President/CEO, Mifos Initiative >>> edca...@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> >>> >>> >> >> >> -- >> Karthik Krishnan >> > > -- *Ed Cable* President/CEO, Mifos Initiative edca...@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>
