You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Shreyaank Byadagi <sh...@confluxtechnologies.com> on 2016/10/01 02:19:53 UTC
RE: Pentaho Report in Mifos
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" <th...@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 <th...@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
>
Re: Pentaho Report in Mifos
Posted by Mexina M Daniel <me...@singo.co.tz>.
Hi Shreyaank
I have checked all those and find them okay and i can run the report
from pentaho reporting designer.
I have deselected the scripting language during pasting global scripting
from the tutorial link, the error went away
But still, i can't see the report when i run it in community-app
Also i have seen the compatibility issue in the tutorial " Note:
Compatible pentaho report designer version is - 3.9.1"
Could that be an issue? because am using Pentaho Reporting Designer
version 6.1.0.1.
Best Regards
On 10/01/2016 05:19 AM, Shreyaank Byadagi wrote:
>
> 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
> <ma...@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
> <ma...@singo.co.tz>]
> Sent: Friday, 30 September, 2016 14:30
> To: Thynn Win <thynn.win@thitsaworks.com
> <ma...@thitsaworks.com>>
> Cc: dev (dev@fineract.incubator.apache.org
> <ma...@fineract.incubator.apache.org>)
> <dev@fineract.incubator.apache.org
> <ma...@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
> <ma...@singo.co.tz>]
> Sent: 27 September 2016 17:46
> To: dev@fineract.incubator.apache.org
> <ma...@fineract.incubator.apache.org><mailto:dev@fineract.incubator.apache.org
> <ma...@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+
> <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 <http://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 <http://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 <http://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