[Fiware-fic3-coaching] SpagoBI - business model creation

[Franck Le Gall]

--- 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.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-fic3-coaching/attachments/20151015/cbb5c394/attachment.html>