Alfresco - BIRT Reports

[nh]

Hi All,

We are using the BIRT report designer plugin for eclipse and generating the BIRT definition files for our requirement. The datasaource and the dataset is configured accordingly and the report works fine when previewed from the report designer in eclipse.

However, we uploaded the same .rptdesign file in Alfresco and tried running the report [ by clicking the Run Report icon] an empty report  with static text is generated. Even though the datasource is configured, the db data is not fetched.

this is the piece of code that is present in the rptdesign file for the datasource info.

<data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="myreport" id="4">
            <property name="odaDriverClass">com.mysql.jdbc.NonRegisteringDriver</property>
            <property name="odaURL">jdbc:mysql://localhost:8080/alfresco</property>
            <property name="odaUser">alfresco</property>
            <encrypted-property name="odaPassword">alfresco</encrypted-property>
        </oda-data-source>
    </data-sources>


Is there any other setting to be done?
Are ny parameters to be configured ?

Please assist me on this.

Thanks in Advance

[gavinc]

Have you added the JDBC driver for your datasource in the appserver?

Place the file in /alfresco/tomcat/common/lib

[nh]

gavin,

i have the jar in place since deployment. the problem still persists.


Few more hints pls.

[gonenc]

NH,

Are you using the "Enterprise Report Services for Alfresco" ? If you are, can we move this thread to forge projects forum for traceability? (By moving I mean can we repost this in the projects Forum)

http://forge.alfresco.com/projects/report-services/

[nh]

Hi,

We have integrated the Birt engine in our alfresco implementation.
We are designing the birt design files exteranally and uiploading it in alfresco.

We are able to "Execute Report" and see the preview.
However, when we select the option of output file and destination directory we are getting this error..


17:06:29,928 ERROR [ui.common.Utils] A system error happened during the operation: ASPECT_UIFACETS
java.lang.NoSuchFieldError: ASPECT_UIFACETS
        at tr.biz.vardar.reporting.ReportServiceImpl.createNewReportOutputNode(ReportServiceImpl.java:343)
        at tr.biz.vardar.reporting.ReportServiceImpl.runAndAddReportOutputToAlfresco(ReportServiceImpl.java:277)
        at tr.biz.vardar.web.bean.RunReportDialog.finishImpl(RunReportDialog.java:182)
        at org.alfresco.web.bean.dialog.BaseDialogBean.finish(BaseDialogBean.java:115)
        at org.alfresco.web.bean.dialog.DialogManager.finish(DialogManager.java:335)
        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:585)
        at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129)
        at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
        at javax.faces.component.UICommand.broadcast(UICommand.java:106)
        at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90)
        at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164)
        at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:316)
        at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:105)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java
:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)


Please Help!!

Thanks,
NH

[gonenc]

Hi,

The reason for this is simple. The ASPECT_UIFACETS moved from ContentModel to ApplicationModel with the release of 2.0. If you are using Alfresco 2.0 then you should use the latest release candidate of Enterprise report services. If you are using an Alresco version prior to 2.0 then you should actually use RC1 release of Enterprise Report Services.

If you are building reports for Alfresco, can you contribute these reports to our project? We are currently working on building Alfresco reports. If it is appropriate we would like to include Alfresco reports with the next release.

Gonenc Ercan

[nh]

Gonenc ,
Thanks for the reply…


I tried to fish out for the latest version of the enterprise report release but cudnt find one. seems we might have to live with the error until the new compatible version is released. Or could you please let me knw whether the 2.0 update of the report is out and where could i get it?

Do we have a work around??

Please help.

NH

P.S : We are working on the reports and if everything falls in place and we have a decent working model of the reports, we would certainly contribute to Alfresco reports.

[gonenc]

I'm sure that this one works with the Alfresco 2.0;

http://forge.alfresco.com/frs/?group_id=20

You probably have RC1. You should be using RC2 with Alfresco 2.0.

http://forge.alfresco.com/projects/report-services/

For all the reporting issues please try to use the forum in that site. I noticed this thread by chance.