Kombinierte Ansicht Flache Ansicht Baumansicht
Threads [ Zurück | Nächste ]
toggle
Tomek Lipski
Liferay Jasper integration - Aperte Reports
30. November 2011 03:33
Antwort

Tomek Lipski

Rang: Junior Member

Nachrichten: 33

Eintrittsdatum: 17. November 2010

Neue Beiträge

Hi all,

As the tools supplied by JasperSoft or Liferay, although great in itself, haven't met our requirements, we have created an integration between Jasper Reports and Liferay ourselves. The application is named Aperte Reports, and is available under GNU LGPL from Google Code repository: http://code.google.com/p/aperte-reports.

Its main features are:
  • Report dashboarding - you can compose results from different reports as one Liferay page (or even mix it with other portlets!)
  • On demand reporting with report parameters - users can run reports with supplied parameters. Parameter values/controls can be heavily customized.
  • Cyclic/background reporting - for the reports that run too long to be rendered on-line
  • Report drilldown
  • Subreport support

The plugin can be downloaded from Community plugins repository:

http://www.liferay.com/downloads/liferay-portal/community-plugins/-/software_catalog/products/11133217

and there is also a small on-line demo, available at:

https://demo.aperteworkflow.org/aperte-reports

You can also review my presentation given during Lightining Talks at Liferay Europe Symposium 2011: http://www.slideshare.net/tomeklipski/liferay-european-symposium-2011-lightning-talk-liferay-reporting-dashboarding

Please let me know if you have suggestions or feedbacks - it will be greatly appreciated.
Cyprian Gajda
RE: Liferay Jasper integration - Aperte Reports
30. Januar 2012 04:44
Antwort

Cyprian Gajda

Rang: New Member

Nachrichten: 9

Eintrittsdatum: 21. Januar 2011

Neue Beiträge

Aperte Reports v2.2.2 has been released on Jan 23rd 2012. Version 2 of Aperte Reports brings many fixes and improvements, including:
  • reworked user interface
  • reworked user interface
  • better error reporting and handling
  • support for Apache Tomcat and JBoss AS
  • support for common RDBMS: MySQL, PostgreSQL, Oracle, Hypersonic
For more information, you can review release notes or go straight to the download page.
Joe Chang
RE: Liferay Jasper integration - Aperte Reports
24. Februar 2012 04:09
Antwort

Joe Chang

Rang: New Member

Nachrichten: 11

Eintrittsdatum: 14. August 2011

Neue Beiträge

HI Cyprian,

When I try to install it, it shows the below error.

11:59:38,015 ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: java.lang.NullPointerException
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: java.lang.NullPointerException
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1345)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:303)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1337)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1601)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1590)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.liferay.portal.kernel.exception.SystemException: java.lang.NullPointerException
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:195)
at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findAll(ResourceActionPersistenceImpl.java:1043)
at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findAll(ResourceActionPersistenceImpl.java:962)
at com.liferay.portal.service.impl.ResourceActionLocalServiceImpl.checkResourceActions(ResourceActionLocalServiceImpl.java:47)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at com.liferay.portal.dao.jdbc.aop.DynamicDataSourceTransactionInterceptor.invoke(DynamicDataSourceTransactionInterceptor.java:44)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy67.checkResourceActions(Unknown Source)
at com.liferay.portal.service.ResourceActionLocalServiceUtil.checkResourceActions(ResourceActionLocalServiceUtil.java:230)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:112)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
... 21 more
Caused by: java.lang.NullPointerException
at org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge.nextTimestamp(RegionFactoryCacheProviderBridge.java:93)
at org.hibernate.impl.SessionFactoryImpl.openSession(SessionFactoryImpl.java:650)
at org.hibernate.impl.SessionFactoryImpl.openSession(SessionFactoryImpl.java:659)
at org.springframework.orm.hibernate3.SessionFactoryUtils.doGetSession(SessionFactoryUtils.java:318)
at org.springframework.orm.hibernate3.SessionFactoryUtils.doGetSession(SessionFactoryUtils.java:256)
at org.springframework.orm.hibernate3.SpringSessionContext.currentSession(SpringSessionContext.java:60)
at org.hibernate.impl.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:698)
at com.liferay.portal.dao.orm.hibernate.SessionFactoryImpl.openSession(SessionFactoryImpl.java:59)
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.openSession(BasePersistenceImpl.java:183)
at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findAll(ResourceActionPersistenceImpl.java:1027)
... 44 more
Tomek Lipski
RE: Liferay Jasper integration - Aperte Reports
24. Februar 2012 04:39
Antwort

Tomek Lipski

Rang: Junior Member

Nachrichten: 33

Eintrittsdatum: 17. November 2010

Neue Beiträge

Joe Chang:
HI Cyprian,

When I try to install it, it shows the below error.

11:59:38,015 ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: java.lang.NullPointerException
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: java.lang.NullPointerException
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findAll(ResourceActionPersistenceImpl.java:1027)
... 44 more


Hi,

It would be difficult to diagnose that error without full logs, but it seems like you have misconfigured Aperte Reports datasource (which should be bound to JNDI name jdbc/aperte-reports ).
Please review the Installation Guide for Aperte Reports to see if everything is configured properly.

You can also download Aperte Reports bundled and preconfigured with Liferay CE and app server from SourceForge repository: http://sourceforge.net/projects/aperte-reports/files/bundles/.

Oh, and we have issue tracker for Aperte Reports at google code. Feel free to post issues there: http://code.google.com/p/aperte-reports/issues/list

Best regards,

Tomek Lipski
Cyprian Gajda
RE: Liferay Jasper integration - Aperte Reports
4. April 2012 05:41
Antwort

Cyprian Gajda

Rang: New Member

Nachrichten: 9

Eintrittsdatum: 21. Januar 2011

Neue Beiträge

Aperte Reports 2.3-RC1 is available now!

Most important highlights and improvements are:
  • support for external JMS provider, e.g. Active MQ
  • fixes in background and cyclic reporting
  • dependency cleanup
  • default JNDI names configuration
  • logging cleanup
  • updated Jasper Reports dependency to the newest (4.5.1) version (resolves number format issues)
  • fixed display problems on LR 6.0EE and LR 6.1CE - application uses current Liferay theme.
For more information, you can review release notes or go straight to the download page.

Also check out a sample of Apert Reports on the demo site http://demo.aperteworkflow.org/aperte-reports
Satish Avhad
RE: Liferay Jasper integration - Aperte Reports
18. Juni 2014 06:02
Antwort

Satish Avhad

Rang: New Member

Nachrichten: 4

Eintrittsdatum: 29. März 2011

Neue Beiträge

Hi,

Is there a plan to release Aperte Reports for Liferay CE 6.2? When is it expected to be available?

regards,
Satish