error manage BI services data connection

system · December 22, 2015, 1:32pm

Hi,
I’m experiencing a error message when trying to set-up a BIWS for my xcelsius dashboard.

When I try to manage my BI services I’m getting:

unexpected error: failed to access the WSDL at https://:8443/dswsbobje/services/Session?wsdl.
it failed with: server returned HTTP response code: 500 for URL: https://:8443/dswsbobje/services/Session?wsdl.

When I copy the URL
https://:8443/dswsbobje
in a browser
–>I’m getting the default apache/tomcat page letting me click on the services, displaying al the deployed services

When I copy the URL:
https://:8443/dswsbobje/services/Session?wsdl.
→ I’m getting the: Please enable REST support in WEB-INF/conf/axis2.xml and WEB-INF/web.xml message

So that’s all fine…

Im logged in as a Administrator, so it isn’t a rights issue…

any one? (using BO 4.0 SP5)

Tiny (BOB member since 2004-11-10)

system · January 11, 2016, 7:35am

Try to add the server details from “Manage servers” and then click on “Refresh” button. Probably it will solve the issue.

vijesh.chandra (BOB member since 2009-05-29)

system · February 2, 2017, 9:20pm

Dear Tiny-

Did you resolve the issues? We are running with same issues? Can you please share solution if you found.

Regards
Lokesh

lokkeshh (BOB member since 2017-02-02)

system · February 2, 2017, 11:12pm

Hmmm… that doesn’t look like an authentic WSDL URL. Are you publishing a WEBI block into BIWS for use by your dashboard?

A WSDL should look similar to:

https://<SERVER>/dswsbobje/qaawsservices/biws?WSDL=1&amp;cuid=FgpR_FU1bwwAAToABJBJUSEKKCFam1ey

You should be able to authenticate and open the full WSDL in a browser and view the WSDL contents.

If not, you may need additional config on your Web Services server - tag your BOE admin dude with your error results and have him assist.

datawizard (BOB member since 2015-01-20)

system · February 2, 2017, 11:16pm

Hello-

I have access to servers, tell me what to do in it. I’m handling admin too. This error I’m seing first time.

Getting following error when I open webI report ( web service publisher ) whereas It works fine for DEV & QA environments

unexpected error: failed to access the WSDL at https://:8443/dswsbobje/services/Session?wsdl.
it failed with: server returned HTTP response code: 500 for URL: https://:8443/dswsbobje/services/Session?wsdl.

The exact issue as Tiny described. Give me fair solution if you experienced.

Regards
Lokesh

lokkeshh (BOB member since 2017-02-02)

system · February 3, 2017, 4:02am

Well I’m not an admin guy… and I have no idea how your installation is set up. HTTP Code 500 is a generic server error. Maybe your production firewall is blocking port 8443… What different authentication is being used for your production server? Are you using the Web server on BO or are you using a custom Java Web server? List goes on…

Start with comparing Dev/QA to Prod equip and config.

Using the prod WSDL created in prod right? Not Dev? Did you try re-publishing the WEBI prod block and using the newly created WSDL?

Paste the whole WSDL in a browser and see if it authenticates you into BO and returns the WSDL content. What browser errors do you get?

datawizard (BOB member since 2015-01-20)