Hitachi Vantara Pentaho Community Forums
Results 1 to 19 of 19

Thread: Birt 2.5 support

  1. #1
    Join Date
    May 2008
    Posts
    8

    Default Birt 2.5 support

    I needed Birt 2.5 integration on pentaho 3.0.0.

    Here you are

    http://jira.pentaho.com/browse/BISERVER-3464

    I've attached the jar in this message.


    To update the birt runtime, follow this pdf
    http://www.stratebi.es/Bugs/birt/Int...taho%202.0.pdf
    Don't do the 3rd part (Javascript bug solution)


    Only tested on Pentaho Community 3.0.0
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2009
    Posts
    25

    Default

    Hi thibautr,

    could you get it working?
    (the integration of birt 2.5 reports on pentaho 3.0)

    If yes, please could you help me. I am desperate because I have tried it since more than 1 week.

    I also followed your instructions, but without success.

    It would be a pleasure hearing from you.


    Thx+Bye
    ManInBlack
    Last edited by ManInBlack; 08-27-2009 at 08:33 AM.

  3. #3
    Join Date
    May 2008
    Posts
    8

    Default

    I'd like to help you but gimme more informations !

    What's wrong ?

  4. #4
    Join Date
    Aug 2009
    Posts
    25

    Default

    Hi thibautr,

    thank you for your answer.

    Now I also could get it running.
    (Birt 2.5 Report in Pentaho 3.0)

    But it only works with a simple birt report.

    Now I have a new problem:

    I programmed a birt open data access (oda) driver. If you don´t know oda, here you could get information to this topic:
    1)
    http://wiki.eclipse.org/Galileo_DTP_...I_Changes_Spec
    2)
    and the google_example:
    http://www.birt-exchange.org/devshar...e/#description

    After running a report in pentaho by using the google_example oda I get this exception:

    Code:
    The following items have errors:
    
    Table (id = 9):
    - An exception occurred during processing. Please see the following message for details:
    Cannot process the google.oda.ic driver's configurations.
    google.oda.ic
    
    exception.error ( 1 time(s) )
    detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
    Cannot process the google.oda.ic driver's configurations.
    google.oda.ic
        at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1166)
        at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1130)
        at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
        at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
        at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
        at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
        at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
        at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:64)
        at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
        at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:167)
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)
        at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportComponent.generateReport(BIRTReportComponent.java:507)
        at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportComponent.executeAction(BIRTReportComponent.java:307)
        at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:461)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1322)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1289)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1207)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1156)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1036)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:929)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192)
        at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
        at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:148)
        at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:275)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
        at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
        at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
        at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
        at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
        at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Unknown Source)
    Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
    Cannot process the google.oda.ic driver's configurations.
    google.oda.ic
        at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:496)
        at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:117)
        at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
        at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1825)
        at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
        ... 79 more
    Caused by: org.eclipse.birt.data.engine.core.DataException: Cannot process the google.oda.ic driver's configurations.
    google.oda.ic
        at org.eclipse.birt.data.engine.odaconsumer.Driver.throwConfigException(Driver.java:176)
        at org.eclipse.birt.data.engine.odaconsumer.Driver.doGetDriverManifest(Driver.java:165)
        at org.eclipse.birt.data.engine.odaconsumer.Driver.findDataSourceExtensionConfig(Driver.java:123)
        at org.eclipse.birt.data.engine.odaconsumer.Driver.getDriverExtensionConfig(Driver.java:78)
        at org.eclipse.birt.data.engine.odaconsumer.Driver.getExtensionConfig(Driver.java:60)
        at org.eclipse.birt.data.engine.odaconsumer.Driver.getDriverHelper(Driver.java:93)
        at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getDriverHelper(DriverManager.java:98)
        at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:144)
        at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:192)
        at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:180)
        at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:390)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:309)
        at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:437)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)
        at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)
        at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:476)
        ... 83 more
    Caused by: java.lang.IllegalArgumentException: google.oda.ic
        at org.eclipse.datatools.connectivity.oda.util.manifest.ManifestExplorer.getExtensionManifest(ManifestExplorer.java:200)
        at org.eclipse.birt.data.engine.odaconsumer.Driver.doGetDriverManifest(Driver.java:147)
        ... 99 more
    I also don´t know where I have to put the oda-jar (org.eclipse.datatools.connectivity.oda.google_1.0.0.jar)

    I tried to put it to that both places:
    biserver-ce-3.0.0\biserver-ce\pentaho-solutions\system\BIRT\plugins

    and the second attempt:
    \biserver-ce-3.0.0\biserver-ce\tomcat\webapps\pentaho\WEB-INF\lib

    but unfortunately without success.

    There is no documentation to fulfill this problem.

    Eventually you have a hint for me.

    Thank you.

    Bye
    ManInBlack

  5. #5

    Default

    Hi ManInBlack,

    You have added the google oda jar files to pentaho-solutions/system/BIRT/plugins, have you?

    After adding those jar files, I have no problems at all running an xaction/BIRT report that uses this data source.

    See attached archive for a report/xaction/screenshot.

    Regards,

    Bart
    Attached Files Attached Files

  6. #6
    Join Date
    Aug 2009
    Posts
    25

    Default

    Hi Bart,

    thank you for your reply.
    It is good to see, that birt oda reports are working in pentaho.

    Yes, I copied following jars:
    http://individual.utoronto.ca/kuong/...-oda_1.0.0.zip
    into that folder:
    pentaho-solutions/system/BIRT/plugins

    Now I copied your google_oda.rptdesign and google_oda.xaction into my Reporting folder.

    After a restart of pentaho, I get no longer the exception, but the screen is empty.

    I don´t know why it it is won´t work on my platform.

    Did you adjust index.properties or index.xml in the reporting-folder?

    thx+Bye
    ManInBlack
    Attached Images Attached Images  

  7. #7

    Default

    index.xml or index.properties have nothing to do with BIRT...

    In the previous post, I tested with BIRT 2.3.1/Pentaho 3.0. I just reran the test with BIRT 2.5/Pentaho 3.0. The report runs fine in both BIRT versions.

    Do you have any errors in the log or console?

    Regards,

    Bart

  8. #8
    Join Date
    Aug 2009
    Posts
    25

    Default

    Ok,

    I created a word-document, where I wrote down all step,
    which I have done.

    Somewhere I have made a mistake.

    CU
    ManInBlack
    Attached Files Attached Files

  9. #9
    Join Date
    Aug 2009
    Posts
    25

    Default

    Exception part 2

    Code:
    org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report
            at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:196)
            at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)
            at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportComponent.generateReport(BIRTReportComponent.java:507)
            at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportComponent.executeAction(BIRTReportComponent.java:307)
            at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:461)
            at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1322)
            at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1289)
            at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1207)
            at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1156)
            at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1036)
            at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:929)
            at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413)
            at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316)
            at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192)
            at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
            at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:148)
            at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:275)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
            at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
            at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:16
    9)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
            at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
            at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
            at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
            at java.lang.Thread.run(Unknown Source)
    Caused by: java.lang.UnsupportedClassVersionError: Bad version number in .class file
            at java.lang.ClassLoader.defineClass1(Native Method)
            at java.lang.ClassLoader.defineClass(Unknown Source)
            at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.defineClass(DefaultClassLoader.java:183)
            at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.defineClass(ClasspathManager.java:576)
            at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findClassImpl(ClasspathManager.java:546)
            at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClassImpl(ClasspathManager.java:477)
            at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass_LockClassLoader(ClasspathManager.java:465)
            at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:445)
            at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:211)
            at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:376)
            at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:452)
            at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:405)
            at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:393)
            at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:105)
            at java.lang.ClassLoader.loadClass(Unknown Source)
            at org.eclipse.osgi.internal.loader.BundleLoader.loadClass(BundleLoader.java:321)
            at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:231)
            at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1193)
            at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDriver.loadDriverInstance(OdaDriver.java:208)
            at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDriver.init(OdaDriver.java:177)
            at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDriver.<init>(OdaDriver.java:93)
            at org.eclipse.birt.data.engine.odaconsumer.Driver.getDriverHelper(Driver.java:93)
            at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getDriverHelper(DriverManager.java:98)
            at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:144)
            at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:192)
            at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:180)
            at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)
            at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:390)
            at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:309)
            at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:437)
            at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)
            at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)
            at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)
            at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:476)
            at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:117)
            at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
            at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1825)
            at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
            at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
            at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
    
            at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
            at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
            at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:64)
            at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
            at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
            at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:167)
            ... 71 more
    13:56:09,405 ERROR [BIRTReportComponent] Error end:
    13:56:09,405 ERROR [BIRTReportComponent] 7004820f-96ee-11de-8cde-29a44c6237b6:COMPONENT:context-10739452-1251806169342:google_oda.xactionBIR
    T.ERROR_0010 - Fehler beim Ausf³hren des Breichts Error happened while running the report
    13:56:09,405 ERROR [RuntimeContext] 7004820f-96ee-11de-8cde-29a44c6237b6:RUNTIME:context-10739452-1251806169342:google_oda.xaction RuntimeCo
    ntext.ERROR_0012 - Die ActionDefinition f³r BIRTReportComponent wurde nicht erfolgreich ausgef³rht.
    13:56:09,405 ERROR [SolutionEngine] 7004820f-96ee-11de-8cde-29a44c6237b6:SOLUTION-ENGINE:google_oda.xaction: SolutionEngine.ERROR_0007 - Feh
    ler beim Ausf³hren der Actionsequenz

  10. #10
    Join Date
    Aug 2009
    Posts
    25

    Default

    Following exception I get:

    Exception part 1, because the signs in post is limited:

    Code:
    01.09.2009 13:56:09 org.eclipse.birt.report.engine.api.impl.ReportEngine openReportDesign
    FEIN: ReportEngine.openReportDesign: designStream=java.io.ByteArrayInputStream@8dcd41
    01.09.2009 13:56:09 org.eclipse.birt.report.engine.api.impl.ReportEngine createGetParameterDefinitionTask
    FEIN: ReportEngine.createGetParameterDefinitionTask: reportRunnable=org.eclipse.birt.report.engine.api.impl.ReportRunnable@4fda99
    01.09.2009 13:56:09 org.eclipse.birt.report.engine.api.impl.EngineTask setAppContext
    FEIN: EngineTask.setAppContext: context=
    01.09.2009 13:56:09 org.eclipse.birt.report.engine.api.impl.ReportEngine createRunAndRenderTask
    FEIN: ReportEngine.createRunAndRenderTask: reportRunnable=org.eclipse.birt.report.engine.api.impl.ReportRunnable@4fda99
    01.09.2009 13:56:09 org.eclipse.birt.report.engine.api.impl.EngineTask setAppContext
    FEIN: EngineTask.setAppContext: context=
    01.09.2009 13:56:09 org.eclipse.birt.report.engine.api.impl.EngineTask setLocale
    FEIN: EngineTask.setLocale: locale=Deutsch (Deutschland)
    01.09.2009 13:56:09 org.eclipse.birt.report.engine.api.impl.EngineTask setAppContext
    FEIN: EngineTask.setAppContext: context=HTML_RENDER_CONTEXT=org.eclipse.birt.report.engine.api.HTMLRenderContext@b0f231;
    01.09.2009 13:56:09 org.eclipse.birt.report.engine.api.impl.EngineTask loggerParamters
    FEIN: Running the report with paramters:
    01.09.2009 13:56:09 org.eclipse.birt.report.engine.api.impl.RunAndRenderTask doRun
    SCHWERWIEGEND: Error happened while running the report.
    java.lang.UnsupportedClassVersionError: Bad version number in .class file
            at java.lang.ClassLoader.defineClass1(Native Method)
            at java.lang.ClassLoader.defineClass(Unknown Source)
            at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.defineClass(DefaultClassLoader.java:183)
            at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.defineClass(ClasspathManager.java:576)
            at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findClassImpl(ClasspathManager.java:546)
            at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClassImpl(ClasspathManager.java:477)
            at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass_LockClassLoader(ClasspathManager.java:465)
            at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:445)
            at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:211)
            at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:376)
            at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:452)
            at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:405)
            at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:393)
            at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:105)
            at java.lang.ClassLoader.loadClass(Unknown Source)
            at org.eclipse.osgi.internal.loader.BundleLoader.loadClass(BundleLoader.java:321)
            at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:231)
            at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1193)
            at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDriver.loadDriverInstance(OdaDriver.java:208)
            at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDriver.init(OdaDriver.java:177)
            at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDriver.<init>(OdaDriver.java:93)
            at org.eclipse.birt.data.engine.odaconsumer.Driver.getDriverHelper(Driver.java:93)
            at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getDriverHelper(DriverManager.java:98)
            at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:144)
            at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:192)
            at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:180)
            at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)
            at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:390)
            at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:309)
            at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:437)
            at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)
            at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)
            at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)
            at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:476)
            at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:117)
            at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
            at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1825)
            at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
            at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
            at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
    
            at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
            at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
            at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:64)
            at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
            at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
            at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:167)
            at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)
            at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportComponent.generateReport(BIRTReportComponent.java:507)
            at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportComponent.executeAction(BIRTReportComponent.java:307)
            at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:461)
            at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1322)
            at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1289)
            at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1207)
            at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1156)
            at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1036)
            at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:929)
            at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413)
            at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316)
            at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192)
            at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
            at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:148)
            at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:275)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
            at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
            at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:16
    9)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
            at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
            at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
            at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
            at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
            at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
            at java.lang.Thread.run(Unknown Source)
    13:56:09,389 ERROR [BIRTReportComponent] Error Start: Pentaho Pentaho Platform Engine Core 3.0.0-STABLE.37736
    13:56:09,389 ERROR [BIRTReportComponent] 7004820f-96ee-11de-8cde-29a44c6237b6:COMPONENT:context-10739452-1251806169342:google_oda.xactionnul

  11. #11

    Default

    What java version are you using?

    The errors start with "Bad version number in .class file".
    You're probably running this with a JRE that is lower than the JDK that was used for compilation...

  12. #12
    Join Date
    Aug 2009
    Posts
    25

    Default

    I use the windows version of pentaho.
    The biserver-ce folder consists a jre-folder.

    I start pentaho over the start-pentaho.bat:
    Code:
    @echo off
    setlocal
    set JAVA_HOME=
    cscript promptuser.js //nologo //e:jscript
    rem errorlevel 0 means user chose "no"
    if %errorlevel%==0 goto quit
    echo WScript.Quit(1); > promptuser.js
    set PENTAHO_PATH=%~dp0
    set JRE_HOME=%PENTAHO_PATH%jre
    set PATH=%JRE_HOME%\bin;%PATH%;
    cd data
    start start_hypersonic.bat
    cd ..\tomcat\bin
    set CATALINA_HOME=%PENTAHO_PATH%tomcat
    set CATALINA_OPTS=-Xms256m -Xmx768m -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000
    call startup
    endlocal
    :quit
    It is a JRE v5.0

    Please could you say me, if the instruction of my last post are corect?

    And is it better to start pentaho in unix/linux?

    At the moment I test it in Windows XP.

    Thx

  13. #13
    Join Date
    Aug 2009
    Posts
    25

    Default

    Great Bart,

    thank you very much for your Help. Now it works.
    I changed the bat-file, so that the pentaho will run with JDK.

    But at the moment I can not understand, why do I nee the JDK 6 and why doesn´t it work with JRE 5 ?
    Last edited by ManInBlack; 09-01-2009 at 08:52 AM.

  14. #14

    Default

    Glad it works for you now.

    The reason is what I said in my last post: you run this with a java version (5) that is lower than the version that was used for compilation (6).

    Quote from the article you mentioned:
    This has only been tested in BIRT 2.3.1, and I currently used JDK 6 to build these jars.
    Thanks again toScott Rosenbaum for supplying the initial source code. This example actually helped
    me develop my own custom ODA for work.

  15. #15
    Join Date
    Aug 2009
    Posts
    25

    Default

    Ah ok, I understand now, super.
    Without of your help, i would have never realized that.

    One litte question I have, if you have time and you would like to, you can answer, but you haven´t to answer because you already have done so much for me

    My own programmed oda-driver uses other refered jars in a lib-folder.
    In order to use that in Birt-viewer, I can add a optional entry in the web.xml in the folder apache-tomcat/webapps/birt-viewer/WEB-INF/web.xml

    Code:
    <context-param>
                    <param-name>BIRT_VIEWER_SCRIPTLIB_DIR</param-name>
                    <param-value>WEB-INF/scriptlib</param-value>
            </context-param>
    Inside of the folder, i put all the required jars and the birt-viewer can show the report correctly.

    How is it possible in pentaho?

    (Normally it´s a new question for a new thread --> so I can create a new one)

  16. #16

    Default

    Have you tried adding that to parameter to tomcat/webapps/pentaho/WEB-INF/web.xml?

    EDIT: I just performed a simple test, adding the scripted source (.class file) to tomcat/webapps/pentaho/WEB-INF/classes seems to work.

    Regards,

    Bart
    Last edited by bamaer; 09-01-2009 at 04:51 PM.

  17. #17
    Join Date
    Aug 2009
    Posts
    25

    Default

    Hi Bart,

    I tried it to put all the jar files into the folder:
    biserver-ce\tomcat\webapps\pentaho\WEB-INF\lib
    and it works. Really fine.

    I don´t dare to ask you, but maybe you can help me once again.
    My birt report has got 2 input parameters:

    - StartDateTime
    - EndDateTime

    That both paramters are essential to run the report.

    In the birt-viewer it is possible to change the parameters.
    Till now I haven´t found any possibilities to change the paramters
    within of the pentaho by using the user console.
    Eventually do you know if it is possible in pentaho too?

    Bye
    ManInBlack

  18. #18

    Default

    Just use the default xaction parameters (prompt/secure filter component).
    See attachment...

    Cheers,

    Bart
    Attached Files Attached Files

  19. #19
    Join Date
    Aug 2009
    Posts
    25

    Default

    Wow, it is going nicely.
    I am really excited.

    Bart, I thank you most sincerely.

    Best Regards
    ManInBalck

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.