[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 
Unable to save Business Queries  XML
Forum Index » Technical Help - SpagoBI STUDIO
Author Message
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

Hello Forum,

I try to create some business models and associated queries. Models are okay, but when I create the query, I am not able to save them! When opening the query, the selected tables are visible, but none of the selected fields, groups, etc. Can this be related to the JAVA version used?

Cheers,

Zsolt
macortel

SpagoBI hero
[Avatar]

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

Hi, what version of Java are you using?

Marco Cortella
SpagoBI Developer
[WWW]
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

Hi Marco,

I thought about the same! To use one of the tool, i had to install Java 1.7.0_09, and point the JAVA_HOME to this, but then my troubles started. I installed Java 1.6.27 64 bit, no change, then installed an earlier version, all the same. Then I thought that SpagoStudio is 32 bit, so I installed a 32 bit version of 1.6.21, no change. Removed all and went home :)

Now, I will install the 1.6.21 32bit version and try again. It is a problem, as all worked well and managed to iron out some issues.

Zsolt
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

Hi Marco,

This is the error I am receiving. In my model, there is one table! with 13 columns, in the query I select one of the columns and it does not work.

org.eclipse.ui.PartInitException: Impossible to initialize editor [it.eng.spagobi.meta.querybuilder.ui.editor.SpagoBIDataSetEditor]: An error occur while generating JPA jar
at it.eng.spagobi.meta.querybuilder.ui.editor.SpagoBIDataSetEditor.init(SpagoBIDataSetEditor.java:161)
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:150)
at it.eng.spagobi.meta.model.business.commands.generate.CreateQueryCommand.execute(CreateQueryCommand.java:70)
at org.eclipse.emf.common.command.BasicCommandStack.execute(BasicCommandStack.java:84)
at it.eng.spagobi.meta.editor.business.wizards.AbstractSpagoBIModelWizard.performFinish(AbstractSpagoBIModelWizard.java:39)
at it.eng.spagobi.meta.editor.business.wizards.inline.NewQueryFileWizard.performFinish(NewQueryFileWizard.java:83)
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:53)
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
macortel

SpagoBI hero
[Avatar]

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

Please look at the logs files and post any errors thath you will find.

Marco Cortella
SpagoBI Developer
[WWW]
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

Hi Marco,

There is no error in the LOG files!! this is the crazy thing. I tried on two different machines, the result is the same. The only error I have is in the Studio, 'A Handler Conflict Occured'

Now, I have to come up with a solution to be able to deliver to the Client by next week. Will use Jasper/Birt but not SpagoStudio.

Zsolt
macortel

SpagoBI hero
[Avatar]

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

Hi, I'm not sure that you are looking at the correct logs file. Have you seen this post? https://www.spagoworld.org/jforum/posts/list/1346.page

Marco Cortella
SpagoBI Developer
[WWW]
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

Hi Marco,

So,

OS: Win 7 64bit Pro
SpagoBI 3.6.0 - using the all-in-one version
DB to query: MS SQL 2008 R2
Java: 1.6.0_30 64bit, 1.6.0_27 32bit


SpagoBI is in a folder, located on the desktop. There are two files in the LOG directory with data inside: metagenerator and querybuilder. In none of them I found errors

Here is what I try to do:

- connect to the MS SQL 2008 R2 DB --> ok
- create a business model by selecting one single table --> ok
- create a business query from this one table --> ok
- select the different fields, set up filters, etc --> ok
- seeing the result of the previous step --> ok
- saving the Business Query --> NOT OK

If I close the query builder and reopen the query, only the table is shown as it was saved when I created the query. But I am not able to save the state when I selected the fields/filters/etc

I hope it helps,

Zsolt

zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

Marco,

I tried to use Meta 3.6, same settings as before, but this time I got an error message:

16:24:16.497 [main] DEBUG i.e.q.datasource.AbstractDataSource - i18n properties loaded form cache

