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

            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: