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 Name:BIRT Data Engine
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).
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!