Liferay Jasper integration - Aperte Reports

[12年前 に Tomek Lipski によって更新されました。]

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.

[12年前 に Cyprian Gajda によって更新されました。]

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.

[12年前 に 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 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

[12年前 に Tomek Lipski によって更新されました。]

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

[12年前 に Cyprian Gajda によって更新されました。]

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

[9年前 に Satish Avhad によって更新されました。]

Hi,

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

regards,
Satish