[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 
Problem while querying business model  XML
Forum Index » Technical Help - SpagoBI STUDIO
Author Message
dancap.spw

Newby
[Avatar]
Joined: 15/10/2011 10:16:00
Messages: 17
Location: Italy
Offline

Hello.
I've encountered a problem while trying to query every meta model I create under SpagoBI Studio 3.1.

I succesfully create a model, associate it to a mysql datasource, choose relations between tables and set measures, cube and dimension without any difficult; but when I try to create a query, I receive a message box saying "Query Editor Cannot be opened: Impossible to locate model file []".
If I create the model making it pointing to a file in my filesystem, then the message box text says: "Query Editor Cannot be opened: Impossible to locate model file [pathfile]", where saying pathfile I mean the path of the file I'm referring to.

The error is similar to the post by sandeepchandra http://www.spagoworld.org/jforum/posts/list/765.page but the solution provided by 1delcruz wasn't totally clear to me.

My O.S. is Ubuntu 9.10 (Karmic Koala), SpagoBI Studio vers. 3.1.

In a while I will post the stacktrace.

Every help would be very appreciated, thank you.

-Daniele Cappellani-


- - -
- Daniele Cappellani -
dancap.spw

Newby
[Avatar]
Joined: 15/10/2011 10:16:00
Messages: 17
Location: Italy
Offline

Here is the stack trace:

java.lang.NullPointerException
at it.eng.spagobi.meta.querybuilder.ui.editor.SpagoBIDataSetEditor.init(SpagoBIDataSetEditor.java:183)
at org.eclipse.ui.internal.EditorManager.createSite(EditorManager.java:82
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.PartPane.setVisible(PartPane.java:313)
at org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:180)
at org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:270)
at org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:65)
at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:473)
at org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1245)
at org.eclipse.ui.internal.PartStack.setSelection(PartStack.java:119
at org.eclipse.ui.internal.PartStack.showPart(PartStack.java:1597)
at org.eclipse.ui.internal.PartStack.add(PartStack.java:493)
at org.eclipse.ui.internal.EditorStack.add(EditorStack.java:103)
at org.eclipse.ui.internal.PartStack.add(PartStack.java:479)
at org.eclipse.ui.internal.EditorStack.add(EditorStack.java:112)
at org.eclipse.ui.internal.EditorSashContainer.addEditor(EditorSashContainer.java:63)
at org.eclipse.ui.internal.EditorAreaHelper.addToLayout(EditorAreaHelper.java:225)
at org.eclipse.ui.internal.EditorAreaHelper.addEditor(EditorAreaHelper.java:213)
at org.eclipse.ui.internal.EditorManager.createEditorTab(EditorManager.java:80
at org.eclipse.ui.internal.EditorManager.openEditorFromDescriptor(EditorManager.java:707)
at org.eclipse.ui.internal.EditorManager.openEditor(EditorManager.java:666)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditorBatched(WorkbenchPage.java:2942)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:2850)
at org.eclipse.ui.internal.WorkbenchPage.access$11(WorkbenchPage.java:2842)
at org.eclipse.ui.internal.WorkbenchPage$10.run(WorkbenchPage.java:2793)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2789)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2773)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2764)
at org.eclipse.ui.ide.IDE.openEditor(IDE.java:651)
at org.eclipse.ui.ide.IDE.openEditor(IDE.java:610)
at org.eclipse.ui.actions.OpenFileAction.openFile(OpenFileAction.java:99)
at org.eclipse.ui.actions.OpenSystemEditorAction.run(OpenSystemEditorAction.java:99)
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:866)
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:864)
at org.eclipse.jface.viewers.StructuredViewer.handleOpen(StructuredViewer.java:1152)
at org.eclipse.ui.navigator.CommonViewer.handleOpen(CommonViewer.java:462)
at org.eclipse.jface.viewers.StructuredViewer$6.handleOpen(StructuredViewer.java:1256)
at org.eclipse.jface.util.OpenStrategy.fireOpenEvent(OpenStrategy.java:275)
at org.eclipse.jface.util.OpenStrategy.access$2(OpenStrategy.java:269)
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:309)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:125
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:358
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3209)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2696)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123)
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:344)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
at org.eclipse.equinox.launcher.Main.run(Main.java:1410)

- - -
- Daniele Cappellani -
macortel

SpagoBI hero
[Avatar]

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

Hi.
You have to look at the metacompiler.log in the log directory an copy the error so We can have information to investigate the problem.
Thanks.

Marco Cortella
SpagoBI Developer
[WWW]
dancap.spw

Newby
[Avatar]
Joined: 15/10/2011 10:16:00
Messages: 17
Location: Italy
Offline

macortel wrote:Hi.

Hello to you :)

macortel wrote:
You have to look at the metacompiler.log in the log directory an copy the error so We can have information to investigate the problem.

In my log dir there are two files: metacompiler_out.log, that is empty, and metacompiler_errors.log, fullfilled with error lines.
In metacompiler_errors.log i found this kind of error for each column defined in tables I added to model, for example:

----------
120. ERROR in /home/assistenza/workspace/TestMeta/models/TestXogMetaModel/src/it/eng/spagobi/meta/ProductCustomer.java (at line 20)
@Id
^^
Id cannot be resolved to a type
----------
121. ERROR in /home/assistenza/workspace/TestMeta/models/TestXogMetaModel/src/it/eng/spagobi/meta/ProductCustomer.java (at line 21)
@Column(name="id")
^^^^^^
Column cannot be resolved to a type
----------
122. ERROR in /home/assistenza/workspace/TestMeta/models/TestXogMetaModel/src/it/eng/spagobi/meta/ProductCustomer.java (at line 21)
@Column(name="id")
^^^^
The attribute name is undefined for the annotation type Column
----------


