fineract-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thynn Win <thynn....@thitsaworks.com>
Subject RE: Pentaho Report in Mifos
Date Fri, 30 Sep 2016 09:15:50 GMT
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