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

FIWARE.Question.Tech.Apps.DataViz-SpagoBI.: Error when creating a business model on Hive

    Details

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

      Description

      — Forward from a SME —

      We have successfully connected our Apache Hive server via Cloudera jdbc driver (com.cloudera.hive.jdbc4.HS2Driver) from SpagoBI Studio, can explore tables, stored procedures, etc. in Data Source Explorer, can make data set for Birt reports, so the connection works fine. Until want to create a business model, when choosen the physical tables, model classes and try to create the model the following error has occured.

      Without business models, we cannot create ad-hoc reporting such as free inquiry or cockpits in SpagoBI server.

      eclipse.buildId=unknown

      java.version=1.8.0_60

      java.vendor=Oracle Corporation

      BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=hu_HU Command-line arguments: -os win32 -ws win32 -arch x86_64 -consoleLog

      Error

      Thu Oct 15 10:16:05 CEST 2015

      Impossible to generate metamodel

      java.lang.RuntimeException: Impossible to initialize the model at

      it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.createModel(SpagoBIModelEditorWizard.java:241)

      at

      it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.performFinish(SpagoBIModelEditorWizard.java:217)

      at

      org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:811)

      at

      org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:430)

      at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624)

      at

      org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)

      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)

      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)

      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)

      at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)

      at org.eclipse.jface.window.Window.open(Window.java:801)

      at

      it.eng.spagobi.studio.core.views.actionProvider.ResourceNavigatorActionProvider$13.run(ResourceNavigatorActionProvider.java:411)

      at org.eclipse.jface.action.Action.runWithEvent(Action.java:49

      at

      org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)

      at

      org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)

      at

      org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)

      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)

      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)

      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)

      at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)

      at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)

      at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:243

      at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)

      at

      org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

      at

      org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)

      at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

      at

      org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115)

      at

      org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

      at

      org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

      at

      org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

      at

      org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)

      at

      org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620)

      at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575)

      at org.eclipse.equinox.launcher.Main.run(Main.java:140

      Caused by: java.lang.RuntimeException: Impossible to initialize the physical model at

      it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.createPhysicalModel(SpagoBIModelEditorWizard.java:340)

      at

      it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.createModel(SpagoBIModelEditorWizard.java:237)

      ... 40 more

      Caused by: java.lang.reflect.InvocationTargetException

      at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:421)

      at

      org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:507)

      at

      it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.createPhysicalModel(SpagoBIModelEditorWizard.java:295)

      ... 41 more

      Caused by: java.lang.RuntimeException: Impossible to initialize physical model at

      it.eng.spagobi.meta.initializer.PhysicalModelInitializer.initialize(PhysicalModelInitializer.java:114)

      at

      it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard$1.run(SpagoBIModelEditorWizard.java:321)

      at

      org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

      Caused by: java.lang.RuntimeException: Impossible to initialize schema metadata at

      it.eng.spagobi.meta.initializer.PhysicalModelInitializer.addSchema(PhysicalModelInitializer.java:229)

      at

      it.eng.spagobi.meta.initializer.PhysicalModelInitializer.initialize(PhysicalModelInitializer.java:74)

      ... 2 more

      Caused by: java.lang.IndexOutOfBoundsException: Index: 1, Size: 1 at java.util.ArrayList.rangeCheck(Unknown Source) at java.util.ArrayList.get(Unknown Source) at

      it.eng.spagobi.meta.initializer.PhysicalModelInitializer.addSchema(PhysicalModelInitializer.java:210)

      ... 3 more

      In metaeditor.log file:

      2015-10-15 ERROR

      it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:197

      • error in retrieving other models, go ahead as default case

      Environment:

      Apache Hive 1.2.1 running on CentOS

      SpagoBI Studio 5.1.0 win64 on Windows 10 64bit Cloudera HiveJDBC4_2.5.4.1006

      Have tried on 32 bit Studio and apache hive jdbc driver

      (org.apache.hive.jdbc.HiveDriver) with the same result.

      Since January 1st, old domains won't be supported and messages sent to any domain different to @lists.fiware.org will be lost.
      Please, send your messages using the new domain (Fiware-fic3-coaching@lists.fiware.org) instead of the old one.
      _______________________________________________
      Fiware-fic3-coaching mailing list
      Fiware-fic3-coaching@lists.fiware.org
      https://lists.fiware.org/listinfo/fiware-fic3-coaching

        Issue Links

          Activity

          Hide
          flegall Franck Le Gall added a comment -

          Dear Davide

          Have you been able to move forward on this ?

          Thank you
          Franck

          Show
          flegall Franck Le Gall added a comment - Dear Davide Have you been able to move forward on this ? Thank you Franck
          Hide
          zerbetto Davide Zerbetto added a comment -

          Hi Franck
          we were able to reproduce the error you encountered. We are investigating...
          I'll keep you updated about the progress.
          Best regards
          Davide

          Show
          zerbetto Davide Zerbetto added a comment - Hi Franck we were able to reproduce the error you encountered. We are investigating... I'll keep you updated about the progress. Best regards Davide
          Hide
          zerbetto Davide Zerbetto added a comment -

          Hi Franck
          I created a bug issue APP-817 for this.
          We will try to fix it ASAP. I'm quite sure we will be able to fix by the new release (5.1).
          In case it will be possible, I'll try to send you a patch file to install on your environment before 5.1 release.
          I'll close this issue for the moment.
          Thanks and best regards
          Davide

          Show
          zerbetto Davide Zerbetto added a comment - Hi Franck I created a bug issue APP-817 for this. We will try to fix it ASAP. I'm quite sure we will be able to fix by the new release (5.1). In case it will be possible, I'll try to send you a patch file to install on your environment before 5.1 release. I'll close this issue for the moment. Thanks and best regards Davide
          Hide
          flegall Franck Le Gall added a comment -

          Dear David

          Thank you. I informed the SME accordingly.
          You can close the ticket

          KR,
          Franck

          Show
          flegall Franck Le Gall added a comment - Dear David Thank you. I informed the SME accordingly. You can close the ticket KR, Franck

            People

            • Assignee:
              zerbetto Davide Zerbetto
              Reporter:
              flegall Franck Le Gall
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: