fineract-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shreyaank Byadagi <shreya...@confluxtechnologies.com>
Subject RE: Pentaho Report in Mifos
Date Sat, 01 Oct 2016 02:19:53 GMT
Medina,

This error may be for 3 reasons:

-If the global scripting is not commented.

-If the tenant URL is not matching to local DB name.

-And If the JDBC/data set is not having the same name as of DB name.

Regards
Shreyaank

On 01-Oct-2016 7:37 AM, "Thynn Win" <thynn.win@thitsaworks.com> wrote:

> Hi Mexina,
>
> Sounds like db connection error and at least it found the report (prpt
> file).
>
> Do you have tenantURL set (default value, etc)? Please verify whether the
> param name and variable value in global script have the same case.
>
> It'd be great if you could keep us posted regarding the solution.
>
> Best,
> Thynn
>
>
> From: Mexina M Daniel [mailto:mexina@singo.co.tz]
> Sent: Friday, 30 September, 2016 14:30
> To: Thynn Win <thynn.win@thitsaworks.com>
> Cc: dev (dev@fineract.incubator.apache.org) <dev@fineract.incubator.
> apache.org>
> Subject: Re: Pentaho Report in Mifos
>
> Hi Thynn
>
> Me too i put the report in /root/.mifosx/pentahoReports and a user is a
> root but still unsuccessful
>
> I have re-checked the steps on creation of the report in Pentaho Reporting
> Designer(PRD)
>
> Now i see the error from PRD just after pasting the Global Scripting
>
>
> java.lang.NullPointerException: URL must not be null when connecting
>     at org.pentaho.reporting.engine.classic.core.modules.misc.
> datafactory.sql.DriverConnectionProvider.createConnection(
> DriverConnectionProvider.java:88)
>     at org.pentaho.reporting.engine.classic.core.modules.misc.
> datafactory.sql.SimpleSQLReportDataFactory.getConnection(
> SimpleSQLReportDataFactory.java:124)
>     at org.pentaho.reporting.engine.classic.core.modules.misc.
> datafactory.sql.SimpleSQLReportDataFactory.getReferencedFields(
> SimpleSQLReportDataFactory.java:211)
>     at org.pentaho.reporting.engine.classic.core.modules.misc.
> datafactory.sql.SQLReportDataFactory.getReferencedFields(
> SQLReportDataFactory.java:153)
>     at org.pentaho.reporting.engine.classic.core.modules.misc.
> datafactory.sql.SQLDataFactoryCore.getReferencedFields(
> SQLDataFactoryCore.java:59)
>     at org.pentaho.reporting.engine.classic.core.metadata.
> DefaultDataFactoryMetaData.getReferencedFields(DefaultDataFactoryMetaData.
> java:88)
>     at org.pentaho.reporting.engine.classic.core.CompoundDataFactoryCore.
> getReferencedFields(CompoundDataFactoryCore.java:39)
>     at org.pentaho.reporting.engine.classic.core.sorting.
> SortingDataFactoryCore.getReferencedFields(SortingDataFactoryCore.java:34)
>     at org.pentaho.reporting.engine.classic.core.metadata.
> DefaultDataFactoryMetaData.getReferencedFields(DefaultDataFactoryMetaData.
> java:88)
>     at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.
> createCacheKey(CachingDataFactory.java:362)
>     at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.
> queryDesignTimeStructure(CachingDataFactory.java:313)
>     at org.pentaho.reporting.engine.classic.core.designtime.
> DesignTimeDataSchemaModel.queryReportData(DesignTimeDataSchemaModel.
> java:189)
>     at org.pentaho.reporting.engine.classic.core.designtime.
> DesignTimeDataSchemaModel.buildDataSchema(DesignTimeDataSchemaModel.
> java:137)
>     at org.pentaho.reporting.engine.classic.core.designtime.
> DesignTimeDataSchemaModel.ensureDataSchemaValid(DesignTimeDataSchemaModel.
> java:97)
>     at org.pentaho.reporting.engine.classic.core.designtime.
> DesignTimeDataSchemaModel.getDataSchema(DesignTimeDataSchemaModel.java:88)
>     at org.pentaho.reporting.designer.core.model.data.
> QueryMetaDataActorImpl.retrieve(QueryMetaDataActorImpl.java:33)
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
>     at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
>     at java.lang.reflect.Method.invoke(Method.java:498)
>     at akka.actor.TypedActor$MethodCall.apply(TypedActor.scala:147)
>     at akka.actor.TypedActor$TypedActor$$anonfun$receive$1$
> $anonfun$applyOrElse$2.apply(TypedActor.scala:311)
>     at akka.actor.TypedActor$TypedActor.withContext(TypedActor.scala:299)
>     at akka.actor.TypedActor$TypedActor$$anonfun$receive$1.
> applyOrElse(TypedActor.scala:306)
>     at akka.actor.Actor$class.aroundReceive(Actor.scala:465)
>     at akka.actor.TypedActor$TypedActor.aroundReceive(
> TypedActor.scala:246)
>     at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516)
>     at akka.actor.ActorCell.invoke(ActorCell.scala:487)
>     at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238)
>     at akka.dispatch.Mailbox.run(Mailbox.scala:220)
>     at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(
> AbstractDispatcher.scala:393)
>     at scala.concurrent.forkjoin.ForkJoinTask.doExec(
> ForkJoinTask.java:260)
>     at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.
> runTask(ForkJoinPool.java:1339)
>     at scala.concurrent.forkjoin.ForkJoinPool.runWorker(
> ForkJoinPool.java:1979)
>     at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(
> ForkJoinWorkerThread.java:107)
>
> Could that be the reason? What could be the cause of this error?
> On 09/30/2016 06:13 AM, Thynn Win wrote:
> Hi Mexina,
>
> We were experiencing the same error and in our case, it's solved by
> changing the user to root and put the report (prpt file) in
> /root/.mifosx/pentahoReports.
>
> The tutorial or documentation suggested {user directory}/.mifosx/pentahoReports
> but it didn't work for us and had to put the report under root path instead.
>
> Best,
> Thynn
> ThitsaWorks, Inc
>
>
>
>
> -----Original Message-----
> From: Mexina M Daniel [mailto:mexina@singo.co.tz]
> Sent: 27 September 2016 17:46
> To: dev@fineract.incubator.apache.org<mailto:dev@fineract.
> incubator.apache.org>
> Subject: Pentaho Report in Mifos
>
>
> Hello devs
>
> I created pentaho report in Pentaho Reporting Designer and want to use
> it in Mifos X, I followed the steps from
> https://mifosforge.jira.com/wiki/display/docs/Creating+Simple+Pentaho+
> Report+and+Embedding+it+to+MifosX and was able to create the report to
> the end but when i run the report i get a blank page.
>
> Am using release 16.06.01 in Linux
>
> I inspected from Developer tool and find this error
>
>
>  1. {developerMessage: "The request caused a data integrity issue to be
>     fired by the database.",...}
>      1. defaultUserMessage:"Unable to create key: No loader was able to
>         handle the given key data:
>         /root/.mifosx/pentahoReports/Report_For_Mifos.prpt"
>      2. developerMessage:"The request caused a data integrity issue to
>         be fired by the database."
>      3. errors:[{,...}]
>          1. 0:{,...}
>              1. args:[]
>              2. defaultUserMessage:"Unable to create key: No loader was
>                 able to handle the given key data:
>                 /root/.mifosx/pentahoReports/Report_For_Mifos.prpt"
>              3. developerMessage:"Unable to create key: No loader was
>                 able to handle the given key data:
>                 /root/.mifosx/pentahoReports/Report_For_Mifos.prpt"
>              4. parameterName:null
>              5. userMessageGlobalisationCode:"error.msg.reporting.error"
>              6. value:null
>      4. httpStatusCode:"403"
>      5. userMessageGlobalisationCode:"error.msg.reporting.error"
>
>
> what could it be the cause?
>
> Thanks in advance.
>
> --
> Mexina M Daniel
> Lead Software Developer
> Research & Development
>
> Tel:+255 222 618 511 | Mob: +255 712 110 791
>
> Singo Africa Limited
> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es
> Salaam
>
> singo.co.tz
>
> Lets grow together
>
>
>
> --
> Mexina M Daniel
> Lead Software Developer
> Research & Development
>
> Tel:+255 222 618 511 | Mob: +255 712 110 791
>
> Singo Africa Limited
> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam
>
> singo.co.tz
>
> Lets grow together
>
>
>
>
>
> --
>
> Mexina M Daniel
>
> Lead Software Developer
>
> Research & Development
>
>
>
> Tel:+255 222 618 511 | Mob: +255 712 110 791
>
>
>
> Singo Africa Limited
>
> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam
>
>
>
> singo.co.tz
>
>
>
> Lets grow together
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message