Alfresco Jasper Reports integration

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

msvoren

Hello,
I successfully installed Enterprise Reporting_1.0_RC2, report integration module for Alfresco.
So, i can upload reports, I can select report type, i can execute report generation.

The thing is, I can not execute reports which connect to database take values from database (I can execute those which don't have any db connection).

I made jrxml report in iReport desktop application. I can execute report through iReports, I get data, everything.. But when i run it in Alfresco, I get red messages saying "NULL value" or " nodeRef is NULL"..

How this works? How Alfresco knows from which database i want to get my data? In jrxml, there are only queries, not db connectors.. Where can I configure db connection for alfresco reporting?

Am I missing some libraries? i installed reports integration as in manuals. Also added jasperreports-2.0.5.jar to lib dir..

Thanks for replies in advance,
M

major_king

Hi msvoren,

which alfresco-version have you installed with the reporting enginge? I'm using alfresco 2.9.0C dev.

Can you run "hello world"reports? I can upload reports successful but when i want to run the report, i get an error page 😞

 Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

java.lang.IllegalAccessError: tried to access field org.alfresco.web.bean.dialog.BaseDialogBean.nodeService from class tr.biz.vardar.web.bean.RunReportDialog
   tr.biz.vardar.web.bean.RunReportDialog.init(RunReportDialog.java:89)
   org.alfresco.web.bean.dialog.DialogManager.setCurrentDialog(DialogManager.java:128)
   org.alfresco.web.app.AlfrescoNavigationHandler.handleDialogOpen(AlfrescoNavigationHandler.java:630)
   org.alfresco.web.app.AlfrescoNavigationHandler.handleNavigation(AlfrescoNavigationHandler.java:116)
   org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:82)
   javax.faces.component.UICommand.broadcast(UICommand.java:109)
   javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)
   javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171)
   org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
   org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)
   org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)
   javax.faces.webapp.FacesServlet.service(FacesServlet.java:139)
   org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.23 logs.‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Anyone an idea for the reason?

Regards,
christian