Unable to load URL

[Former Member]

Hello Everybody

I am getting 'Unable to load URL'  when I paste WSDL url into Web Service Query and press 'Import' button

Following are steps I followed

1. Created a Webi report from Bex query

2. Published a Web service URL

3. Opened a blank Xcelsius Dashboard, and data manager window from Connections and pasted WSDL URL and clicked 'Import'

then I am getting an error as >> Unable to load URL

http://xxxx:8080/dswsbobje/qaawsservices/biws?WSDL=1&cuid=AcA6UcrYvnlBpw5haeXuDLI

I also tested the above url in web browser and its returning proper xml

any help would be greatly appreciated. I am supposed to show some changes in dashboard by today evening

Thanks

Sandeep

[Former Member]

Hi,

http://scn.sap.com/thread/1798867

http://everythingxcelsius.com/xcelsius-training/xcelsius-and-business-intelligence-web-services-biws...

  After you build the web service through QaaWS, it should provide a URL. Test this URL in IE to make sure you see that XML is being generated.

  Then once in Xcelsius, open up Connection and create a new Query As A Web Service. Paste the URL into the WSDL URL field of the new connection. Press the import button. If everything (security, config, etc.) is in place additional fields should become active.

A developer needs FULL rights to QaaWS. Also make sure you have privs for the universe AND the connection that the universe uses.

But if those things are in order, try copying the link provided in QaaWS and pasting it direct into a browser URL box. You should see a bit of XML on the page (nothing more than a string of code). If that doesnt work, then you are having trouble accessing the server (firewall if applicable, or privs )

Try opening the SWF from Infoview. In new shops the database server usually doesnt trust the BOBJ servers at first. Also, make sure you understand what the Flash Global Security Settings do (google it) and if you need to config the Flash settings.

  If you are still having trouble, then D/L Charles and read the logs when you try to paste the qaaws link...the server that is blocking you will be revealed...then you can start troubleshooting from there.

Regards

NK

[Former Member]

Found the solution...

You have to have Administrative rights and create WSDL URL on Enterprice For reported created with Administrative rights. So both Report and URL should be created with proper Administrative rights to solve this issue