Hitachi Vantara Pentaho Community Forums
Results 1 to 18 of 18

Thread: Birt under Pentaho 2.0

  1. #1
    Join Date
    Feb 2009
    Posts
    18

    Default Birt under Pentaho 2.0

    Hi i did a birt report which work when deployed under pentaho 1.7. When i tried it under pentaho 2.0(I copied the .rtpdesign and the .xaction file in my soolution) i get this error :
    Erreur : BIRTReportComponent.ERROR_0016 - Report engine has not been initialized by the BIRT System Listener. Verify that pentaho.xml has an entry for <birt> in the <system-listeners> section. (org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportComponent)

    I understood that i had to add the birt listener in pentaho listener list in the file
    pentaho.xml. In this file it's written in comments that the listener definition have been moved to the file systemListeners.xml. this file looks like this:
    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
    "http://www.springsource.org/dtd/spring-beans.dtd">

    <!--
    This is the spring configuration file that is used to wire system listeners into the Pentaho
    BI Platform. System listeners are notified when the platform starts up and shuts down. System
    listeners can be added, removed, and initialized here. Each bean in the list is a system listener.
    You can intialize any listeners properties, as shown in the QuartzSystemListener and
    VersionCheckSystemListener.
    -->

    <beans>
    <bean id="systemListenersList" class="java.util.ArrayList">
    <constructor-arg>
    <list>
    <bean id="jfreeReportSystemListener" class="org.pentaho.platform.plugin.action.jfreereport.JFreeReportSystemListener"/>
    <bean id="kettleSystemListener" class="org.pentaho.platform.plugin.action.kettle.KettleSystemListener"/>
    <bean id="mondrianSystemListener" class="org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener"/>
    <bean id="quartzSystemListener" class="org.pentaho.platform.scheduler.QuartzSystemListener"/>
    <bean id="metadataSystemListener" class="org.pentaho.platform.engine.services.metadata.PMDSystemListener"/>
    <bean id="versionCheckerSystemListener" class="org.pentaho.platform.scheduler.versionchecker.VersionCheckSystemListener">
    <property name="repeatIntervalSeconds">
    <value>86400</value>
    </property>
    <property name="requestedReleases" value="Minor, GA"/>
    <property name="disableVersionCheck">
    <value>false</value>
    </property>
    </bean>
    <bean id="pooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener"/>
    <!-- <bean id="nonPooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledDatasourceSystemListener"/> -->
    <!-- Insert system-listeners -->
    </list>
    </constructor-arg>
    </bean>
    </beans>

    I added the birt listener like this <bean id="birtSystemListener" class="org.pentaho.platform.plugin.action.eclipsebirt.BirtSystemListener"/>


    <beans>
    <bean id="systemListenersList" class="java.util.ArrayList">
    <constructor-arg>
    <list>
    <bean id="jfreeReportSystemListener" class="org.pentaho.platform.plugin.action.jfreereport.JFreeReportSystemListener"/>
    <bean id="kettleSystemListener" class="org.pentaho.platform.plugin.action.kettle.KettleSystemListener"/>
    <bean id="mondrianSystemListener" class="org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener"/>
    <bean id="quartzSystemListener" class="org.pentaho.platform.scheduler.QuartzSystemListener"/>
    <bean id="metadataSystemListener" class="org.pentaho.platform.engine.services.metadata.PMDSystemListener"/>
    <bean id="versionCheckerSystemListener" class="org.pentaho.platform.scheduler.versionchecker.VersionCheckSystemListener">
    <!--<bean id="birtSystemListener" class="org.pentaho.platform.plugin.action.eclipsebirt.BirtSystemListener"/> -->
    <property name="repeatIntervalSeconds">
    <value>86400</value>
    </property>
    <property name="requestedReleases" value="Minor, GA"/>
    <property name="disableVersionCheck">
    <value>false</value>
    </property>
    </bean>
    <bean id="pooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener"/>
    <!-- <bean id="nonPooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledDatasourceSystemListener"/> -->
    <!-- Insert system-listeners -->
    </list>
    </constructor-arg>
    </bean>
    </beans>

    The problem is that when i then restart the server, i get this error :

    10:40:40,921 ERROR [[/pentaho]] Exception lors de l'envoi de l'ÚvÞnement contexte initialisÚ (context initialized) Ó l'instance de classe d'Úcoute (listener) or
    g.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanDefinitionStoreException: Line 31 in XML d
    ocument from file [C:\StagesBI\Penthao\biserver-ce\pentaho-solutions\system\systemListeners.xml] is invalid; nested exception is org.xml.sax.SAXParseException:
    The content of element type "bean" must match "(description?,(constructor-arg|property|lookup-method|replaced-method)*)".
    Caused by:
    org.xml.sax.SAXParseException: The content of element type "bean" must match "(description?,(constructor-arg|property|lookup-method|replaced-method)*)".
    at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)

    Tomcat start succeed but pentaho ressource is not accessible(http error 404).
    Did i proceed well to add the birt listener or is there somethig else i should do?


  2. #2
    Join Date
    Feb 2006
    Posts
    24

    Default

    This looks like a Spring exception. For some reason it failed to validate your xml. Can you post the file in a
    Code:
    code
    block so I can have a look at it for you?

    It is probably just a typo or cut and paste error.

    Cheers

    Russell

  3. #3
    Join Date
    Feb 2006
    Posts
    24

    Default

    You have this (you say)
    Code:
    <beans>
    <bean id="systemListenersList" class="java.util.ArrayList">
    <constructor-arg>
    <list>
    <bean id="jfreeReportSystemListener" class="org.pentaho.platform.plugin.action.jfreerep ort.JFreeReportSystemListener"/>
    <bean id="kettleSystemListener" class="org.pentaho.platform.plugin.action.kettle.K ettleSystemListener"/>
    <bean id="mondrianSystemListener" class="org.pentaho.platform.plugin.action.mondrian .MondrianSystemListener"/>
    <bean id="quartzSystemListener" class="org.pentaho.platform.scheduler.QuartzSystem Listener"/>
    <bean id="metadataSystemListener" class="org.pentaho.platform.engine.services.metada ta.PMDSystemListener"/>
    <bean id="versionCheckerSystemListener" class="org.pentaho.platform.scheduler.versioncheck er.VersionCheckSystemListener">
    <!--<bean id="birtSystemListener" class="org.pentaho.platform.plugin.action.eclipseb irt.BirtSystemListener"/> -->
    <property name="repeatIntervalSeconds">
    <value>86400</value>
    </property>
    <property name="requestedReleases" value="Minor, GA"/>
    <property name="disableVersionCheck">
    <value>false</value>
    </property>
    </bean>
    <bean id="pooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connec tion.datasource.dbcp.PooledDatasourceSystemListene r"/>
    <!-- <bean id="nonPooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connec tion.datasource.dbcp.NonPooledDatasourceSystemList ener"/> -->
    <!-- Insert system-listeners -->
    </list>
    </constructor-arg>
    </bean>
    </beans>
    It should be this:-

    Code:
    <beans>
    <bean id="systemListenersList" class="java.util.ArrayList">
    <constructor-arg>
    <list>
    <bean id="jfreeReportSystemListener" class="org.pentaho.platform.plugin.action.jfreerep ort.JFreeReportSystemListener"/>
    <bean id="kettleSystemListener" class="org.pentaho.platform.plugin.action.kettle.K ettleSystemListener"/>
    <bean id="mondrianSystemListener" class="org.pentaho.platform.plugin.action.mondrian .MondrianSystemListener"/>
    <bean id="quartzSystemListener" class="org.pentaho.platform.scheduler.QuartzSystem Listener"/>
    <bean id="metadataSystemListener" class="org.pentaho.platform.engine.services.metada ta.PMDSystemListener"/>
    <bean id="versionCheckerSystemListener" class="org.pentaho.platform.scheduler.versioncheck er.VersionCheckSystemListener">
    <property name="repeatIntervalSeconds">
    <value>86400</value>
    </property>
    <property name="requestedReleases" value="Minor, GA"/>
    <property name="disableVersionCheck">
    <value>false</value>
    </property>
    </bean>
    <bean id="pooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connec tion.datasource.dbcp.PooledDatasourceSystemListene r"/>
    <!-- <bean id="nonPooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connec tion.datasource.dbcp.NonPooledDatasourceSystemList ener"/> -->
    <!-- Insert system-listeners -->
    <bean id="birtSystemListener" class="org.pentaho.platform.plugin.action.eclipseb irt.BirtSystemListener"/>
    </list>
    </constructor-arg>
    </bean>
    </beans>
    Please let me know if that does it for you as I am hoping to try BIRT soon with Penataho.

    Cheers

    Russell

  4. #4
    Join Date
    Feb 2009
    Posts
    18

    Thumbs up Problem solved

    thanks russelldb you were right it was a problem whith my xml,
    I had to declare the birt listener before the versioncheckerlistener. Now server start again and i think i will be able to execute my birt repport. I have problem whith parameters i can't fill, i'm investigating i think it will work.

    thnx again

  5. #5
    Join Date
    Feb 2009
    Posts
    18

    Default Exectution of birt report on pentaho

    Now when i try to execute a birt report I get this error
    Code:
    The following items have errors:         
             
                                                 ReportDesign (id = 1):         
                      - A BIRT exception occurred: org.eclipse.birt.core. See next exception for more information.
    org.eclipse.birt.core                         data.engine.BirtException ( 1 time(s) )
    detail : org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: org.eclipse.birt.core. See next exception for more information.
    org.eclipse.birt.core
     at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:118)
     at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.populateColumnList(ExpressionCompilerUtil.java:537)
     at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.extractDataSetColumnExpression(ExpressionCompilerUtil.java:284)
     at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.extractDataSetColumnExpression(ExpressionCompilerUtil.java:201)
     at org.eclipse.birt.data.engine.impl.ResultIterator.validateManualBindingExpressions(ResultIterator.java:267)
     at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:145)
     at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:180)
     at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:83)
     at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:157)
     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:182)
     at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1683)
     at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:76)
     at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:61)
     at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
     at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
     at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
     at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
     at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:85)
     at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:106)
     at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:140)
     at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:68)
     at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportComponent.generateReport(BIRTReportComponent.java:482)
     at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportComponent.executeAction(BIRTReportComponent.java:296)
     at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440)
     at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1299)
     at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1266)
     at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1175)
     at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1128)
     at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1013)
     at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:909)
     at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409)
     at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313)
     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:142)
     at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:269)
     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:81)
     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:164)
     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:129)
     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:55)
     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.core.exception.CoreException: org.eclipse.birt.core
     at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:90)
     at org.eclipse.birt.core.data.ExpressionUtil.extractColumnExpressions(ExpressionUtil.java:231)
     at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.populateColumnList(ExpressionCompilerUtil.java:532)
     ... 90 more
    Caused by: org.eclipse.birt.core.exception.CoreException: org.eclipse.birt.core
     at org.eclipse.birt.core.data.ExpressionParserUtility.CompiledExprFromTree(ExpressionParserUtility.java:164)
     at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:83)
     ... 92 more
    The birt version u use is the 2.2, I also tried whith the 2.0. A also tryed to use de same jre for pentaho and eclipse. Thes reports are all working under pentaho 1.7. Is it a birt version incompatibilty?
    Last edited by cced; 03-04-2009 at 09:57 AM.

  6. #6
    Join Date
    Feb 2009
    Posts
    18

    Default

    I have upgrade the Birt ritime 2.1 of pentaho to 2.2, thats the version i use for my reports but i have tree type of errors now when i execute birt reports.

    If it 's a simple non parametred report I get the header of My repport with no rows and i have this error under

    The following items have errors:

    ReportDesign (id = 1):
    - A BIRT exception occurred: org.eclipse.birt.core. See next exception for more information.
    org.eclipse.birt.core data.engine.BirtException ( 1 time(s) )
    detail : org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: org.eclipse.birt.core. See next exception for more information.
    org.eclipse.birt.core
    at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:118)
    at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.populateColumnList(ExpressionCompilerUtil.java:537)
    at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.extractDataSetColumnExpression(ExpressionCompilerUtil.java:284)
    at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.extractDataSetColumnExpression(ExpressionCompilerUtil.java:201)
    at org.eclipse.birt.data.engine.impl.ResultIterator.validateManualBindingExpressions(ResultIterator.java:267)
    at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:145)
    at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:180)
    at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:83)
    at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:157)
    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:182)
    at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1683)
    at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:76)
    at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:61)
    at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
    at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
    at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:85)
    at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:106)
    at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:140)
    at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:68)
    at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportComponent.generateReport(BIRTReportComponent.java:482)
    at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportComponent.executeAction(BIRTReportComponent.java:296)
    at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1299)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1266)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1175)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1128)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1013)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:909)
    at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409)
    at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313)
    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:142)
    at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:269)
    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:81)
    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:164)
    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:129)
    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:55)
    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.core.exception.CoreException: org.eclipse.birt.core
    at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:90)
    at org.eclipse.birt.core.data.ExpressionUtil.extractColumnExpressions(ExpressionUtil.java:231)
    at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.populateColumnList(ExpressionCompilerUtil.java:532)
    ... 90 more
    Caused by: org.eclipse.birt.core.exception.CoreException: org.eclipse.birt.core
    at org.eclipse.birt.core.data.ExpressionParserUtility.CompiledExprFromTree(ExpressionParserUtility.java:164)
    at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:83)
    In tomcat i have many lines like this

    ...
    FIN: ResultSet.wasNull( )
    05-mars-2009 11:25:56 org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaDat
    a
    FIN: ResultSet.wasNull( )
    05-mars-2009 11:25:56 org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaDat
    a
    FIN: ResultSet.wasNull( )
    05-mars-2009 11:25:56 org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaDat
    a
    FIN: ResultSet.wasNull( )
    05-mars-2009 11:25:56 org.eclipse.birt.report.data.oda.jdbc.ResultSet next
    FIN: ResultSet.next( )
    05-mars-2009 11:25:56 org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaDat
    a
    FIN: ResultSet.wasNull( )
    05-mars-2009 11:25:56 org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaDat
    a
    FIN: ResultSet.wasNull( )
    05-mars-2009 11:25:56 org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaDat
    a
    FIN: ResultSet.wasNull( )
    05-mars-2009 11:25:56 org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaDat
    a
    FIN: ResultSet.wasNull( )
    05-mars-2009 11:25:56 org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaDat
    a
    FIN: ResultSet.wasNull( )
    05-mars-2009 11:25:56 org.eclipse.birt.report.data.oda.jdbc.ResultSet next
    FIN: ResultSet.next( )
    05-mars-2009 11:25:56 org.eclipse.birt.data.engine.executor.cache.SmartCacheHelp
    er populateData
    FIN: MemoryCache is used
    05-mars-2009 11:25:56 org.eclipse.birt.data.engine.executor.cache.SmartCacheHelp
    er populateData
    FIN: Time consumed by cache is: 5 second
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.data.dte.DteDataEngine doEx
    ecuteQuery
    GRAVE: A BIRT exception occurred: org.eclipse.birt.core. See next exception for
    more information.
    org.eclipse.birt.core
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startTable
    FIN: [HTMLTableEmitter] Start table
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startCell
    FIN: [HTMLTableEmitter] Start cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startText
    FIN: [HTMLReportEmitter] Start text
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter endCell
    FIN: [HTMLReportEmitter] End cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startCell
    FIN: [HTMLTableEmitter] Start cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startText
    FIN: [HTMLReportEmitter] Start text
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter endCell
    FIN: [HTMLReportEmitter] End cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startCell
    FIN: [HTMLTableEmitter] Start cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startText
    FIN: [HTMLReportEmitter] Start text
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter endCell
    FIN: [HTMLReportEmitter] End cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startCell
    FIN: [HTMLTableEmitter] Start cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startText
    FIN: [HTMLReportEmitter] Start text
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter endCell
    FIN: [HTMLReportEmitter] End cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startCell
    FIN: [HTMLTableEmitter] Start cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startText
    FIN: [HTMLReportEmitter] Start text
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter endCell
    FIN: [HTMLReportEmitter] End cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startCell
    FIN: [HTMLTableEmitter] Start cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter endCell
    FIN: [HTMLReportEmitter] End cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startCell
    FIN: [HTMLTableEmitter] Start cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startText
    FIN: [HTMLReportEmitter] Start text
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter endCell
    FIN: [HTMLReportEmitter] End cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startCell
    FIN: [HTMLTableEmitter] Start cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter endCell
    FIN: [HTMLReportEmitter] End cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startCell
    FIN: [HTMLTableEmitter] Start cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter endCell
    FIN: [HTMLReportEmitter] End cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startCell
    FIN: [HTMLTableEmitter] Start cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter endCell
    FIN: [HTMLReportEmitter] End cell.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter endTable
    FIN: [HTMLTableEmitter] End table
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter endPage
    FIN: [HTMLReportEmitter] End page.
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter startForeign
    FIN: [HTMLReportEmitter] Start foreign
    05-mars-2009 11:25:56 org.eclipse.birt.report.engine.emitter.html.HTMLReportEmit
    ter end
    FIN: [HTMLReportEmitter] End body.
    05-mars-2009 11:25:56 org.eclipse.birt.report.data.oda.jdbc.Statement close
    FIN: Statement.close( )
    05-mars-2009 11:25:56 org.eclipse.birt.report.data.oda.jdbc.Connection close
    FIN: Connection closed.
    05-mars-2009 11:25:56 org.eclipse.birt.data.engine.impl.DataEngineImpl shutdown
    INFO: Data engine shuts down
    Whith this :
    ResultSet.wasNull( )
    it looks like he get empty data for each row i'm suppose get. If the table is bigger I have more lines like this.


    When i execute a 2nd report, a parametred one, i get a page whith only the header of the repport but whithout errors on it. In the Tomcat log i have the same log than in the 1st report.

  7. #7
    Join Date
    Feb 2009
    Posts
    18

    Default

    I traced the log on my database server while i'm executing my non parametred report, the requeste is correct and it's supposed de give me some result but it looks like the birt motor is unnable to get these results. Any idea?
    Last edited by cced; 03-05-2009 at 08:40 AM.

  8. #8
    Join Date
    Jan 2008
    Posts
    6

    Default

    I'm Diego Martín and i work in Stratebi, a spanish partner. We have found the problem and we have correct it.

    You can found all the information in http://todobi.blogspot.com/2009/03/f...entaho-20.html

    We've done a tutorial (english, spanish) and the jars that you need (Stratebi_Birt_Pentaho.zip).

    If you need something, contact me at info@stratebi.com

  9. #9
    Join Date
    Feb 2009
    Posts
    18

    Thumbs up

    Thnx dmartin that was clear and works immediately

  10. #10

    Default

    This solution does not work with Birt 2.3.2 and Pentaho 2.0. I followed dmartin but i got below exception when starting tomcat.
    Any change on the log configuration ?

    Mar 18, 2009 3:27:39 PM org.eclipse.birt.report.engine.api.impl.EngineLogg er cre
    ateFileLogger
    WARNING: logDir "" doesn't exist and be created
    java.io.IOException: logDir "" doesn't exist and be created
    at org.eclipse.birt.report.engine.api.impl.EngineLogg er.createFileLogger
    (EngineLogger.java:253)
    at org.eclipse.birt.report.engine.api.impl.EngineLogg er.startEngineLoggi
    ng(EngineLogger.java:127)
    at org.eclipse.birt.report.engine.api.impl.ReportEngi ne.intializeLogger(
    ReportEngine.java:203)
    at org.eclipse.birt.report.engine.api.impl.ReportEngi ne.<init>(ReportEng
    ine.java:123)
    at org.eclipse.birt.report.engine.api.impl.ReportEngi neFactory$1.run(Rep
    ortEngineFactory.java:18)
    at org.eclipse.birt.report.engine.api.impl.ReportEngi neFactory$1.run(Rep
    ortEngineFactory.java:1)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.eclipse.birt.report.engine.api.impl.ReportEngi neFactory.createRep
    ortEngine(ReportEngineFactory.java:14)
    at org.pentaho.platform.plugin.action.eclipsebirt.Bir tSystemListener.cre
    ateBIRTEngine(BirtSystemListener.java:205)
    at org.pentaho.platform.plugin.action.eclipsebirt.Bir tSystemListener.sta
    rtup(BirtSystemListener.java:81)

  11. #11
    Join Date
    Mar 2009
    Posts
    7

    Default

    Hy,

    I have the same error. Do you solve this problem?

    Thanks

  12. #12

    Default

    Yes. i solved it. Leave the error of LogDir there ( i cound not solve this problem) and you just copy the js file from Lib forder of Birtviewer to tomcat\webapps\pentaho\WEB-INF\lib

  13. #13

    Default

    Hello trungdc@gmail.com,
    I want to do the same thing than you.
    But after doing what dmartin have say, my Pentaho platform don't run.

    Can you tell me if you have suceed to put an Birt (2.3.2 or 2.3.1 version) on the 2.0.0 Pentaho platform?

    Thank you in advance.

    Nicolas.

  14. #14

    Default birt-chart

    I deploy birt on Pentaho successful, but when view chart, it displays empty.
    Seem the HTML Render of Pentaho do not work. Have any one can solve it?

  15. #15
    Join Date
    Mar 2008
    Posts
    4

    Default

    Exactly same issue as trungdc.

    Using BIRT 2.3.2 and pentaho 2.0

    Reports with no charts are displaying good in HTML. When we add charts to reports, they are not displayed in html output (but are displaying in pdf output).

    Does someone have an idea about this ?

    Thanks
    Last edited by yasso; 04-15-2009 at 12:09 PM.

  16. #16

    Default

    Quote Originally Posted by yasso View Post
    Exactly same issue as trungdc.

    Using BIRT 2.3.2 and pentaho 2.0

    Reports with no charts are displaying good in HTML. When we add charts to reports, they are not displayed in html output (but are displaying in pdf output).

    Does someone have an idea about this ?

    Thanks

    same problem,waiting someone for help

  17. #17
    Join Date
    Jun 2006
    Posts
    282

    Default

    We are experiencing the exact same problem
    "If you want to increase your success rate, double your failure rate."
    Thomas Watson, Sr (former president of IBM)

  18. #18

    Default

    same problem

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.