[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
mfcanovas.spw

SpagoBI friend

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

Resource Set for the business model and the physical model are empty after choosing the tables to import.

It works fine if I use a MySQL database as the data source.


This message was edited 1 time. Last update was at 04/11/2011 12:04:46

mfcanovas.spw

SpagoBI friend

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

I tried also using a luciddb database and apache derby.

Mysql database is the only I can get working.

Is anyone succesfuly using PostgreSQL as Metadata Model datasource?
angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

Thanks for the feedback. We will check it. If it is a bug we will fix it and release a patch next week.

AG

Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
david.spw



Joined: 27/06/2011 22:05:51
Messages: 3
Offline

I've the same problem with SQL Server 2008, reported at https://www.spagoworld.org/jforum/posts/list/0/620.page#1884. Please Help! I really want to use SPAGOBI.

Cheers,

David
[MSN]
diogochavana.spw



Joined: 01/07/2011 16:53:11
Messages: 1
Offline

I have the same problem with PostgreSql

Att,
Diogo Chavana
angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

Ok we have verified that this is a bug (http://www.spagoworld.org/jira/browse/SPAGOBI-626). We are really sorry for the unconvenience. We have already fix it on svn and so you can expect to dont have anymore this same problem in the next release of spagobi (version 3.1 will be released at the end of july).

Thank you all for the feedback.

AG

This message was edited 1 time. Last update was at 07/07/2011 18:48:35


Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
juddm.spw



Joined: 23/06/2011 15:32:07
Messages: 2
Location: London, United Kingdom
Offline

I also seem to have this problem.

I looked at the svn link in ow2web and svn://svn.forge.objectweb.org/svnroot/spagobi appears to only have data in the 1x branch - 2x and 3x are empty when I browse. I also tried to download the latest svn snapshot http://forge.ow2.org/svnsnapshots/spagobi-svn-latest.tar.gz which is also empty. Interestingly, the web browse appears to work but I'm not aware how to use this.

Edit: Actually the svn is populated now so perhaps I looked at it during some sort of refresh process. I will download and attempt a build - is there any guidance on building Meta?.

Is there any chance of rebuilding and releasing SpagoBI Meta early in order to facilitate new users evaluating SpagoBI on a platform other than mysqll?

Regards,

Mike

This message was edited 2 times. Last update was at 07/07/2011 08:25:37

[WWW]
macortel

SpagoBI hero
[Avatar]

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

The version 3.1 is out. We have fixed some problems with DBMS other than MySQL.

Marco Cortella
SpagoBI Developer
[WWW]
mfcanovas.spw

SpagoBI friend

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

I'm still having the same problem with version 3.1 and PostgreSQL
guhl.spw



Joined: 06/09/2011 15:53:51
Messages: 1
Offline

I am encountering the same problem with v3.1 and Postgres 9 on Windows as well as on Linux. I really would like to use Spago, because it´s the only Open Source BI tool with a good metadata layer and easy ad hoc reporting for end users.

Do you have news regarding this bug?

Cheers!
ashwini.spw



Joined: 04/10/2011 16:30:53
Messages: 5
Offline

We have checked using the New SpagoBI Meta & Studio 3.1 procedure as given on the demo. But we are still facing the same issue when we use a SQL Server 2005 connection and database. The ping is successful however the model is empty. Please advise.
macortel

SpagoBI hero
[Avatar]

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

What kind of driver adn version did you use when you define the connection?

Marco Cortella
SpagoBI Developer
[WWW]
ashwini.spw



Joined: 04/10/2011 16:30:53
Messages: 5
Offline

We have referenced sqljdbc.jar in the BusinessObjects Enterprise 12.0 java lib folder. Will this need to be placed somewhere else or please specify the location
ashwini.spw



Joined: 04/10/2011 16:30:53
Messages: 5
Offline

Can you please provide an update on this?
fabiocravio.spw



Joined: 12/10/2011 11:50:41
Messages: 1
Offline

I have updated the sqljdbc.jar driver, for using spago bi studio with sqlserver 2005, but I'm still having the same problem (the model is empty after chosing the table to import).
Regards,
Fabio
 
Forum Index » Technical Help - SpagoBI META
Go to:   
Powered by JForum 2.1.9 © JForum Team