[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 
Query Editor Cannot be opened: Impossible to locate model file []  XML
Forum Index » Technical Help - SpagoBI STUDIO
Author Message
simonep.spw



Joined: 09/11/2011 15:04:52
Messages: 6
Offline

macortel wrote:
simonep.spw wrote:Hi, I had the same error. After reading "problem while querying business model" I inspected the log metacompiler_errors.txt and I realized it was a compiler error.

In my case it was incidental, I had a two tables: one named "ANNU_R_DATI_BRA" the other "ANNU_R_DATI_BRA_PK" which creates a conflict in the java class generation.

In any case I'd check for metaclasses compilation errors.

BTW, anyone knows how to control the java class name generated? I tried changing business name to no avail.

... now I'm stuck with another problem (another post) ...


Yes, this could be a bug and will check a fix in the future.
Could you try to rename the physical tables on the database and check if the problem is still present?


Yes, I got beyond that by not using both tables and had the other problem as on the thread Another Query Creation problem
buzzy96.spw

Newby

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

Have anyone found a solution to this problem when connecting to My SQL db??? .
dqvn.spw



Joined: 04/03/2012 02:53:55
Messages: 8
Offline

I fixed for this error: "Query Editor Cannot be opened: Impossible to locate model file []"

It is simple that you didn't add the business class by right click on Business Model: MyModel > Edit > Add ...(table)... class.

Then you choose > Create > Query > ...

The query model will appear. I think the error need to be catch and throw the right error in SpagoBI such as "You need add business class" or "the business class is empty".

dqvn.spw



Joined: 04/03/2012 02:53:55
Messages: 8
Offline

Again, the number of class business must more than one (>=1)

This message was edited 1 time. Last update was at 11/03/2012 17:09:06

arahman.spw



Joined: 07/06/2012 10:03:44
Messages: 9
Offline

I have similar errors when im trying to create a business model and adding tables to it. im using XP and the database is postgres.
Can some one please help me with removing these errors.
macortel

SpagoBI hero
[Avatar]

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

Hi,
please follow this guidelines to report your problem: https://www.spagoworld.org/jforum/posts/list/1346.page

Thanks.

Marco Cortella
SpagoBI Developer
[WWW]
arahman.spw



Joined: 07/06/2012 10:03:44
Messages: 9
Offline

- Windows XP, 32 bit edition

- Version of SpagoBI Studio / Meta: Version: 3.6.2
Build id: M20110210-1200

- DBMS and version are you using to create a Metamodel and query:

Postgres Version 9.0 Release - 1.12.2

- Always look a the logs file for any errors (ex: if your SpagoBI Studio is installed in C:\SpagoBIStudio your logs file are located in C:\SpagoBIStudio\logs\spagobi )
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-23 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-28 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-05-28 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewModelWizardFileCreationPage.getModelsPresent:209 - error in retrieving other models, go ahead as default case
2012-06-06 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewQueryFileProjectExplorerWizard.performFinish:112 - could not link to model metadata
java.lang.NullPointerException: null
at it.eng.spagobi.meta.model.serializer.EmfXmiSerializer.deserialize(EmfXmiSerializer.java:13 ~[it.eng.spagobi.meta.model_3.4.0.jar:na]
at it.eng.spagobi.meta.editor.multi.wizards.NewQueryFileProjectExplorerWizard.performFinish(NewQueryFileProjectExplorerWizard.java:97) ~[it.eng.spagobi.meta.editor_3.4.0.jar:na]
at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:811) [org.eclipse.jface_3.6.2.M20110210-1200.jar:na]
at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:430) [org.eclipse.jface_3.6.2.M20110210-1200.jar:na]
at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624) [org.eclipse.jface_3.6.2.M20110210-1200.jar:na]
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234) [org.eclipse.swt.win32.win32.x86_3.6.2.v3659c.jar:na]
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) [org.eclipse.swt.win32.win32.x86_3.6.2.v3659c.jar:na]
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053) [org.eclipse.swt.win32.win32.x86_3.6.2.v3659c.jar:na]
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066) [org.eclipse.swt.win32.win32.x86_3.6.2.v3659c.jar:na]
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657) [org.eclipse.swt.win32.win32.x86_3.6.2.v3659c.jar:na]
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825) [org.eclipse.jface_3.6.2.M20110210-1200.jar:na]
at org.eclipse.jface.window.Window.open(Window.java:801) [org.eclipse.jface_3.6.2.M20110210-1200.jar:na]
at it.eng.spagobi.meta.editor.popup.actions.CreateQueryProjectExplorerAction.createQueryFile(CreateQueryProjectExplorerAction.java:111) [it.eng.spagobi.meta.editor_3.4.0.jar:na]
at it.eng.spagobi.meta.editor.popup.actions.CreateQueryProjectExplorerAction.run(CreateQueryProjectExplorerAction.java:87) [it.eng.spagobi.meta.editor_3.4.0.jar:na]
at it.eng.spagobi.studio.core.views.actionProvider.ResourceNavigatorActionProvider$14.run(ResourceNavigatorActionProvider.java:430) [it.eng.spagobi.studio.core_3.4.0.jar:na]
at org.eclipse.jface.action.Action.runWithEvent(Action.java:49 [org.eclipse.jface_3.6.2.M20110210-1200.jar:na]
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584) [org.eclipse.jface_3.6.2.M20110210-1200.jar:na]
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501) [org.eclipse.jface_3.6.2.M20110210-1200.jar:na]
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411) [org.eclipse.jface_3.6.2.M20110210-1200.jar:na]
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) [org.eclipse.swt.win32.win32.x86_3.6.2.v3659c.jar:na]
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053) [org.eclipse.swt.win32.win32.x86_3.6.2.v3659c.jar:na]
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066) [org.eclipse.swt.win32.win32.x86_3.6.2.v3659c.jar:na]
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657) [org.eclipse.swt.win32.win32.x86_3.6.2.v3659c.jar:na]
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640) [org.eclipse.ui.workbench_3.6.2.M20110210-1200.jar:na]
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604) [org.eclipse.ui.workbench_3.6.2.M20110210-1200.jar:na]
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:243 [org.eclipse.ui.workbench_3.6.2.M20110210-1200.jar:na]
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671) [org.eclipse.ui.workbench_3.6.2.M20110210-1200.jar:na]
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) [org.eclipse.core.databinding.observable_1.3.0.I20100601-0800.jar:na]
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664) [org.eclipse.ui.workbench_3.6.2.M20110210-1200.jar:na]
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) [org.eclipse.ui.workbench_3.6.2.M20110210-1200.jar:na]
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115) [org.eclipse.ui.ide.application_1.0.201.M20100707-0800.jar:na]
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196) [org.eclipse.equinox.app_1.3.1.R36x_v20100803.jar:na]
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110) [org.eclipse.osgi_3.6.2.R36x_v20110210.jar:na]
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79) [org.eclipse.osgi_3.6.2.R36x_v20110210.jar:na]
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369) [org.eclipse.osgi_3.6.2.R36x_v20110210.jar:na]
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) [org.eclipse.osgi_3.6.2.R36x_v20110210.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_32]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_32]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_32]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_32]
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620) [org.eclipse.equinox.launcher_1.1.1.R36x_v20101122_1400.jar:na]
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575) [org.eclipse.equinox.launcher_1.1.1.R36x_v20101122_1400.jar:na]
at org.eclipse.equinox.launcher.Main.run(Main.java:140 [org.eclipse.equinox.launcher_1.1.1.R36x_v20101122_1400.jar:na]

- A simple summary of the steps required to reproduce the error
Create a business model and add tables to the process and when you click finish there are lots of errors.
macortel

SpagoBI hero
[Avatar]

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

Have you cheked if the connection to the database is ok (with the test)?

Because I see this error:
"2012-06-06 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewQueryFileProjectExplorerWizard.performFinish:112 - could not link to model metadata
java.lang.NullPointerException: null "

Marco Cortella
SpagoBI Developer
[WWW]
arahman.spw



Joined: 07/06/2012 10:03:44
Messages: 9
Offline

Yes it says ping successful
arahman.spw



Joined: 07/06/2012 10:03:44
Messages: 9
Offline

When i try creating a new model i get this:

Impossible to generate metamodel
Impossible to initialize the model
eclipse.buildId=unknown
java.version=1.6.0_32
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86


Error
Wed Jun 06 01:02:47 PDT 2012
Could not install bundle plugins/org.eclipse.wtp.web.capabilities_1.0.100.v201005102000.jar Bundle "org.eclipse.wtp.web.capabilities" version "1.0.100.v201005102000" has already been installed from: reference:file:plugins/org.eclipse.wtp.web.capabilities_1.0.100.v201005102000.jar

eclipse.buildId=unknown
java.version=1.6.0_32
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86


Error
Wed Jun 06 01:02:47 PDT 2012
Could not install bundle plugins/org.eclipse.wtp.xml.capabilities_1.0.100.v201005102000.jar Bundle "org.eclipse.wtp.xml.capabilities" version "1.0.100.v201005102000" has already been installed from: reference:file:plugins/org.eclipse.wtp.xml.capabilities_1.0.100.v201005102000.jar



And lots of similar errors
macortel

SpagoBI hero
[Avatar]

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

I'm checking the code but the error:
""2012-06-06 ERROR it.eng.spagobi.meta.editor.multi.wizards.NewQueryFileProjectExplorerWizard.performFinish:112 - could not link to model metadata
java.lang.NullPointerException: null "

is related to the Query creation and not the Business Model creation.

I suggest to erase the log files and retry the operations to get the currents errors.

Marco Cortella
SpagoBI Developer
[WWW]
arahman.spw



Joined: 07/06/2012 10:03:44
Messages: 9
Offline

After deleting the logs and creating a business model, this is what i get :
java.lang.RuntimeException: Impossible to initialize the model
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.createModel(SpagoBIModelEditorWizard.java:251)
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.performFinish(SpagoBIModelEditorWizard.java:22
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$11.run(ResourceNavigatorActionProvider.java:377)
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:350)
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.createModel(SpagoBIModelEditorWizard.java:24
... 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:305)
... 41 more
Caused by: java.lang.RuntimeException: Impossible to initialize physical model
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.initialize(PhysicalModelInitializer.java:133)
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard$1.run(SpagoBIModelEditorWizard.java:331)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: java.lang.RuntimeException: Impossible to initialize foreignKeys metadata
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.addForeignKeys(PhysicalModelInitializer.java:54
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.initialize(PhysicalModelInitializer.java:99)
... 2 more
Caused by: java.sql.SQLException: ERROR: function information_schema._pg_keypositions() does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3237)
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys(AbstractJdbc2DatabaseMetaData.java:3533)
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.addForeignKeys(PhysicalModelInitializer.java:451)
... 3 more


null
Error
Thu Jun 07 03:39:27 PDT 2012
Impossible to generate metamodel

java.lang.RuntimeException: Impossible to initialize the model
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.createModel(SpagoBIModelEditorWizard.java:251)
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.performFinish(SpagoBIModelEditorWizard.java:22
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$11.run(ResourceNavigatorActionProvider.java:377)
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:350)
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.createModel(SpagoBIModelEditorWizard.java:24
... 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:305)
... 41 more
Caused by: java.lang.RuntimeException: Impossible to initialize physical model
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.initialize(PhysicalModelInitializer.java:133)
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard$1.run(SpagoBIModelEditorWizard.java:331)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: java.lang.RuntimeException: Impossible to initialize foreignKeys metadata
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.addForeignKeys(PhysicalModelInitializer.java:54
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.initialize(PhysicalModelInitializer.java:99)
... 2 more
Caused by: java.sql.SQLException: ERROR: function information_schema._pg_keypositions() does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3237)
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys(AbstractJdbc2DatabaseMetaData.java:3533)
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.addForeignKeys(PhysicalModelInitializer.java:451)
... 3 more


null
Error
Thu Jun 07 03:39:27 PDT 2012
Impossible to generate metamodel

java.lang.RuntimeException: Impossible to initialize the model
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.createModel(SpagoBIModelEditorWizard.java:251)
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.performFinish(SpagoBIModelEditorWizard.java:22
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$11.run(ResourceNavigatorActionProvider.java:377)
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:350)
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.createModel(SpagoBIModelEditorWizard.java:24
... 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:305)
... 41 more
Caused by: java.lang.RuntimeException: Impossible to initialize physical model
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.initialize(PhysicalModelInitializer.java:133)
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard$1.run(SpagoBIModelEditorWizard.java:331)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: java.lang.RuntimeException: Impossible to initialize foreignKeys metadata
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.addForeignKeys(PhysicalModelInitializer.java:54
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.initialize(PhysicalModelInitializer.java:99)
... 2 more
Caused by: java.sql.SQLException: ERROR: function information_schema._pg_keypositions() does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3237)
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys(AbstractJdbc2DatabaseMetaData.java:3533)
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.addForeignKeys(PhysicalModelInitializer.java:451)
... 3 more


null
Error
Thu Jun 07 03:39:27 PDT 2012
Impossible to generate metamodel

java.lang.RuntimeException: Impossible to initialize the model
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.createModel(SpagoBIModelEditorWizard.java:251)
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.performFinish(SpagoBIModelEditorWizard.java:22
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$11.run(ResourceNavigatorActionProvider.java:377)
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:350)
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard.createModel(SpagoBIModelEditorWizard.java:24
... 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:305)
... 41 more
Caused by: java.lang.RuntimeException: Impossible to initialize physical model
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.initialize(PhysicalModelInitializer.java:133)
at it.eng.spagobi.meta.editor.multi.wizards.SpagoBIModelEditorWizard$1.run(SpagoBIModelEditorWizard.java:331)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: java.lang.RuntimeException: Impossible to initialize foreignKeys metadata
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.addForeignKeys(PhysicalModelInitializer.java:54
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.initialize(PhysicalModelInitializer.java:99)
... 2 more
Caused by: java.sql.SQLException: ERROR: function information_schema._pg_keypositions() does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3237)
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys(AbstractJdbc2DatabaseMetaData.java:3533)
at it.eng.spagobi.meta.initializer.PhysicalModelInitializer.addForeignKeys(PhysicalModelInitializer.java:451)
... 3 more


macortel

SpagoBI hero
[Avatar]

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

Thanks, now I have some useful information.

The problem seems related to the JDBC Driver for Postgres that you are using.

"ERROR: function information_schema._pg_keypositions() does not exist"

This is actually a sign that you are using an 8.0 jdbc driver against an 8.1 (or newer) server. You need the 8.1 driver.
Also see this posts:
http://archives.postgresql.org/pgsql-general/2005-12/msg00060.php
https://forum.hibernate.org/viewtopic.php?t=957909&view=next

This message was edited 2 times. Last update was at 07/06/2012 12:57:06


Marco Cortella
SpagoBI Developer
[WWW]
arahman.spw



Joined: 07/06/2012 10:03:44
Messages: 9
Offline

I tried 3 different versions of the drivers which were all newer but then the database does not connect and gives an error
macortel

SpagoBI hero
[Avatar]

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

Have you tried postgresql-9.0-801.jdbc4.jar ?

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