Web Service Connection in Xcelsius 2008

other Xcelsius - Crystal Dashboard Design
1

I have recently upgraded from 4.5 to Xcelsius 2008 and am having trouble getting the Web Service Connections set up correctly for my QaaWS.

I have 7 LiveOffice connections in a model that seem to all refresh on load fine and i have already set up a Web Service Connection that picks up the drill through path of what the user has clicked on and used them as input parameters to a QaaWS query.

I now need to add another Web Service Connection for another QaaWS and i get the following error message;

“Unable to Load URL”

I have checked the available QaaWS services using dswsbobje/qaawsservices and the 2 queries appear as i would expect.

I have checked the dsws.properties file and the user name and password are correct (which i would expect as teh 1st connections works in the Xcelsius model.

I have restarted the Tomcat server and CMS and this does not cure the problem.

I have even tried re-installing QaaWS.

I have installed SP1 fix 1 for 2008. I am currently using XIR2 SP2.

Can anyone help as sometimes this functionality works and sometimes it does not. The 2 queries i want to use point aty teh ssame database and BO Universe.

anthonyjones :uk: (BOB member since 2008-03-10)

2

I am getting the same Unable To Load from URL issue too when trying to load a QAAWS. Any ideas?

dbobrow (BOB member since 2006-10-17)

3

Did you solve this problem? I get the same error.

toi100 (BOB member since 2009-05-12)

4

Not really the way you want, but we upgraded to BOXI 3.1 and everything works fine.

dbobrow (BOB member since 2006-10-17)

5

Hi,

We had this same issue and for us for some reason our IE browser settings were set to work offline, and hence Xcelsius inherited the setting of our browser.

Did you try to view the URL just in a regular browser to see if data is being returned? If it’s not then you probably have some type of security issue.

If not then check your browser settings to ensure you not working offline.

EverythingXcelsius :us: (BOB member since 2008-06-17)