Hitachi Vantara Pentaho Community Forums
Results 1 to 16 of 16

Thread: Problems integrating my on report

  1. #1
    Join Date
    Dec 2005
    Posts
    16

    Default Problems integrating my on report

    Hi all,

    I have installed the pentaho demo, JDK is 1.5.0_05 and the RCP Birt Application. Pentaho runs fine. I created a BIRT-Report that talks to a PostgreSQL-Database. For this I had to use the PostgreSQL JDBC 3 Driver I found at
    Code:
    jdbc.postgresql.org
    for PostgreSQL 7.4.x. The Report displays correctly.

    Now following the "Creating Pentaho Solutions" document I tried to get my report running on the pentaho server. I downloaded the Pentaho Workbench, created an action sequence (see attachment), placed the JDBC-Driver under
    Code:
    pentaho-demo\\jboss\\server\\default\\lib
    and the two files
    Code:
    test.rptdesign
    and
    Code:
    test.xaction
    into
    Code:
    pentaho-demo\\pentaho-solutions\\samples\\reporting
    .

    Calling

    Code:
    http://localhost:8080/pentaho/ViewAction?&solution=samples&path=reporting&action=test.xaction
    Results in the following. Any idea?

    Code:
    Failed
    --------------------------------------------------------------------------------
     
    [de_72] Error: [de_103] BIRT.ERROR_0007 - [de_2] error running report C:\\dev\\pentaho-demo\\pentaho-solutions\\samples\\reporting\\test.rptdesign (org.pentaho.birt.BIRTReportComponent)
    [de_69] Debug: [de_21] Starting execute of samples/reporting/test.xaction (org.pentaho.solution.SolutionEngine)
    [de_69] Debug: [de_30] Getting runtime context and data (org.pentaho.solution.SolutionEngine)
    [de_69] Debug: [de_33] Loading action sequence definition file (org.pentaho.solution.SolutionEngine)
    [de_69] Debug: [de_34] audit: instanceId=0e7b697b-6caa-11da-bd25-9b87d399a314, objectId=org.pentaho.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.runtime.RuntimeContext)
    [de_69] Debug: [de_1] validateComponent validating component org.pentaho.birt.BIRTReportComponent (org.pentaho.runtime.RuntimeContext)
    [de_69] Debug: [de_75] Validating component for action test.xaction (org.pentaho.birt.BIRTReportComponent)
    [de_69] Debug: [de_42] Executing action sequence (org.pentaho.runtime.RuntimeContext)
    [de_69] Debug: [de_24] Executing action definition: Iteration {0}0 (org.pentaho.runtime.RuntimeContext)
    [de_69] Debug: [de_34] audit: instanceId=0e7b697b-6caa-11da-bd25-9b87d399a314, objectId=org.pentaho.birt.BIRTReportComponent, messageType=component_execution_started (org.pentaho.runtime.RuntimeContext)
    [de_69] Debug: [de_3] execute pre-audit (org.pentaho.runtime.RuntimeContext)
    [de_69] Debug: [de_21] Setting component log level to DEBUG (org.pentaho.runtime.RuntimeContext)
    [de_69] Debug: [de_11] Initializing component (org.pentaho.runtime.RuntimeContext)
    [de_69] Debug: [de_4] executeComponent starting audited execute (org.pentaho.runtime.RuntimeContext)
    [de_69] Debug: [de_94] execute validation=true (org.pentaho.birt.BIRTReportComponent)
    [de_69] Debug: [de_17] executing reportDefinition C:\\dev\\pentaho-demo\\pentaho-solutions\\samples\\reporting\\test.rptdesign of type html (org.pentaho.birt.BIRTReportComponent)
    [de_69] Debug: [de_16] birtHome set to C:\\dev\\pentaho-demo\\pentaho-solutions\\system/BIRT (org.pentaho.birt.BIRTReportComponent)
    [de_72] Error: [de_103] BIRT.ERROR_0007 - [de_2] error running report C:\\dev\\pentaho-demo\\pentaho-solutions\\samples\\reporting\\test.rptdesign (org.pentaho.birt.BIRTReportComponent)
    [de_69] Debug: [de_15] executeComponent finished audited execute (org.pentaho.runtime.RuntimeContext)
    [de_72] Error: [de_103] RuntimeContext.ERROR_0012 - [de_33] ActionDefinition for org.pentaho.birt.BIRTReportComponent did not execute successfully (org.pentaho.runtime.RuntimeContext)
    [de_72] Error: [de_103] SolutionEngine.ERROR_0007 - [de_27] Action sequence execution failed (org.pentaho.solution.SolutionEngine)
    http://forums.pentaho.org/archived_a...st.xaction.txt

    Post edited by: mazloumi, at: 12/14/2005 10:36

  2. #2
    Join Date
    Dec 2005
    Posts
    16

    Default Re:Problems integrating my on report

    Alright some things I found out so far:
    - The Reports my BIRT Editor is creating are of version 3 and not 2 required by pentaho. I created two reports one with a simple table and one with a diagram. Changing the version numbers helped out partially. The table is now displayed while the diagram report results in the following error:

    Code:
    16:57:25,625 INFO  [STDOUT] org.eclipse.emf.ecore.xmi.FeatureNotFoundException: Feature 'Title' not found. (test.chart, 189, 14)
    16:57:25,625 INFO  [STDOUT]     at org.eclipse.emf.ecore.xmi.impl.XMLHandler.reportUnknownFeature(XMLHandler.java:1168)
    16:57:25,625 INFO  [STDOUT]     at org.eclipse.emf.ecore.xmi.impl.XMLHandler.handleUnknownFeature(XMLHandler.java:1138)
    16:57:25,625 INFO  [STDOUT]     at org.eclipse.emf.ecore.xmi.impl.XMLHandler.handleFeature(XMLHandler.java:1099)
    16:57:25,625 INFO  [STDOUT]     at org.eclipse.emf.ecore.xmi.impl.XMLHandler.processElement(XMLHandler.java:448)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.emf.ecore.xmi.impl.XMLHandler.startElement(XMLHandler.java:431)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.emf.ecore.xmi.impl.SAXWrapper.startElement(SAXWrapper.java:75)
    16:57:25,640 INFO  [STDOUT]     at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at javax.xml.parsers.SAXParser.parse(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.emf.ecore.xmi.impl.XMLLoadImpl.load(XMLLoadImpl.java:129)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.emf.ecore.xmi.impl.XMLResourceImpl.doLoad(XMLResourceImpl.java:155)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.emf.ecore.resource.impl.ResourceImpl.load(ResourceImpl.java:895)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.chart.model.impl.SerializerImpl.fromXml(SerializerImpl.java:377)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.chart.reportitem.ChartReportItemImpl.deserialize(ChartReportItemImpl.java:215)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.report.model.extension.PeerExtensibilityProvider.initializeReportItem(PeerExtensibilityProvider.java:377)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.report.model.elements.ExtendedItem.initializeReportItem(ExtendedItem.java:273)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.report.model.api.ExtendedItemHandle.loadExtendedElement(ExtendedItemHandle.java:99)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.chart.reportitem.ChartReportItemQueryImpl.setModelObject(ChartReportItemQueryImpl.java:60)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitExtendedItem(ReportQueryBuilder.java:325)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.report.engine.ir.ExtendedItemDesign.accept(ExtendedItemDesign.java:30)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.buildQuery(ReportQueryBuilder.java:191)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:123)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.report.engine.data.dte.DteDataEngine.prepare(DteDataEngine.java:173)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:132)
    16:57:25,640 INFO  [STDOUT]     at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:159)
    16:57:25,640 INFO  [STDOUT]     at org.pentaho.birt.BIRTReportComponent.generateReport(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.pentaho.birt.BIRTReportComponent.executeAction(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.pentaho.component.ComponentBase.execute(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.pentaho.runtime.RuntimeContext.executeComponent(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.pentaho.runtime.RuntimeContext.executeAction(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.pentaho.runtime.RuntimeContext.executeLoop(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.pentaho.runtime.RuntimeContext.executeSequence(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.pentaho.runtime.RuntimeContext.executeSequence(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.pentaho.solution.SolutionEngine.execute(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.pentaho.services.BaseRequestHandler.handleActionRequest(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.pentaho.ui.servlet.ViewAction.doGet(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
    16:57:25,640 INFO  [STDOUT]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    16:57:25,640 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    16:57:25,640 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    16:57:25,640 INFO  [STDOUT]     at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    16:57:25,640 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    16:57:25,640 INFO  [STDOUT]     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    16:57:25,640 INFO  [STDOUT]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    16:57:25,640 INFO  [STDOUT]     at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.jboss.web.tomcat.security.JaccContextValve.invoke(Unknown Source)
    16:57:25,640 INFO  [STDOUT]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    16:57:25,640 INFO  [STDOUT]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    16:57:25,640 INFO  [STDOUT]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    16:57:25,640 INFO  [STDOUT]     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    16:57:25,640 INFO  [STDOUT]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    16:57:25,640 INFO  [STDOUT]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
    16:57:25,640 INFO  [STDOUT]     at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    16:57:25,656 INFO  [STDOUT]     at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    16:57:25,656 INFO  [STDOUT]     at java.lang.Thread.run(Unknown Source)
    Now the
    Code:
    org.eclipse.emf.ecore.xmi.FeatureNotFoundException
    tells me that the class
    Code:
    Title
    is not defined yet. So I guess the data model used by my BIRT is newer that the one used by the pentaho server and therefore the server fails to load the report. Am I correct?

    - The second thing I noticed: I always have to restart the server to see changes I made on the report, right? Is there a simpler way - something like hot deployment?

    Greetings,
    Nima

  3. #3
    Join Date
    Dec 2005
    Posts
    16

    Default Re:Problems integrating my on report

    For some strange reason while the server results in the above error for my diagram report the browser displays:

    Code:
    [de_121] Action Successful
    --------------------------------------------------------------------------------
     
    report-output=org.pentaho.repository.content.ContentItem@1610bc79
    Any idea? Which version of the BIRT-Editor do I need to create diagrams that can be rendered by Pentaho? But maybe an easier way would be to update the pentaho demo server to use the latest BIRT libraries.

  4. #4
    Join Date
    Sep 2005
    Posts
    22

    Default Re:Problems integrating my on report

    hi


    you are having a system update facility in pentaho
    if you publish over there then you can see the changes
    which you have made without restarting the system

    The other problem you are facing was due to the version
    of the BIRT . I hope you can solve this problem by copy paste the corresponding plugin from eclipse to pentaho

    regards,
    siva

  5. #5
    jdixon Guest

    Default Re:Problems integrating my on report

    mazloumi,

    for the problem where you are seeing

    Code:
    report-output=org.pentaho.repository.content.ContentItem@1610bc79
    Your action sequence is saving your report output to the Content Repository instead of sending it to the browser. Make sure that you do not have 'report-output' defined as an output of the report component. This is the instruction that is causing your report to go to the repository.

  6. #6
    Join Date
    Dec 2005
    Posts
    16

    Default Re:Problems integrating my on report

    siva: thank you. Do you know which plugins I need to replace?

    I have found some plugins under

    pentaho-demo\\pentaho-solutions\\system\\BIRT\\plugins
    Two things:
    - Where do I find the update facility?
    - Why is the folder pentaho-solutions outside pentaho.war?

  7. #7
    Join Date
    Dec 2005
    Posts
    16

    Default Re:Problems integrating my on report

    James Dixon,

    thank you. I remove that part. Now at least I don't get this message in the browser. But still the error message that EMF cannot find the feature Title. As I posted above I guess I need to replace some jars with the latest of birt.

    But one question: You say that reports can be stored in the content repository. How can I access those reports?

  8. #8
    Join Date
    Sep 2005
    Posts
    22

    Default Re:Problems integrating my on report

    hi

    on your home page of pentaho you will get "settings and services"
    if you move to update and settings and contents you will get
    the publish optons

    what ever you have changed publish here your whole system will get refreshed

    then regarding the plugins i don't know exactly but for you it is showing some thing regarding the emf so better take

    /eclipse/plugins/org.eclipse.emf.* [take these pluggins from eclipse and get it in the folder which you have identified ]

    hope you are using the version 0.9.7.1
    is it so

    can i know on what what basis you are using pentaho ????

  9. #9
    Join Date
    Sep 2005
    Posts
    22

    Default Re:Problems integrating my on report

    hi

    on your home page of pentaho you will get "settings and services"
    if you move to update and settings and contents you will get
    the publish optons

    what ever you have changed publish here your whole system will get refreshed

    then regarding the plugins i don't know exactly but for you it is showing some thing regarding the emf so better take

    /eclipse/plugins/org.eclipse.emf.* [take these pluggins from eclipse and get it in the folder which you have identified ]

    hope you are using the version 0.9.7.1
    is it so

    can i know on what what basis you are using pentaho ????

  10. #10
    gmoran Guest

    Default Re:Problems integrating my on report

    Hi there,

    Regarding your question about why the pentaho-solutions exist outside of the pentaho.war, the answer is good architecture.

    The "pentaho-solutions" directory is just the default solutions directory; it lives outside of the war because in a typical J2EE environment, .war files are packages that get exploded when a web application is deployed, and are in some cases overwritten whenever an application server is restarted. So you can see why you would not want to put files that you may want to add to or modify in the war package. Some application servers, like BEA Weblogic, won't even give you the opportunity to modify files in the .war at all.

    best regards,
    Gretchen

  11. #11
    Join Date
    Dec 2005
    Posts
    16

    Default Re:Problems integrating my on report

    Thx siva and moran.

    siva: my birt version is 1.0.1

    siva: I am evaluating pentaho for a financial site project. So far it looks really good but I need to get the latest version of birt running which troubles me a bit. Maybe the pentaho developers can provide us with little how-to regarding upgrade of components.

    moran: where in pentaho is jboss told to use the external directory pentaho-solutions?

  12. #12
    gmoran Guest

    Default Re:Problems integrating my on report

    The solutions directory can be specified in the web.xml for the pentaho.war. You can find detailed instructions for setting the solutions directory in our Advanced Install Guide at http://www.pentaho.org/downloads/doc.

    We have many how-to documents slated for publishing shortly after our GA release. I have passed on your request for a component upgrade how-to to the team. It's a great idea! We also would be happy to accept any how-tos generated by the community as a contribution to the goal

    regards,
    Gretchen

  13. #13
    Join Date
    Dec 2005
    Posts
    16

    Default Re:Problems integrating my on report

    I tried copying the birt plugins of version 1.0.1 but it didnt work. It was always asking for the plugin org.eclipse.birt.report.data.oda.jdbc though it exists under pentaho-demo\\pentaho-solutions\\system\\BIRT\\plugins

  14. #14
    Join Date
    Feb 2006
    Posts
    9

    Default Re:Problems integrating my on report

    Hi mazloumi, your problem are same with me,
    but I don't know where the command >>
    [code] report-output=org.pentaho.repository.content.ContentItem@1610bc79
    should put into ?
    please tell me how you do doing.


    Thanks..

  15. #15
    Join Date
    Feb 2006
    Posts
    9

    Default Re:Problems integrating my on report

    Hi all,
    I have installed pentaho PCI-1.0.0 version and have made a .rptdesign running well. but since I have made a test.xaction the report cannot running and show the following message:
    Code:
    Error: BIRT.ERROR_0007 - error running report D:\\pentaho-demo\\pentaho-solutions\\tactical\\reporting\\tes.rptdesign (org.pentaho.birt.BIRTReportComponent)
    Debug: Starting execute of tactical/reporting/tes.xaction (org.pentaho.solution.SolutionEngine)
    Debug: Getting runtime context and data (org.pentaho.solution.SolutionEngine)
    Debug: Loading action sequence definition file (org.pentaho.solution.SolutionEngine)
    Debug: audit: instanceId=37e6503b-e5b6-11da-b17b-5bc4d1cf2cca, objectId=org.pentaho.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.runtime.RuntimeContext)
    Debug: validateComponent validating component org.pentaho.birt.BIRTReportComponent (org.pentaho.runtime.RuntimeContext)
    Debug: Validating component for action tes.xaction (org.pentaho.birt.BIRTReportComponent)
    Debug: Executing action sequence (org.pentaho.runtime.RuntimeContext)
    Debug: Executing action definition: Iteration {0}0 (org.pentaho.runtime.RuntimeContext)
    Debug: audit: instanceId=37e6503b-e5b6-11da-b17b-5bc4d1cf2cca, objectId=org.pentaho.birt.BIRTReportComponent, messageType=component_execution_started (org.pentaho.runtime.RuntimeContext)
    Debug: execute pre-audit (org.pentaho.runtime.RuntimeContext)
    Debug: Setting component log level to DEBUG (org.pentaho.runtime.RuntimeContext)
    Debug: Initializing component (org.pentaho.runtime.RuntimeContext)
    Debug: executeComponent starting audited execute (org.pentaho.runtime.RuntimeContext)
    Debug: execute validation=true (org.pentaho.birt.BIRTReportComponent)
    Debug: executing reportDefinition D:\\pentaho-demo\\pentaho-solutions\\tactical\\reporting\\tes.rptdesign of type html (org.pentaho.birt.BIRTReportComponent)
    Debug: birtHome set to D:\\pentaho-demo\\pentaho-solutions\\system/BIRT (org.pentaho.birt.BIRTReportComponent)
    Error: BIRT.ERROR_0007 - error running report D:\\pentaho-demo\\pentaho-solutions\\tactical\\reporting\\tes.rptdesign (org.pentaho.birt.BIRTReportComponent)
    Debug: executeComponent finished audited execute (org.pentaho.runtime.RuntimeContext)
    Error: RuntimeContext.ERROR_0012 - ActionDefinition for org.pentaho.birt.BIRTReportComponent did not execute successfully (org.pentaho.runtime.RuntimeContext)
    Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.solution.SolutionEngine)
    who can help me how to correct the error.
    Thanks for all

    Oh yea here the listing test.xaction file http://forums.pentaho.org/archived_a...s/test.xaction

  16. #16
    Join Date
    Nov 1999
    Posts
    579

    Default Re:Problems integrating my on report

    I suggest you check the server.log file for extended error information. Often, that's the place to start when you get an error running a report, or when you have other issues.

    I hope this helps,

    Marc

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.