Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Problem Integrating Pentaho 3.9 and Birt 2.6

  1. #1

    Default Problem Integrating Pentaho 3.9 and Birt 2.6

    Hi!

    I am doing a comparative between different open source BI solutions. One of the requirements is integration with BIRT. I have a problem integrating Pentaho and BIRT - I am using Pentaho 3.9 and Birt 2.6. I have followed http://b-e-o.blogspot.com.es/2011/08...ipse-birt.html

    I will reproduce here the steps that I have followed:

    1- Copy from Birt runtime 2.6 the WebViewerExample to my Pentaho server's webapps folder (/biserver-ce/tomcat/webapps/).
    2- Change /biserver-ce/tomcat/webapps/WebViewerExample/WEB-INF/web.xml adding the following BIRT_VIEWER_WORKING_FOLDER parameter:

    <context-param>
    <param-name>BIRT_VIEWER_WORKING_FOLDER</param-name>
    <param-value>"path-to-my-pentaho-installation"/biserver-ce/pentaho-solutions</param-value>
    </context-param>

    3- Copy the needed common-logging libraries to /biserver-ce/tomcat/webapps/WebViewerExample/WEB-INF/lib.
    4- Test if this application was installed and configured correctly by firing up my Pentaho server and going to http://localhost:8080/WebViewerExample/.
    5- Copy the birt-plugin - I have download it from https://docs.google.com/viewer?a=v&p...hZjM3&hl=en_US - example to /biserver-ce/pentaho-solutions/system and report example to /biserver-ce/pentaho-solutions/steel-wheels/reports.
    6- Edit birt-plugin/plugin.xml point to the BIRT web viewer and pass in the correct path, solution and action values:

    <command>http://localhost:8080/WebViewerExample/frameset?__report={solution}/{path}/{name}</command>

    7 - Change the ‘acl-files’ element in /pentaho-solutions/system/pentaho.xml, so it looks :

    xaction,url,prpt,xdash,xcdf,rptdesign


    NOTE: I have tested the same with Pentaho 3.7 and have the same problem - so I suppose that I am doing something wrong.

    The problem is that after doing all the steps found in the turorial I cannot see any Birt reports.

    Could anyone help me with this?

    Best Regards.

  2. #2

    Default

    The steps you have taken seem to be correct.
    Could you see the BIRT WebViewer application in 4?
    Did you modify the command in 6. to the correct hostname?
    Anything in the logs?

    Regards,
    Bart

  3. #3

    Default

    Hi!

    1- Yes, I can see the BIRT WebViewer and view a sample.
    2- Could you give me an example of a correct command? Maybe my mistake is here. I have: <command>http://localhost:8080/WebViewerExample/frameset?__report={solution}/{path}/{name}</command>
    3- In the logs I only have - pentaho.log file -:

    "2012-06-14 12:39:48,720 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-06-14 12:39:48,783 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]"

    Several times.

    Regards.
    Last edited by fjavier.valdes; 06-14-2012 at 06:40 AM.

  4. #4

    Default

    I forgot to say that I am using Windows 7.

    Regards

  5. #5

    Default

    That command should be ok if you run Pentaho on your local machine. What host name do you use to access your Pentaho server?

  6. #6

    Default

    Hi!

    I have installed Pentaho in my local machine - so its localhost.
    Now I can see the reports, it was my fault, because I do not use Tools -> Update. When I used it I can see the reports. Sorry.
    The problem that I have now is when I select one report I get the following exception:
    "org.eclipse.birt.report.exception.ViewerException: There is no report design object available."

    In log files I get:

    1) pentaho.log: 2012-06-14 16:58:39,893 ERROR [org.pentaho.platform.engine.core.system.SystemSettings] ::: SYSTEMSETTINGS.ERROR_0002 - The file "path-tp-pentaho"\pentaho-solutions\system\birt-plugin\settings.xml does not exist.
    2) catalina.log: 14-jun-2012 16:58:39 org.eclipse.birt.report.engine.api.impl.ReportEngineHelper getReportDesignHandle
    GRAVE: invalid design file file:/"path-tp-pentaho"/pentaho-solutions/steel-wheels/reports/SalesInvoice.rptdesign

    NOTES: "path-to-pentaho" is where I have installed Pentaho and the reports that I am testing are the same that works perfectly in the BIRT WebViewer application and the plugin sample "SalesInvoice.rptdesign".

    Regards.
    Last edited by fjavier.valdes; 06-14-2012 at 11:35 AM.

  7. #7

    Default

    i have issue when try to run the report within pentaho the error in pentaho.log is the following

    this is the birt-plugin i am using https://docs.google.com/viewer?a=v&p...hZjM3&hl=en_US

    00:15:54,584 ERROR [SystemSettings] ::: SYSTEMSETTINGS.ERROR_0002 - File /home/pentaho/biserver-ee/pentaho-solutions/system/birt-plugin/settings.xml does not exist

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.