The first line says instead:

----------
1. ERROR in home/assistenza/workspace/TestMeta/models/TestXogMetaModel/src/it/eng/spagobi/meta/ProductCustomer.java (at line 4)
import javax.persistence.*;
^^^^^^^^^^^^^^^^^
The import javax.persistence cannot be resolved
----------


But when the error message shows to me while trying to open a new meta query in the editor, no lines are appended to this log file.

Please tell me if I can do more in order to make you understand in the best way the problem and if I can do anything to set it up in the right way.

macortel wrote:
Thanks.

Thanks a lot to you.

- - -
- Daniele Cappellani -
macortel

SpagoBI hero
[Avatar]

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

It Seems that our compiler have problem generating some mapping classes. In particular the error "The import javax.persistence cannot be resolved " is very strange. I suppose that this could be an OS-related problem.

Marco Cortella
SpagoBI Developer
[WWW]
dancap.spw

Newby
[Avatar]
Joined: 15/10/2011 10:16:00
Messages: 17
Location: Italy
Offline

macortel wrote:It Seems that our compiler have problem generating some mapping classes. In particular the error "The import javax.persistence cannot be resolved " is very strange. I suppose that this could be an OS-related problem.


Could it be a problem related to tomcat? I used the Spago All in One 3.1 package available on OW2 Forge.

Please tell me if I can do more tests or if I can be useful to you in any way.

I am downloading and installing the whole system in a Windows 7 32bit machine to try it in a different O.S. than Ubuntu.

- - -
- Daniele Cappellani -
macortel

SpagoBI hero
[Avatar]

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

No, I don't think is related to Tomcat.
Are you using Ubuntu 64 o 32bit?

Marco Cortella
SpagoBI Developer
[WWW]
macortel

SpagoBI hero
[Avatar]

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

Sorry, what kind of DBMS are you using?
and what kind and version of JVM are you using?

This message was edited 1 time. Last update was at 18/10/2011 11:28:42


Marco Cortella
SpagoBI Developer
[WWW]
dancap.spw

Newby
[Avatar]
Joined: 15/10/2011 10:16:00
Messages: 17
Location: Italy
Offline

macortel wrote:Sorry, what kind of DBMS are you using?
and what kind and version of JVM are you using?


I'm using:
* Ubuntu 32 9.04 (Karmic Koala)
* MySQL version 5.1.37-1ubuntu5.5
* JDBC version 5.1.18
* javac version 1.6.0


- - -
- Daniele Cappellani -
mospinel

SpagoBI friend
[Avatar]

Joined: 14/07/2010 10:14:20
Messages: 91
Offline

Hi Daniele,
I'm sorry but to understand the problem we need more details. I tried to reproduce the error on my computer but it didn't succeed, so let's try together to understand the problem.
You could run the following shell command, please?

sudo update-alternatives --config java


Thanks in advance
dancap.spw

Newby
[Avatar]
Joined: 15/10/2011 10:16:00
Messages: 17
Location: Italy
Offline

mospinel wrote:Hi Daniele,
I'm sorry but to understand the problem we need more details. I tried to reproduce the error on my computer but it didn't succeed, so let's try together to understand the problem.
You could run the following shell command, please?

sudo update-alternatives --config java


Thanks in advance


First of all thanks to you for all attention you paid to my problem.

update-alternatives said (in italian):

È presente una sola alternativa nel gruppo java: /usr/lib/jvm/java-6-openjdk/jre/bin/java
Nulla da configurare.

that should sound (for everyone here not speaking our fabulous language ) like "There is only one alternative in java group: /usr/lib/jvm/java-6-openjdk/jre/bin/java Nothing to configure"

Anyway, now you can see exactly java version installed in my o.s.

- - -
- Daniele Cappellani -
mospinel

SpagoBI friend
[Avatar]

Joined: 14/07/2010 10:14:20
Messages: 91
Offline

We are here to try to help Your problem may help us to improve SpagoBI.
Try you to install java-6-sun, because your problem seems related to an error in java code compiling.

dancap.spw

Newby
[Avatar]
Joined: 15/10/2011 10:16:00
Messages: 17
Location: Italy
Offline

I installed java-6-sun package, removed the openjdk and selected it by update-alternatives command.

Now Eclipse seems to point to the right jre, by the way I still get that error.

Moreover, if I compile <table_name>.java class under directory ~/workspace/TestMeta/models/TestXogMetaModel/src/it/eng/spagobi/meta/<table_name>.java from bash with javac, i get the same errors I found before in metacompiler.log.

Please tell me if I can do anything else to help you to find out what's the matter.

Thanks in advance.

P.S.: It's probably an O.S. issue, because I finished trying Windows version and I can execute queries, create datamarts and upload models to server without any difficult.
Unfortunately I really have to make it working also under Linux machines.

This message was edited 1 time. Last update was at 18/10/2011 16:38:51


- - -
- Daniele Cappellani -
macortel

SpagoBI hero
[Avatar]

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

Can you try to compile the same java classes generated in the Linux ambient but with you javac compiler in Windows?
Do you have the same errors?

Marco Cortella
SpagoBI Developer
[WWW]
dancap.spw

Newby
[Avatar]
Joined: 15/10/2011 10:16:00
Messages: 17
Location: Italy
Offline

macortel wrote:Can you try to compile the same java classes generated in the Linux ambient but with you javac compiler in Windows?
Do you have the same errors?


Yes, I have the same errors, and I do have the same errors also compiling classes generated in Windows ambient with Windows javac.

- - -
- Daniele Cappellani -
 
Forum Index » Technical Help - SpagoBI STUDIO
Go to:   
Powered by JForum 2.1.9 © JForum Team