[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Could not open the editor: An exception was thrown during initialization  XML
Forum Index » Technical Help - SpagoBI META
Author Message
msrhayri.spw

Newby

Joined: 02/12/2010 00:43:01
Messages: 43
Offline

Hello

I have just installed the SBI META 3.0

I followed the steps here http://wiki.spagobi.org/xwiki/bin/view/spagobi_meta/ to create a "Business Model" and all things was okay.

But when trying to create a query based on my model I have got the flowing error :

Could not open the editor: An exception was thrown during initialization

Any help please ?

Thank you

The stack trace contains :
Unable to create editor ID it.eng.spagobi.meta.querybuilder.ui.editor.CreateQueryBuilderEditor: An exception was thrown during initialization


java.lang.NullPointerException
at it.eng.spagobi.meta.querybuilder.ui.editor.SpagoBIDataSetEditor.init(SpagoBIDataSetEditor.java:114)
at org.eclipse.ui.internal.EditorManager.createSite(EditorManager.java:79
at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:647)
at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:465)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:595)
at org.eclipse.ui.internal.EditorReference.getEditor(EditorReference.java:289)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditorBatched(WorkbenchPage.java:2863)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:276
at org.eclipse.ui.internal.WorkbenchPage.access$11(WorkbenchPage.java:2760)
at org.eclipse.ui.internal.WorkbenchPage$10.run(WorkbenchPage.java:2711)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2707)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2691)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2682)
at org.eclipse.ui.ide.IDE.openEditor(IDE.java:651)
at org.eclipse.ui.ide.IDE.openEditor(IDE.java:610)
at org.eclipse.jdt.internal.ui.javaeditor.EditorUtility.openInEditor(EditorUtility.java:365)
at org.eclipse.jdt.internal.ui.javaeditor.EditorUtility.openInEditor(EditorUtility.java:16
at org.eclipse.jdt.ui.actions.OpenAction.run(OpenAction.java:229)
at org.eclipse.jdt.ui.actions.OpenAction.run(OpenAction.java:20
at org.eclipse.jdt.ui.actions.SelectionDispatchAction.dispatchRun(SelectionDispatchAction.java:274)
at org.eclipse.jdt.ui.actions.SelectionDispatchAction.run(SelectionDispatchAction.java:250)
at org.eclipse.jdt.internal.ui.navigator.OpenAndExpand.run(OpenAndExpand.java:49)
at org.eclipse.ui.actions.RetargetAction.run(RetargetAction.java:221)
at org.eclipse.ui.navigator.CommonNavigatorManager$3.open(CommonNavigatorManager.java:185)
at org.eclipse.ui.OpenAndLinkWithEditorHelper$InternalListener.open(OpenAndLinkWithEditorHelper.java:4
at org.eclipse.jface.viewers.StructuredViewer$2.run(StructuredViewer.java:845)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
at org.eclipse.jface.viewers.StructuredViewer.fireOpen(StructuredViewer.java:843)
at org.eclipse.jface.viewers.StructuredViewer.handleOpen(StructuredViewer.java:1131)
at org.eclipse.ui.navigator.CommonViewer.handleOpen(CommonViewer.java:462)
at org.eclipse.jface.viewers.StructuredViewer$6.handleOpen(StructuredViewer.java:1235)
at org.eclipse.jface.util.OpenStrategy.fireOpenEvent(OpenStrategy.java:264)
at org.eclipse.jface.util.OpenStrategy.access$2(OpenStrategy.java:25
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:29
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:619)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
at org.eclipse.equinox.launcher.Main.run(Main.java:1407)
msrhayri.spw

Newby

Joined: 02/12/2010 00:43:01
Messages: 43
Offline

I get it myself

The problem is due to the flowing :

When you choose the tables to import from your database inside the Physical Model and you DON'T choose tables used by other chosen.

You must choose all related tables to avoid this problem
buzzy96.spw

Newby

Joined: 22/12/2011 06:07:49
Messages: 15
Offline

i didn't understand,what his (msrhayri.spw) mean exactly with his post, probably tht was a solution!!!!!


can explain any one???????
msrhayri.spw

Newby

Joined: 02/12/2010 00:43:01
Messages: 43
Offline

Hello

Yes this is the solution: you should use all tables in the databse in the "Physicla model size"
when creating the business model
But in the "business model" side you are free to use what you need
buzzy96.spw

Newby

Joined: 22/12/2011 06:07:49
Messages: 15
Offline

dear pal,

i tried that way also,still i am getting same issue!!!!!


i am not sure,how ur telling that was the solution????,any help....


msrhayri.spw

Newby

Joined: 02/12/2010 00:43:01
Messages: 43
Offline

In this phase

http://wiki.spagobi.org/xwiki/bin/download/spagobi_meta/WebHome/spagobimodelwizard3.jpg

you should move all tables from left to right side

is is ok now ?
buzzy96.spw

Newby

Joined: 22/12/2011 06:07:49
Messages: 15
Offline

still i am having issue bro,

i done these steps

1.select Metadata_Model-->right click select "New Model",assign Filename as "xxxxx"

2.select DB as MySql--->when creating physical model ,i moved all tables from Original Database Tables to Physical ModelTables

3.click next

4.select tables are moved from PhysicalModelTables to Business ModelClasses


after that

5.select BusinessModelxxx ---->right click CREATE-query.

i am getting issue as per subject line.


any help???
buzzy96.spw

Newby

Joined: 22/12/2011 06:07:49
Messages: 15
Offline

any help on tis,i am struggling with tis past 2 days

msrhayri.spw

Newby

Joined: 02/12/2010 00:43:01
Messages: 43
Offline

Sorry I have no further information about this pb
buzzy96.spw

Newby

Joined: 22/12/2011 06:07:49
Messages: 15
Offline

Okie,thaking u 4 ur help :),

can i know one thing?,in ur case how u solved tis issue by using above steps...i didn't get!!!
creyasoft.spw

Newby

Joined: 13/09/2011 21:24:19
Messages: 17
Offline

What DBMS are you using? which version?
I used to get the same error with Postgresql. When tried the same with MySQL (5.5.16), worked perfect every time.
carro.spw

Newby

Joined: 03/02/2012 09:29:16
Messages: 10
Offline

Helllo, I get the same error when opening a metaquery:

Could not open the editor. An exception was thrown during initialization.

I am using SpagoBi 3.1. with Oracle 11g:


Could you please help me with this one?
macortel

SpagoBI hero
[Avatar]

Joined: 05/07/2010 15:41:17
Messages: 280
Location: Italy
Offline

Hi, always look at the logs file when you post an issue, it's the only way we can provide help for you problems.
Also, have you tried the 3.3 version?

Marco Cortella
SpagoBI Developer
[WWW]
carro.spw

Newby

Joined: 03/02/2012 09:29:16
Messages: 10
Offline

Hello,
thanks for your kind reply,
The issue with 3.3. version is that I can't s start Spago BI server, even if tomcat is properly configured and is running.
The error I get when starting Spago Bi server in 3.3 version is "/Spago ressource is not available".

For issue log I will post a comment tomorrow....( as right now I don't have access to the file)

Regards,
Carro
lia.spw

Newby

Joined: 21/02/2012 17:19:48
Messages: 11
Offline

Hi, I've experienced exactly the same create query problem starting up at this using the newest platform on all instanses

Error message in main frame"Could not open query editor - an exceptionwas thrown during initialization."
Error message in dialogue: "Impossible to open Query Editor, impossible to locate model file [] - OK"

I tried create the query by right clicking the business model root and follow the guide
I have a Spago BI Srv 3.3 installed on Ubuntu 11.10 Srv
Database MySQL 5.1
Eclipse with Spago BI Meta/Studio 3.3

For error log file: see below

Best regards and hope that somebody can help us
Lars

java.lang.NullPointerException
at it.eng.spagobi.meta.querybuilder.ui.editor.SpagoBIDataSetEditor.init(SpagoBIDataSetEditor.java:185)
at org.eclipse.ui.internal.EditorManager.createSite(EditorManager.java:79
at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:647)
at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:465)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:595)
at org.eclipse.ui.internal.EditorReference.getEditor(EditorReference.java:289)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditorBatched(WorkbenchPage.java:2863)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:276
at org.eclipse.ui.internal.WorkbenchPage.access$11(WorkbenchPage.java:2760)
at org.eclipse.ui.internal.WorkbenchPage$10.run(WorkbenchPage.java:2711)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2707)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2691)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2674)
at org.eclipse.ui.ide.IDE.openEditorOnFileStore(IDE.java:1155)
at it.eng.spagobi.meta.model.business.commands.generate.CreateQueryCommand.openQueryEditor(CreateQueryCommand.java:164)
at it.eng.spagobi.meta.model.business.commands.generate.CreateQueryCommand.execute(CreateQueryCommand.java:84)
at org.eclipse.emf.common.command.BasicCommandStack.execute(BasicCommandStack.java:84)
at it.eng.spagobi.meta.editor.business.wizards.AbstractSpagoBIModelWizard.performFinish(AbstractSpagoBIModelWizard.java:51)
at it.eng.spagobi.meta.editor.business.wizards.inline.NewQueryFileWizard.performFinish(NewQueryFileWizard.java:103)
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.meta.editor.business.actions.CreateQueryAction.run(CreateQueryAction.java:69)
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
 
Forum Index » Technical Help - SpagoBI META
Go to:   
Powered by JForum 2.1.9 © JForum Team