Alfresco Jasper Reports integration

[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