Uploaded image for project: 'Help-Desk'
  1. Help-Desk
  2. HELP-4098

FIWARE.Request.Tech.Apps.DataViz-SpagoBI.BirtEngineUpgrade

    Details

    • Type: extRequest
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Fix Version/s: 2021
    • Component/s: FIWARE-TECH-HELP
    • Labels:
      None

      Description

      Dear FIware experts,

      In our application (HybridSuite, part of the Finodex accelerator) we have
      created a number of birt reports which display charts with the use of
      client side javascript and the highcharts library.
      (the feature is described here:
      https://eclipse.org/birt/phoenix/project/notable4.3.php#jump_6 and is
      supported from BIRT version 4.3)

      We are trying to integrate the reports in SpagoBI, however we just noticed
      that the birt reports version that SpagoBI uses is 4.2.2 (at least this is
      what we see in
      "All-In-One-SpagoBI-5.1.0_21012015/webapps/SpagoBIBirtReportEngine/WEB-INF/lib/org.eclipse.birt.runtime_4.2.2.v20130216-1152.jar
      states 4.4.2).

      This is consistent with the fact that the client side javascript is not
      shown when we try to print the report from within SpagoBI.

      We downloaded SpagoBI 5.1 (All-In-One-SpagoBI-5.1-21012015.zip) from this
      link: http://forge.ow2.org/project/showfiles.php?group_id=204

      The question are:

      • Is it possible to run client side javascript with birt reports and
        SpagoBI 5.1, or we should use a standalone birt reports server?
      • Is there a way to update the birt reports version in SpagoBI 5.1?

      A prompt reply would be appreciated.

      Best regards,
      Efthimios Bothos.

      _______________________________________________
      Fiware-tech-help mailing list
      Fiware-tech-help@lists.fiware.org
      https://lists.fiware.org/listinfo/fiware-tech-help-new
      [Created via e-mail received from: Efthimios Bothos <mpthimios@hybridstat.gr>]

        Activity

        Hide
        zerbetto Davide Zerbetto added a comment - - edited

        Hi
        SpagoBI 5.1 comes with Birt 4.2.2 but current SVN repository was updated to Birt 4.4.2, therefore you can try checking out the Birt engine source code and compiling it with ant or Eclipse.
        As an alternative, since compiling from source code may be difficult, you can try just updating the jar dependencies within WEB-INF/lib and Javascript resources.

        Is it possible to run client side javascript with birt reports and SpagoBI 5.1, or we should use a standalone birt reports server?
        Not within SpagoBI 5.1 but with current SVN source code

        Is there a way to update the birt reports version in SpagoBI 5.1?
        When updating the engine, you have to update jar dependencies and other static resources, but you have also to check for API retrocompatibility, since engine source code may not compile anymore. Upgrading to Birt 4.4.2 shouldn't require any change in the engine source code since SpagoBI 5.1.

        Thanks and best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - - edited Hi SpagoBI 5.1 comes with Birt 4.2.2 but current SVN repository was updated to Birt 4.4.2, therefore you can try checking out the Birt engine source code and compiling it with ant or Eclipse. As an alternative, since compiling from source code may be difficult, you can try just updating the jar dependencies within WEB-INF/lib and Javascript resources. Is it possible to run client side javascript with birt reports and SpagoBI 5.1, or we should use a standalone birt reports server? Not within SpagoBI 5.1 but with current SVN source code Is there a way to update the birt reports version in SpagoBI 5.1? When updating the engine, you have to update jar dependencies and other static resources, but you have also to check for API retrocompatibility, since engine source code may not compile anymore. Upgrading to Birt 4.4.2 shouldn't require any change in the engine source code since SpagoBI 5.1. Thanks and best regards Davide
        Hide
        fw.ext.user FW External User added a comment -

        hi,

        thanks!

        although we don't understand the specifics (API retrocompatibility? ), we
        followed the step to replace the lib folder with the one of the svn.

        however we get the error shown below.

        how can we proceed?

        best,
        -Thimios.

        SEVERE: ContainerBase.addChild: start:
        org.apache.catalina.LifecycleException: Failed to start component
        [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/SpagoBIBirtReportEngine]]
        at
        org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:154)
        at
        org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at
        org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at
        org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
        at
        org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1120)
        at
        org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1678)
        at
        java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at
        java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at
        java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
        Caused by: java.lang.NoClassDefFoundError:
        it/eng/spagobi/utilities/DynamicClassLoader
        at java.lang.Class.getDeclaredFields0(Native Method)
        at java.lang.Class.privateGetDeclaredFields(Class.java:2509)
        at java.lang.Class.getDeclaredFields(Class.java:1819)
        at
        org.apache.catalina.util.Introspection.getDeclaredFields(Introspection.java:106)
        at
        org.apache.catalina.startup.WebAnnotationSet.loadFieldsAnnotation(WebAnnotationSet.java:263)
        at
        org.apache.catalina.startup.WebAnnotationSet.loadApplicationServletAnnotations(WebAnnotationSet.java:142)
        at
        org.apache.catalina.startup.WebAnnotationSet.loadApplicationAnnotations(WebAnnotationSet.java:67)
        at
        org.apache.catalina.startup.ContextConfig.applicationAnnotationsConfig(ContextConfig.java:405)
        at
        org.apache.catalina.startup.ContextConfig.configureStart(ContextConfig.java:881)
        at
        org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:376)
        at
        org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at
        org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
        at
        org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5322)
        at
        org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        ... 10 more
        Caused by: java.lang.ClassNotFoundException:
        it.eng.spagobi.utilities.DynamicClassLoader
        at
        org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1702)
        at
        org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1547)
        ... 24 more

        Sep 14, 2015 8:45:40 PM org.apache.catalina.startup.HostConfig
        deployDirectory
        SEVERE: Error deploying web application directory
        /home/ubuntu/All-In-One-SpagoBI-5.1.0_21012015/webapps/SpagoBIBirtReportEngine
        java.lang.IllegalStateException: ContainerBase.addChild: start:
        org.apache.catalina.LifecycleException: Failed to start component
        [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/SpagoBIBirtReportEngine]]
        at
        org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:904)
        at
        org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at
        org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
        at
        org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1120)
        at
        org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1678)
        at
        java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at
        java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at
        java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)

        Sep 14, 2015 8:45:40 PM org.apache.catalina.startup.HostConfig
        deployDirectory

        -Thimios.

        On Mon, Sep 14, 2015 at 6:09 PM, Help-Desk <jira-help-desk@fi-ware.org>

        Show
        fw.ext.user FW External User added a comment - hi, thanks! although we don't understand the specifics (API retrocompatibility? ), we followed the step to replace the lib folder with the one of the svn. however we get the error shown below. how can we proceed? best, -Thimios. SEVERE: ContainerBase.addChild: start: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine [Catalina] .StandardHost [localhost] .StandardContext [/SpagoBIBirtReportEngine] ] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:154) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1120) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1678) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NoClassDefFoundError: it/eng/spagobi/utilities/DynamicClassLoader at java.lang.Class.getDeclaredFields0(Native Method) at java.lang.Class.privateGetDeclaredFields(Class.java:2509) at java.lang.Class.getDeclaredFields(Class.java:1819) at org.apache.catalina.util.Introspection.getDeclaredFields(Introspection.java:106) at org.apache.catalina.startup.WebAnnotationSet.loadFieldsAnnotation(WebAnnotationSet.java:263) at org.apache.catalina.startup.WebAnnotationSet.loadApplicationServletAnnotations(WebAnnotationSet.java:142) at org.apache.catalina.startup.WebAnnotationSet.loadApplicationAnnotations(WebAnnotationSet.java:67) at org.apache.catalina.startup.ContextConfig.applicationAnnotationsConfig(ContextConfig.java:405) at org.apache.catalina.startup.ContextConfig.configureStart(ContextConfig.java:881) at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:376) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5322) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) ... 10 more Caused by: java.lang.ClassNotFoundException: it.eng.spagobi.utilities.DynamicClassLoader at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1702) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1547) ... 24 more Sep 14, 2015 8:45:40 PM org.apache.catalina.startup.HostConfig deployDirectory SEVERE: Error deploying web application directory /home/ubuntu/All-In-One-SpagoBI-5.1.0_21012015/webapps/SpagoBIBirtReportEngine java.lang.IllegalStateException: ContainerBase.addChild: start: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine [Catalina] .StandardHost [localhost] .StandardContext [/SpagoBIBirtReportEngine] ] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:904) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1120) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1678) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Sep 14, 2015 8:45:40 PM org.apache.catalina.startup.HostConfig deployDirectory -Thimios. On Mon, Sep 14, 2015 at 6:09 PM, Help-Desk <jira-help-desk@fi-ware.org>
        Hide
        zerbetto Davide Zerbetto added a comment -

        Hi
        I suppose you removed also libraries:
        1. sbi.utils.json-XXX.jar
        2. sbi.utils-XXX.jar
        3. qbe.core-XXX.jar
        that are required dependencies.
        Restore them from the previous installation.
        Please pay attention to the fact that you should also update also static resources: copy the content of the folder SpagoBIBirtReportEngine/WebContent from our SVN inside All-in-one-home/webapps/SpagoBIBirtReportEngine
        Hope this helps
        Best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - Hi I suppose you removed also libraries: 1. sbi.utils.json-XXX.jar 2. sbi.utils-XXX.jar 3. qbe.core-XXX.jar that are required dependencies. Restore them from the previous installation. Please pay attention to the fact that you should also update also static resources: copy the content of the folder SpagoBIBirtReportEngine/WebContent from our SVN inside All-in-one-home/webapps/SpagoBIBirtReportEngine Hope this helps Best regards Davide
        Hide
        zerbetto Davide Zerbetto added a comment -

        Hi
        could you please provide any feedback on this thread?
        Thanks and best regards
        Davide

        Show
        zerbetto Davide Zerbetto added a comment - Hi could you please provide any feedback on this thread? Thanks and best regards Davide
        Hide
        fw.ext.user FW External User added a comment -

        hi!

        it worked! thanks!

        -Thimios.

        On Thu, Sep 17, 2015 at 11:54 AM, Help-Desk <jira-help-desk@fi-ware.org>

        Show
        fw.ext.user FW External User added a comment - hi! it worked! thanks! -Thimios. On Thu, Sep 17, 2015 at 11:54 AM, Help-Desk <jira-help-desk@fi-ware.org>

          People

          • Assignee:
            zerbetto Davide Zerbetto
            Reporter:
            fw.ext.user FW External User
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: