Trouble using SpagoBI as data source/set in birt using spagobi eclipse plug in

Hi:

I have been having issues getting a good connection to the spagobi server as a data source.

I have found that the "test" button is about as useful as the machine that goes ping

No matter what I put into the fields I get "Ping Succeeded".

So I just put in the url of the SpagoBI and the user name/ password and carry on.

Then to get the data set I put it in the name in spagobi and then it fails and says.

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.6.2.r262_v20110215
Error Code:data.engine.fail.prepareExecution
Error Message:Failed to prepare the query execution for the data set: DATASETNAME
Failed to prepare the following query for the data set type (spagobi.birt.oda.dataSet).
[DATASETNAME]
org.eclipse.datatools.connectivity.oda.OdaException: Impossible to prepare query [DATASETNAME] ;
java.lang.RuntimeException: Impossible to retrive spagobi's dataset list

Any help would be appreciated! Thanks!

Joe

hi,

i too have d same problem.....how can i fix this exception n proceed further pls.....do reply....im waiting for d reply here

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.6.2.r262_v20110215
Error Code:data.engine.fail.prepareExecution
Error Message:Failed to prepare the query execution for the data set: Data Set
Failed to prepare the following query for the data set type (spagobi.birt.oda.dataSet).
[db]
org.eclipse.datatools.connectivity.oda.OdaException: Impossible to prepare query [db] ;
java.lang.RuntimeException: Impossible to retrive store metadata for dataset [db]

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.6.2.r262_v20110215
Error Code:data.engine.fail.prepareExecution
Error Message:Failed to prepare the query execution for the data set: Data Set
Failed to prepare the following query for the data set type (spagobi.birt.oda.dataSet).
[db]
org.eclipse.datatools.connectivity.oda.OdaException: Impossible to prepare query [db] ;
java.lang.RuntimeException: Impossible to retrive store metadata for dataset [db]

Hi,
when retrieving the dataset you should type your dataset Label, as saved on SpagoBI Server, is it DATASETNAME in your case?

Yes it is

One of the better place to learn everything about Download youtube videos and change their Media Type.Click on this convert youtube to mp3 and then you get to know that really this is the only learning and Downloading website for the youtube videos.Thanks.