[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: Empty model with PostgreSQL [SOLVED]  XML
Forum Index » Technical Help - SpagoBI META
Author Message
hiperusera.spw

Newby

Joined: 30/12/2010 17:50:13
Messages: 37
Offline

I'm still having the same problem with version 3.1 and PostgreSQL 9.
Any fix?. Thanks
deepak.grmani.spw



Joined: 14/10/2011 14:32:07
Messages: 4
Offline

I am facing the same issue for SQL Server 2005, can anyone tell me if the issue is fixed? If yes please tell me the solution?
macortel

SpagoBI hero
[Avatar]

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

For those facing the "Empty model problem" with PostgreSQL:

I tried to create a metamodel with a simple database and I don't have an empty model with this operations (the second step is very important):
1- In the select connection page, in the New Metamodel wizard, select your connection to your PostegreSQL database
2- This will populate the Catalog combo box, now you must select your catalog so click on it (even if there is only one avaiable option)
3- After this selection, the Schema combo box will be populated with the avaiable schemas (I have selected "public" because my sample db is in this schema)
4- Now click next and you must see your tables to import in the Physical Model (and later in the Business Model).

I'm using the last version of PostgreSQL 9.1 avaiable on the website with the JDBC4 drivers.
Try this steps and tell me if you have problems.

Marco Cortella
SpagoBI Developer
[WWW]
deepak.grmani.spw



Joined: 14/10/2011 14:32:07
Messages: 4
Offline

any solutions for MS SQL Server 2005/2008 ?
mfcanovas.spw

SpagoBI friend

Joined: 20/09/2010 11:14:49
Messages: 59
Offline

Thank you very much!!!

I tried everything, I can't understand why I didn't try that.

Now, it works :)
macortel

SpagoBI hero
[Avatar]

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

Just a note, the previous operations are valid for the same problem (Empty model) with HSQLDB.

For SQL Server 2005 we are trying to do a test in the next days.

Marco Cortella
SpagoBI Developer
[WWW]
macortel

SpagoBI hero
[Avatar]

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

deepak.grmani.spw wrote:any solutions for MS SQL Server 2005/2008 ?


Have you selected the correct catalog when you are creating the model? (see the previuos post for PostgreSQL with similar problem)
I've done successfully a test with SQL Server 2005 using the last sqljdbc4 drivers.

Marco Cortella
SpagoBI Developer
[WWW]
tiramakantraore.spw



Joined: 26/11/2011 22:29:51
Messages: 1
Offline

Hello,
I got the same problem with Postgresql 9.1, It seems to be due to then JDBC driver.
Because when I try With an ORACLE JDBC, it works fine.
Can you please tell me what is the right version of the JDBC to use ?
macortel

SpagoBI hero
[Avatar]

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

Hi, try with postgresql-9.1-901.jdbc4 and check that you have jdk 1.6 installed.

Marco Cortella
SpagoBI Developer
[WWW]
dannyferc.spw



Joined: 28/02/2013 09:37:33
Messages: 7
Offline

Hi,

I have the same problem using server 3.6 and postgres 9.2, which driver should I use? Thank you.

Best,
Daniel
douglascarjo.spw



Joined: 02/02/2016 16:37:47
Messages: 4
Offline

HI, i know here said "solved", but i face this problem with Postgresql 9.5 and SpagoBI all in one 5.1, i did all that is suggested here, but my postgresql doesn't show anything, just a blank page in the spagoBI, at the spagoBI studio it have everything, the BI model with the Physical model, dimensions and the cube, but when i upload it, is just blank...

i appreciate any help with this matter and thank you.
 
Forum Index » Technical Help - SpagoBI META
Go to:   
Powered by JForum 2.1.9 © JForum Team