openMF / fineract-pentaho

Pentaho Reporting Plugin for Apache Fineract
Mozilla Public License 2.0
26 stars 45 forks source link

Failed to use pentaho plugin with apache-fineract docker image #132

Closed gs-jha closed 5 months ago

gs-jha commented 1 year ago

I'm using latest build image of apache-fineract and copied jar file pentaho-plugin-1.9.0-SNAPSHOT.jar to app/libs Getting error when hitting API endpoint api/v1/runreports

Exception: org.apache.fineract.infrastructure.core.exception.PlatformServiceUnavailableException, Message: There is no ReportingProcessService registered in the ReportingProcessServiceProvider for this report type: Pentaho

Please suggest step to get this service running.

ichux commented 7 months ago

@gs-jha were you able to resolve this? I have done everything said to be done but I have the same error as yours!

My own plugins is apache-fineract-binary-1.9.0/pentaho-plugin-1.9.0-20231229.054725-10.jar

I got

{
  "developerMessage" : "The server is currently unable to handle the request , please try after some time.",
  "httpStatusCode" : "503",
  "defaultUserMessage" : "The server is currently unable to handle the request , please try after some time.",
  "userMessageGlobalisationCode" : "error.msg.platform.service.unavailable",
  "errors" : [ {
    "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",
    "args" : [ {
      "value" : "Pentaho"
    } ]
  } ]
}
ichux commented 7 months ago

I can also see, from the logs, that it was properly started. By the way, this is inside Docker:

12:08:07.888 [main] INFO  o.p.r.l.base.boot.AbstractBoot - Pentaho Reporting Engine Classic 9.5.0.0-SNAPSHOT started.
12:08:07.918 [main] INFO  o.a.f.i.r.p.ReportingProcessServiceProvider - Registered report service 'org.apache.fineract.infrastructure.report.service.PentahoReportingProcessServiceImpl@a95f0bd' for type/s '[Pentaho]'
12:08:07.919 [main] INFO  o.a.f.i.r.p.ReportingProcessServiceProvider - Registered report service 'org.apache.fineract.infrastructure.dataqueries.service.DatatableReportingProcessService@707a19cf' for type/s '[Table, Chart, SMS]'
ichux commented 7 months ago

Never mind, it worked. I apologise.

I called the wrong route, initially, that was why I had the issues.

ichux commented 7 months ago

I now have the below issue, which is basically due to the fact that I am using PostgreSQL as against the MariaDB that was used, for which the reports I downloaded works for.

Screenshot from 2024-04-01 12-28-44

IOhacker commented 5 months ago

@ichux please try the Postgresql pentaho prpt files. They have a different connection driver.

@EmanuelCR03 fyi

ichux commented 5 months ago

@ichux please try the Postgresql pentaho prpt files. They have a different connection driver.

@EmanuelCR03 fyi

Where can I find these recommended files

IOhacker commented 5 months ago

Here, in the same repository.

https://github.com/openMF/fineract-pentaho/tree/develop/pentahoReports/Postgresql

El mar, 4 jun 2024 a las 10:03, Chukwudi Nwachukwu (< @.***>) escribió:

@ichux https://github.com/ichux please try the Postgresql pentaho prpt files. They have a different connection driver.

@EmanuelCR03 https://github.com/EmanuelCR03 fyi

Where can I find these recommended files

— Reply to this email directly, view it on GitHub https://github.com/openMF/fineract-pentaho/issues/132#issuecomment-2147897356, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALD2ZAX4YYHZISFWDZA4AG3ZFXQLZAVCNFSM6AAAAAA4535LYWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNBXHA4TOMZVGY . You are receiving this because you modified the open/close state.Message ID: @.***>

ichux commented 5 months ago

Thank you