4 Replies Latest reply on Mar 31, 2010 7:11 AM by John Sawyer

    Report Templates fails in JBPM Console

    John Sawyer Novice

      I'm using JBPM 4.3 & Console 1.3 and when i go to Reporting- Process History - System Overview, the render fails:

      The following items have errors:

       

      Grid (id  = 353):
      +  Can't load the report query: 353.


      Data (id  = 309):
      +  Can't load the report query: 309.


      Data (id  = 311):
      +  Can't load the report query: 311.


      Data (id  = 310):
      +  Can't load the report query: 310.


      Table  process_counts_table:
      +  Can't load the report query: 287.


      Chart  NewChart:

      +  Can't load the report query: 385.

       

      If i explode for sample the first, I can see this:

       

      Error.ReportQueryLoadingError ( 1 time(s) )
      detail : org.eclipse.birt.report.engine.api.EngineException: Can't load the report query: 353.
      at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:140)
      at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
      at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
      at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.executeQuery(ReportItemExecutor.java:409)
      at org.eclipse.birt.report.engine.internal.document.v4.GridItemExecutor.doExecute(GridItemExecutor.java:49)
      at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.execute(ReportItemExecutor.java:294)
      at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.prepareChildExecutor(ContainerExecutor.java:222)
      at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.hasNextChild(ContainerExecutor.java:110)
      at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:85)
      at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:85)
      at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExecutorWrapper.hasNextChild(RenderTask.java:665)
      at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasNextChild(HTMLPageLM.java:68)
      at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:60)
      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:101)
      at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:534)
      at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:209)
      at org.jboss.bpm.report.BirtService.view(BirtService.java:411)
      at org.jboss.bpm.report.ReportFacade.viewReportHtml(ReportFacade.java:163)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)
      at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)
      at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)
      at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)
      at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)
      at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
      at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)
      at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)
      at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:619)

       

       

      Any Idea???

       

      thanks

        • 1. Re: Report Templates fails in JBPM Console
          Maciej Swiderski Master

          Hi,

           

          could you provide some information about your environment - what app server, what database.

           

          I had some issues with report as well, it mainly complained about missing driver. I worked with tomcat and JBoss and hsqldb.

           

          I have posted some feedback on GWT Console forum:http://community.jboss.org/thread/147204

           

          HTH

          Maciej

          • 2. Re: Report Templates fails in JBPM Console
            John Sawyer Novice

            JBPM: 4.3

            CONSOLE: 1.3

             

            TOMCAT: 6.0.24

            BD: HSQL

             

            I put here CATALINA_HOME/birt/ReportEngine/plugins/org.eclipse.birt.report.data.oda.jdbc_2.3.2.r232_v20090212/drivers  hsqldb.jar and now 2 reports are fine.

             

            Now fails: overall_activity_old.rptdesign and process_summary.rptdesign because these files are using MySQL

             

            If i change in these files (CATALINA_HOME/birt) using hsql information... the reports fails again.

            ==============================================================================

            <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="HsqlDB on JBoss" id="248">
                        <property name="odaDriverClass">org.hsqldb.jdbcDriver</property>
                        <property name="odaURL">jdbc:hsqldb:hsql://localhost:1701</property>
                        <property name="odaUser">sa</property>
                        <property name="odaJndiName">java:/JbpmDS</property>
            </oda-data-source>

            ....

            <property name="dataSource">HsqlDB on JBoss</property>

            ==============================================================================

             

            I suppose I need do something else, but i don't know.

             

            Thanks for you patience!

            • 3. Re: Report Templates fails in JBPM Console
              Maciej Swiderski Master

              As far as I remember there are some other references within these files that points to MySQL settings.

               

              Search for name of the MySQL data source within report definition and change it to HSQLDB

               

              HTH

              Maciej

              • 4. Re: Report Templates fails in JBPM Console
                John Sawyer Novice

                I solve the problem!!

                 

                In process_summary.rptdesign I have a node with id="248"... then report crash by duplicate id... I put id="2480" in this node and then all works fine!

                 

                 

                Thank you!