[Mifos-users] Designing New Pentaho Reports (Mifos 2.5 , Tomcat 6.0.35, Java 1.7 ) - Assistance

[Thomas (Uganda)]

Hello

Apologies for cross posting, I need some guidance in designing new
Pentaho reports. Am running on Tomcat, Mifos 2.5 and Java 1.7

I have created a report using Pentaho report designer and can view the
report's information using the pentaho report designer. But when I
upload the report's .prpt file to mifos 2.5 i get the error below.

I even tried to upload the .prpt file directly into the C:\Program
Files\Apache Software Foundation\Tomcat 6.0\webapps\mifos\WEB-INF
\classes\pentaho where the Pentaho reports are stored but that too
didn't help

Any one who has come across this and managed to get a solution?

Thanks in advance.

Error stack trace
****************************************************************************************
org.mifos.core.MifosRuntimeException:
org.pentaho.reporting.libraries.resourceloader.ResourceLoadingException:
Failed to open URL connection
at
org.mifos.reports.pentaho.service.PentahoReportsServiceImpl.loadReport(PentahoReportsServiceImpl.java:
280)
at
org.mifos.reports.pentaho.service.PentahoReportsServiceImpl.getParametersForReport(PentahoReportsServiceImpl.java:
265)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
859)
at org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:
489)
at java.lang.Thread.run(Unknown Source)
Caused by:
org.pentaho.reporting.libraries.resourceloader.ResourceLoadingException:
Failed to open URL connection
at
org.pentaho.reporting.libraries.resourceloader.loader.URLResourceData.getResourceAsStream(URLResourceData.java:
128)
at
org.pentaho.reporting.libraries.resourceloader.loader.AbstractResourceData.getResource(AbstractResourceData.java:
101)
at
org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader.loadBundle(ZipResourceBundleLoader.java:
81)
at
org.pentaho.reporting.libraries.resourceloader.DefaultResourceManagerBackend.loadResourceBundle(DefaultResourceManagerBackend.java:
389)
at
org.pentaho.reporting.libraries.resourceloader.ResourceManager.loadResourceBundle(ResourceManager.java:
262)
at
org.pentaho.reporting.libraries.resourceloader.ResourceManager.load(ResourceManager.java:
284)
at
org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:
405)
at
org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:
370)
at
org.pentaho.reporting.libraries.resourceloader.ResourceManager.createDirectly(ResourceManager.java:
207)
at
org.mifos.reports.pentaho.service.PentahoReportsServiceImpl.loadReport(PentahoReportsServiceImpl.java:
276)
... 77 more
****************************************************************************************


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users

[Lukasz Chudy]

Hi Thomas,

It is possible that this problem is related to Tomcat. To be sure about
this, please try to upload this report on one of our test servers and
check if you are getting the same error.

Best regards,
Lukasz

[Thomas (Uganda)]

Hello Lukasz;

After setting up Jetty 7.3 as per your instructions, I have tried
uploading the report that I had designed in Pentaho Report Designer
But the Same Error of 'Failed to open URL connection", still shows
up.

My query is, all the default reports that come with mifos are working
fine. What I need to get to learn is how to design new reports, the
same way the default reports were designed.

Regards,

------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev

[Lukasz Chudy]

Hi Thomas,

Did you follow the instructions from this wiki page:
https://mifosforge.jira.com/wiki/display/MIFOS/Pentaho+Report+Designer+-+connecting+to+local+database
?

Best regards,
Lukasz

[Thomas (Uganda)]

Hi Lukasz,

Finally got this to work Thanks a lot.

So I realised only when I have the .mifos folder on the Home
Directory i.e C:\.mifos
Then the new designed reports can be uploaded and viewed.

Tx

On Oct 5, 4:21 pm, Lukasz Chudy <lch...@soldevelo.com> wrote:
> Hi Thomas,
>

> Did you follow the instructions from this wiki page:https://mifosforge.jira.com/wiki/display/MIFOS/Pentaho+Report+Designe...

> ?
>
> Best regards,
> Lukasz
>
> On 10/04/2012 03:38 PM, Thomas (Uganda) wrote:
>
>
>
> > Hello Lukasz;
>
> > After setting up Jetty 7.3 as per your instructions, I have tried
> > uploading the report that I had designed in Pentaho Report Designer
> > But the Same Error of  'Failed to open URL connection", still shows
> > up.
>
> > My query is, all the default reports that come with mifos are working
> > fine. What I need to get to learn is how to design new reports, the
> > same way the default reports were designed.
>
> > Regards,
>
> > ------------------------------------------------------------------------------
> > Don't let slow site performance ruin your business. Deploy New Relic APM
> > Deploy New Relic app performance management and know exactly
> > what is happening inside your Ruby, Python, PHP, Java, and .NET app
> > Try New Relic at no cost today and get our sweet Data Nerd shirt too!
> >http://p.sf.net/sfu/newrelic-dev2dev
> > _______________________________________________
> > Mifos-users mailing list

> > Mifos-us...@lists.sourceforge.net

> >https://lists.sourceforge.net/lists/listinfo/mifos-users
>
> ------------------------------------------------------------------------------
> Don't let slow site performance ruin your business. Deploy New Relic APM
> Deploy New Relic app performance management and know exactly
> what is happening inside your Ruby, Python, PHP, Java, and .NET app

> Try New Relic at no cost today and get our sweet Data Nerd shirt too!http://p.sf.net/sfu/newrelic-dev2dev
> _______________________________________________
> Mifos-users mailing list
> Mifos-us...@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/mifos-users

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_nov