!ENTRY org.eclipse.ui 4 4 2012-12-12 16:24:16.506
!MESSAGE Save Failed

!ENTRY org.eclipse.ui 2 0 2012-12-12 16:24:16.508
!MESSAGE Save Failed
!STACK 0
java.lang.RuntimeException: Impossible to save query
at it.eng.spagobi.meta.querybuilder.query.dao.QueryDAOFileImpl.getContentToSave(QueryDAOFileImpl.java:85)
at it.eng.spagobi.meta.querybuilder.ui.editor.SpagoBIDataSetEditor.doSave(SpagoBIDataSetEditor.java:324)
at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:151)
at org.eclipse.ui.internal.SaveableHelper$5.run(SaveableHelper.java:277)
at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:464)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:372)
at org.eclipse.jface.window.ApplicationWindow$1.run(ApplicationWindow.java:759)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.jface.window.ApplicationWindow.run(ApplicationWindow.java:756)
at org.eclipse.ui.internal.WorkbenchWindow.run(WorkbenchWindow.java:2606)
at org.eclipse.ui.internal.SaveableHelper.runProgressMonitorOperation(SaveableHelper.java:285)
at org.eclipse.ui.internal.SaveableHelper.runProgressMonitorOperation(SaveableHelper.java:264)
at org.eclipse.ui.internal.SaveableHelper.savePart(SaveableHelper.java:156)
at org.eclipse.ui.internal.EditorManager.savePart(EditorManager.java:1369)
at org.eclipse.ui.internal.WorkbenchPage.savePart(WorkbenchPage.java:3334)
at org.eclipse.ui.internal.WorkbenchPage.saveEditor(WorkbenchPage.java:3347)
at org.eclipse.ui.internal.SaveAction.run(SaveAction.java:76)
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$6.handleEvent(ActionContributionItem.java:452)
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: it.eng.qbe.serializer.SerializationException: An error occurred while serializing object: it.eng.qbe.query.Query@187a6dd
at it.eng.qbe.query.serializer.json.QueryJSONSerializer.serialize(QueryJSONSerializer.java:9
at it.eng.spagobi.meta.querybuilder.query.dao.QueryDAOFileImpl.getContentToSave(QueryDAOFileImpl.java:82)
... 44 more
Caused by: java.lang.NullPointerException
at it.eng.qbe.query.serializer.json.QueryJSONSerializer.serializeFilters(QueryJSONSerializer.java:466)
at it.eng.qbe.query.serializer.json.QueryJSONSerializer.serialize(QueryJSONSerializer.java:6
... 45 more
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

Ciao Marco,

Here is the crazy thing:

- Create model -->ok
- Create a query
--> select the fileds --> no way to save
--> add a filter --> meta 3.6 is crashing with the error posted above
--> remove the filter --> I AM ABLE TO SAVE THE QUERY :)
--> close the query builder
--> reopen the query --> IT WORKS!

Zsolt
macortel

SpagoBI hero
[Avatar]

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

In Query Editor the floppy disk icon (save icon) is enabled?

Marco Cortella
SpagoBI Developer
[WWW]
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

See the mail above, it is only enabled when I add a filter condition, but then it is crashing (see 2 mails before), if I remove the filter condition, it is enabled
macortel

SpagoBI hero
[Avatar]

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

Ok, could you please post a screenshot or write the filter condition that you are using?

Marco Cortella
SpagoBI Developer
[WWW]
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

:) tell me how can I post a screenshot and I will do it
There is no filter condition, I just select one field, put it as filter, save, crash, remove, save, hurrahhh, works
I posted the error message few post before
macortel

SpagoBI hero
[Avatar]

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

You can post your screenshot here: http://imageshack.us/ and link it in a post. Thanks.

Marco Cortella
SpagoBI Developer
[WWW]
 
Forum Index » Technical Help - SpagoBI STUDIO
Go to:   
Powered by JForum 2.1.9 © JForum Team